36 lines
2.1 KiB
MySQL
36 lines
2.1 KiB
MySQL
INSERT INTO DBCGO_ANAGRAFICA_OPERATORI ( ID_OPERATORE, TIPO_OPERATORE, GESTORE_AOM,
|
|
ID_AMMINISTRATIVO, INIZIALE_ID_AMM, DESCRIZIONE ) VALUES (
|
|
'TELO', 'VIRT','H3GI', 'H009', 'H', 'Telogic');
|
|
INSERT INTO DBCGO_ANAGRAFICA_OPERATORI ( ID_OPERATORE, TIPO_OPERATORE, GESTORE_AOM,
|
|
ID_AMMINISTRATIVO, INIZIALE_ID_AMM, DESCRIZIONE ) VALUES (
|
|
'ITAL','VIRT','H3GI','H008', 'H', 'Italiacom');
|
|
INSERT INTO DBCGO_ANAGRAFICA_OPERATORI ( ID_OPERATORE, TIPO_OPERATORE, GESTORE_AOM,
|
|
ID_AMMINISTRATIVO, INIZIALE_ID_AMM, DESCRIZIONE ) VALUES (
|
|
'DITE','VIRT','H3GI', 'H007', 'H', 'DIGITEL');
|
|
-- aom virtuali donor e recipient
|
|
INSERT INTO DBCGO_LOV (LOV_ID,LOV_NAME,NAME,DESCR,ORDER_BY)
|
|
VALUES (SEQ_LOV.nextval,'AOM_DONOR','TELO','Telogic',null);
|
|
INSERT INTO DBCGO_LOV (LOV_ID,LOV_NAME,NAME,DESCR,ORDER_BY)
|
|
VALUES (SEQ_LOV.nextval,'AOM_DONOR','ITAL','Italiacom',null);
|
|
INSERT INTO DBCGO_LOV (LOV_ID,LOV_NAME,NAME,DESCR,ORDER_BY)
|
|
VALUES (SEQ_LOV.nextval,'AOM_DONOR','DITE','DIGITEL',null);
|
|
INSERT INTO DBCGO_LOV (LOV_ID,LOV_NAME,NAME,DESCR,ORDER_BY)
|
|
VALUES (SEQ_LOV.nextval,'AOM_RECIPIENT','TELO','Telogic',null);
|
|
INSERT INTO DBCGO_LOV (LOV_ID,LOV_NAME,NAME,DESCR,ORDER_BY)
|
|
VALUES (SEQ_LOV.nextval,'AOM_RECIPIENT','ITAL','Italiacom',null);
|
|
INSERT INTO DBCGO_LOV (LOV_ID,LOV_NAME,NAME,DESCR,ORDER_BY)
|
|
VALUES (SEQ_LOV.nextval,'AOM_RECIPIENT','DITE','DIGITEL',null);
|
|
-- aom virtuali donor e recipient SLA
|
|
INSERT INTO DBCGO_LOV (LOV_ID,LOV_NAME,NAME,DESCR,ORDER_BY)
|
|
VALUES (SEQ_LOV.NEXTVAL,'AOM_DONOR_SLA','TELO','Telogic',null);
|
|
INSERT INTO DBCGO_LOV (LOV_ID,LOV_NAME,NAME,DESCR,ORDER_BY)
|
|
VALUES (SEQ_LOV.NEXTVAL,'AOM_DONOR_SLA','ITAL','Italiacom',null);
|
|
INSERT INTO DBCGO_LOV (LOV_ID,LOV_NAME,NAME,DESCR,ORDER_BY)
|
|
VALUES (SEQ_LOV.NEXTVAL,'AOM_DONOR_SLA','DITE','DIGITEL',null);
|
|
INSERT INTO DBCGO_LOV (LOV_ID,LOV_NAME,NAME,DESCR,ORDER_BY)
|
|
VALUES (SEQ_LOV.NEXTVAL,'AOM_RECIPIENT_SLA','TELO','Telogic',null);
|
|
INSERT INTO DBCGO_LOV (LOV_ID,LOV_NAME,NAME,DESCR,ORDER_BY)
|
|
VALUES (SEQ_LOV.NEXTVAL,'AOM_RECIPIENT_SLA','ITAL','Italiacom',null);
|
|
INSERT INTO DBCGO_LOV (LOV_ID,LOV_NAME,NAME,DESCR,ORDER_BY)
|
|
VALUES (SEQ_LOV.NEXTVAL,'AOM_RECIPIENT_SLA','DITE','DIGITEL',null);
|
|
COMMIT; |