Files
2024-05-13 12:54:14 +02:00

10 lines
855 B
MySQL

INSERT INTO DBCGO_ANAGRAFICA_OPERATORI ( ID_OPERATORE, TIPO_OPERATORE, GESTORE_AOM, ID_AMMINISTRATIVO, INIZIALE_ID_AMM, DESCRIZIONE )
VALUES ( 'RABO', 'VIRT', 'NOVA', 'N005', 'N', 'RABONA MOBILE');
-- aom virtuali donor e recipient
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR, ORDER_BY) VALUES (SEQ_LOV.nextval, 'AOM_DONOR', 'RABO','RABONA MOBILE', null);
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR, ORDER_BY) VALUES (SEQ_LOV.nextval, 'AOM_RECIPIENT', 'RABO', 'RABONA MOBILE', 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', 'RABO', 'RABONA MOBILE', null);
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR, ORDER_BY) VALUES (SEQ_LOV.NEXTVAL, 'AOM_RECIPIENT_SLA', 'RABO', 'RABONA MOBILE', null);