29 lines
578 B
SQL
29 lines
578 B
SQL
--da eseguire come utente MNP
|
|
|
|
-- integrazione nella notifica a CCRM del codice dealer
|
|
ALTER TABLE MNP_CCRM_NOTIFICA_OUT add(
|
|
CODICE_DEALER VARCHAR2(10)
|
|
);
|
|
|
|
ALTER TABLE MNP_CCRM_RECUPERO_OUT add(
|
|
CODICE_DEALER VARCHAR2(10)
|
|
);
|
|
|
|
--TABLES MSS
|
|
|
|
CREATE TABLE MNP_INTERNAL_STATE (
|
|
INT_SYSTEM VARCHAR2(30) NOT NULL,
|
|
INT_KEY VARCHAR2(30) NOT NULL,
|
|
VALUE VARCHAR2(30) NOT NULL
|
|
)
|
|
TABLESPACE TAB_SMALL;
|
|
|
|
ALTER TABLE MNP_INTERNAL_STATE ADD
|
|
CONSTRAINT PK_MNP_INTERNAL_STATE
|
|
PRIMARY KEY(INT_SYSTEM,INT_KEY)
|
|
USING INDEX
|
|
TABLESPACE TAB_IDX_SMALL
|
|
NOLOGGING
|
|
ENABLE
|
|
VALIDATE;
|