19 lines
548 B
SQL
19 lines
548 B
SQL
-- R1S-17-0010 Gestione Blocco cambio carta e portabilità per AG - Agesp Tecnico
|
|
CREATE TABLE MNP.MNP_BLACK_LIST_DONOR
|
|
(
|
|
COD_CAUSALE_RIFIUTO NUMBER(2),
|
|
MSISDN VARCHAR2(15 BYTE) NOT NULL,
|
|
DATA_INSERIMENTO DATE DEFAULT SYSDATE
|
|
)
|
|
TABLESPACE TAB_SMALL;
|
|
|
|
CREATE UNIQUE INDEX MNP.PK_MNP_BLACK_LIST_DONOR ON MNP.MNP_BLACK_LIST_DONOR
|
|
(MSISDN)
|
|
TABLESPACE TAB_IDX_SMALL;
|
|
|
|
ALTER TABLE MNP.MNP_BLACK_LIST_DONOR ADD (
|
|
CONSTRAINT PK_MNP_BLACK_LIST_DONOR
|
|
PRIMARY KEY
|
|
(MSISDN)
|
|
USING INDEX MNP.PK_MNP_BLACK_LIST_DONOR
|
|
ENABLE VALIDATE); |