75 lines
1.9 KiB
MySQL
75 lines
1.9 KiB
MySQL
-- eseguire come utente DBCGO
|
|
|
|
|
|
-- aggiunta valori LOV per visualizzazione PCN ---
|
|
|
|
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME,DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL,'ABBONATO_PREPAGATO','D' ,'Y');
|
|
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME,DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL,'ABBONATO_PREPAGATO','X' ,'N');
|
|
|
|
|
|
|
|
-- aggiunta valori LOV per gestione Virrtuali TIM in Rep Amministrativi --
|
|
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME,DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL,'AOM_DONOR','COOP' ,'COOPItalia');
|
|
|
|
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME,DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL,'AOM_DONOR','TISC' ,'Tiscali');
|
|
|
|
|
|
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME,DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL,'AOM_DONOR','NOVE' ,'Noverca');
|
|
|
|
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME,DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL,'AOM_RECIPIENT','COOP' ,'COOPItalia');
|
|
|
|
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME,DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL,'AOM_RECIPIENT','TISC' ,'Tiscali');
|
|
|
|
|
|
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME,DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL,'AOM_RECIPIENT','NOVE' ,'Noverca');
|
|
|
|
|
|
-- Aggiunt valori LOV per gestione SLA 3gg
|
|
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME,DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL,'SLA_PENALI','SLA0' ,'SLA0');
|
|
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME,DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL,'SLA_PENALI','SLA1' ,'SLA1');
|
|
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME,DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL,'SLA_PENALI','SLA2' ,'SLA2');
|
|
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME,DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL,'SLA_PENALI','SLA3' ,'SLA3');
|
|
|
|
|
|
|
|
-- Aggiunta valori per Report AGCOM
|
|
|
|
INSERT INTO dbcgo_vo_report_agcom
|
|
VALUES
|
|
(17,'9r - SLA Recipient','9R',80);
|
|
|
|
INSERT INTO dbcgo_vo_report_agcom
|
|
VALUES
|
|
(18,'9d - SLA Donating','9D',85);
|
|
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME,DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL,'COD_PROF_TARIFF','U' ,'Y');
|
|
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME,DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL,'COD_PROF_TARIFF','X' ,'N');
|
|
|
|
COMMIT; |