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

13 lines
773 B
MySQL

INSERT INTO DBCGO_ANAGRAFICA_OPERATORI ( ID_OPERATORE, TIPO_OPERATORE, GESTORE_AOM,
ID_AMMINISTRATIVO, INIZIALE_ID_AMM, DESCRIZIONE ) VALUES (
'BIPM','VIRT','H3GI', 'H011', 'H', 'BIP Mobile');
-- aom virtuali donor e recipient
INSERT INTO DBCGO_LOV (LOV_ID,LOV_NAME,NAME,DESCR,ORDER_BY)
VALUES (SEQ_LOV.nextval,'AOM_DONOR','BIPM','BIP Mobile',null);
INSERT INTO DBCGO_LOV (LOV_ID,LOV_NAME,NAME,DESCR,ORDER_BY)
VALUES (SEQ_LOV.nextval,'AOM_RECIPIENT','BIPM','BIP 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','BIPM','BIP Mobile',null);
INSERT INTO DBCGO_LOV (LOV_ID,LOV_NAME,NAME,DESCR,ORDER_BY)
VALUES (SEQ_LOV.NEXTVAL,'AOM_RECIPIENT_SLA','BIPM','BIP Mobile',null);