105 lines
2.5 KiB
SQL
105 lines
2.5 KiB
SQL
--da eseguire come utente MNP
|
|
|
|
-------------------------------------------------------------------------
|
|
--SEQUENCE
|
|
|
|
|
|
-------------------------------------------------------------------------
|
|
--TABLES
|
|
|
|
ALTER TABLE MNP_DBCGO_NOTIFICA_REC_OUT add(
|
|
SISTEMA_MITTENTE VARCHAR2(4),
|
|
COD_PROFILO_TARIFFARIO VARCHAR2(10),
|
|
DESC_PROFILO_TARIFFARIO VARCHAR2(50),
|
|
COD_OFFERTA VARCHAR2(5),
|
|
DESC_OFFERTA VARCHAR2(50),
|
|
COD_ACCORDO VARCHAR2(10),
|
|
DESC_ACCORDO VARCHAR2(150)
|
|
);
|
|
|
|
ALTER TABLE MNP_SID_IN add(
|
|
COD_PROFILO_TARIFFARIO VARCHAR2(10),
|
|
DESC_PROFILO_TARIFFARIO VARCHAR2(50)
|
|
);
|
|
|
|
ALTER TABLE MNP_SID_SCARTI_IN add(
|
|
COD_PROFILO_TARIFFARIO VARCHAR2(10),
|
|
DESC_PROFILO_TARIFFARIO VARCHAR2(50)
|
|
);
|
|
|
|
ALTER TABLE MNP_MSC_IN_REC add(
|
|
COD_PROFILO_TARIFFARIO VARCHAR2(10),
|
|
DESC_PROFILO_TARIFFARIO VARCHAR2(50)
|
|
);
|
|
|
|
ALTER TABLE MNP_MSC_SCARTI_IN add(
|
|
COD_PROFILO_TARIFFARIO VARCHAR2(10),
|
|
DESC_PROFILO_TARIFFARIO VARCHAR2(50)
|
|
);
|
|
|
|
ALTER TABLE MNP_MSP_IN_REC add(
|
|
COD_PROFILO_TARIFFARIO VARCHAR2(10),
|
|
DESC_PROFILO_TARIFFARIO VARCHAR2(50)
|
|
);
|
|
|
|
ALTER TABLE MNP_MSP_SCARTI_IN add(
|
|
COD_PROFILO_TARIFFARIO VARCHAR2(10),
|
|
DESC_PROFILO_TARIFFARIO VARCHAR2(50)
|
|
);
|
|
|
|
ALTER TABLE MNP_BIT_IN_REC add(
|
|
COD_PROFILO_TARIFFARIO VARCHAR2(10),
|
|
DESC_PROFILO_TARIFFARIO VARCHAR2(50),
|
|
COD_OFFERTA VARCHAR2(5),
|
|
DESC_OFFERTA VARCHAR2(50),
|
|
COD_ACCORDO VARCHAR2(10),
|
|
DESC_ACCORDO VARCHAR2(150)
|
|
);
|
|
|
|
ALTER TABLE MNP_BIT_SCARTI_IN add(
|
|
COD_PROFILO_TARIFFARIO VARCHAR2(10),
|
|
DESC_PROFILO_TARIFFARIO VARCHAR2(50),
|
|
COD_OFFERTA VARCHAR2(5),
|
|
DESC_OFFERTA VARCHAR2(50),
|
|
COD_ACCORDO VARCHAR2(10),
|
|
DESC_ACCORDO VARCHAR2(150)
|
|
);
|
|
|
|
-------------------------------------------------------------------------
|
|
CREATE TABLE MNP_GESTIONE_RICHIESTA_REC_EXT (
|
|
ID_RICHIESTA VARCHAR2(23) NOT NULL,
|
|
CODICE_DEALER VARCHAR2(10),
|
|
COD_PROFILO_TARIFFARIO VARCHAR2(10),
|
|
DESC_PROFILO_TARIFFARIO VARCHAR2(50),
|
|
COD_OFFERTA VARCHAR2(5),
|
|
DESC_OFFERTA VARCHAR2(50),
|
|
COD_ACCORDO VARCHAR2(10),
|
|
DESC_ACCORDO VARCHAR2(150)
|
|
)
|
|
TABLESPACE TAB_BIG;
|
|
|
|
|
|
ALTER TABLE MNP_GESTIONE_RICHIESTA_REC_EXT ADD
|
|
CONSTRAINT PK_MNP_GESTIONE_RICH_REC_EXT
|
|
PRIMARY KEY(ID_RICHIESTA)
|
|
USING INDEX
|
|
TABLESPACE TAB_IDX_BIG
|
|
ENABLE
|
|
VALIDATE;
|
|
-------------------------------------------------------------------------
|
|
--- SM 1612
|
|
ALTER TABLE MNP_STORICO_CESS modify(
|
|
NOME_FILE VARCHAR2(100)
|
|
);
|
|
ALTER TABLE MNP_BONIFICHE_CESSAZIONE modify(
|
|
NOTA VARCHAR2(100)
|
|
);
|
|
ALTER TABLE MNP_BONIFICHE_DONOR modify(
|
|
NOTA VARCHAR2(100)
|
|
);
|
|
ALTER TABLE MNP_BONIFICHE_CESS_PORT modify(
|
|
NOTA VARCHAR2(100)
|
|
);
|
|
ALTER TABLE MNP_BONIFICHE_RECIPIENT modify(
|
|
NOTA VARCHAR2(100)
|
|
); |