Banco | Script |
---|
SQL Server | SET IDENTITY_INSERT MODEL ON INSERT INTO MODEL(ID,MODEL_CODE,DESCRIPTION,DISPOSIT_CLASS_NAME,DISPOSIT_PARSER_CLASS_NAME,LISTENER_CLASS_NAME,LISTENER_SENDER_CLASS_NAME,MANUFACTURER,MODEL_TYPE,RMI_CLASS_NAME,SENDER_CLASS_NAME,SERVER_CLASS_NAME,REP,TWO_READERS) VALUES (45,144,'Henry Hexa (REP)','com.totvs.hcm.accesscontrol.server.henry.hexa.HenryHexaDevice','com.totvs.hcm.accesscontrol.server.henry.hexa.HenryHexaDeviceParser','','com.totvs.hcm.accesscontrol.server.henry.hexa.HenryHexaREPListenerSender',4,0,'com.totvs.hcm.accesscontrol.server.henry.hexa.CommandControlRMIHenryHexaREP','','com.totvs.hcm.accesscontrol.server.ListenerSenderServer',1,0); SET IDENTITY_INSERT MODEL OFF SET IDENTITY_INSERT MODEL_CONFIGURATION ON INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10402,'hexa.configuration.login','',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10403,'hexa.configuration.bioreader','D',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10404,'hexa.configuration.cutpaper','P',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10405,'hexa.configuration.sizecoil','300',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10406,'hexa.configuration.nrrep','00000000000000000',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10407,'hexa.configuration.cardreader','N',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10408,'hexa.configuration.dhcp','H',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10409,'hexa.configuration.ip','192.168.0.200',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10410,'hexa.configuration.subnetmask','192.168.0.1',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10411,'hexa.configuration.dns','192.168.0.1',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10412,'hexa.configuration.gateway','192.168.0.1',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10413,'hexa.configuration.mac','0000000000',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10414,'hexa.configuration.tcpport','3000',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10415,'hexa.configuration.securecommunication','D',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10416,'hexa.configuration.ipsecurecommunication','000.000.000.000',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10417,'hexa.configuration.ipserver','000.000.000.000',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10418,'hexa.configuration.mode','S',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10419,'hexa.configuration.passwordmenu','',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10420,'hexa.configuration.size.template','0',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10421,'hexa.configuration.size.user','0',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10422,'hexa.configuration.size.record','0',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10423,'hexa.configuration.paper.sensor','D',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10424,'hexa.configuration.paper.less','D',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10425,'hexa.configuration.locked','D',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10426,'hexa.configuration.erro.mrp','D',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10427,'hexa.configuration.no.employer','D',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10428,'hexa.configuration.size.tickets.coil','8500',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10429,'hexa.configuration.size.current.coil','300',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10430,'hexa.configuration.size.total.coil','300',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10431,'hexa.configuration.date.refresh.status','',45); SET IDENTITY_INSERT MODEL_CONFIGURATION OFF |
MySQL | INSERT INTO MODEL(ID,MODEL_CODE,DESCRIPTION,DISPOSIT_CLASS_NAME,DISPOSIT_PARSER_CLASS_NAME,LISTENER_CLASS_NAME,LISTENER_SENDER_CLASS_NAME,MANUFACTURER,MODEL_TYPE,RMI_CLASS_NAME,SENDER_CLASS_NAME,SERVER_CLASS_NAME,REP,TWO_READERS) VALUES (45,144,'Henry Hexa (REP)','com.totvs.hcm.accesscontrol.server.henry.hexa.HenryHexaDevice','com.totvs.hcm.accesscontrol.server.henry.hexa.HenryHexaDeviceParser','','com.totvs.hcm.accesscontrol.server.henry.hexa.HenryHexaREPListenerSender',4,0,'com.totvs.hcm.accesscontrol.server.henry.hexa.CommandControlRMIHenryHexaREP','','com.totvs.hcm.accesscontrol.server.ListenerSenderServer',1,0);
INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10402,'hexa.configuration.login','',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10403,'hexa.configuration.bioreader','D',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10404,'hexa.configuration.cutpaper','P',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10405,'hexa.configuration.sizecoil','300',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10406,'hexa.configuration.nrrep','00000000000000000',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10407,'hexa.configuration.cardreader','N',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10408,'hexa.configuration.dhcp','H',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10409,'hexa.configuration.ip','192.168.0.200',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10410,'hexa.configuration.subnetmask','192.168.0.1',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10411,'hexa.configuration.dns','192.168.0.1',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10412,'hexa.configuration.gateway','192.168.0.1',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10413,'hexa.configuration.mac','0000000000',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10414,'hexa.configuration.tcpport','3000',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10415,'hexa.configuration.securecommunication','D',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10416,'hexa.configuration.ipsecurecommunication','000.000.000.000',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10417,'hexa.configuration.ipserver','000.000.000.000',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10418,'hexa.configuration.mode','S',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10419,'hexa.configuration.passwordmenu','',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10420,'hexa.configuration.size.template','0',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10421,'hexa.configuration.size.user','0',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10422,'hexa.configuration.size.record','0',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10423,'hexa.configuration.paper.sensor','D',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10424,'hexa.configuration.paper.less','D',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10425,'hexa.configuration.locked','D',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10426,'hexa.configuration.erro.mrp','D',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10427,'hexa.configuration.no.employer','D',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10428,'hexa.configuration.size.tickets.coil','8500',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10429,'hexa.configuration.size.current.coil','300',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10430,'hexa.configuration.size.total.coil','300',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10431,'hexa.configuration.date.refresh.status','',45); |
Oracle | INSERT INTO MODEL(ID,MODEL_CODE,DESCRIPTION,DISPOSIT_CLASS_NAME,DISPOSIT_PARSER_CLASS_NAME,LISTENER_CLASS_NAME,LISTENER_SENDER_CLASS_NAME,MANUFACTURER,MODEL_TYPE,RMI_CLASS_NAME,SENDER_CLASS_NAME,SERVER_CLASS_NAME,REP,TWO_READERS) VALUES (45,144,'Henry Hexa (REP)','com.totvs.hcm.accesscontrol.server.henry.hexa.HenryHexaDevice','com.totvs.hcm.accesscontrol.server.henry.hexa.HenryHexaDeviceParser','','com.totvs.hcm.accesscontrol.server.henry.hexa.HenryHexaREPListenerSender',4,0,'com.totvs.hcm.accesscontrol.server.henry.hexa.CommandControlRMIHenryHexaREP','','com.totvs.hcm.accesscontrol.server.ListenerSenderServer',1,0);
INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10402,'hexa.configuration.login','',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10403,'hexa.configuration.bioreader','D',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10404,'hexa.configuration.cutpaper','P',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10405,'hexa.configuration.sizecoil','300',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10406,'hexa.configuration.nrrep','00000000000000000',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10407,'hexa.configuration.cardreader','N',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10408,'hexa.configuration.dhcp','H',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10409,'hexa.configuration.ip','192.168.0.200',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10410,'hexa.configuration.subnetmask','192.168.0.1',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10411,'hexa.configuration.dns','192.168.0.1',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10412,'hexa.configuration.gateway','192.168.0.1',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10413,'hexa.configuration.mac','0000000000',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10414,'hexa.configuration.tcpport','3000',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10415,'hexa.configuration.securecommunication','D',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10416,'hexa.configuration.ipsecurecommunication','000.000.000.000',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10417,'hexa.configuration.ipserver','000.000.000.000',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10418,'hexa.configuration.mode','S',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10419,'hexa.configuration.passwordmenu','',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10420,'hexa.configuration.size.template','0',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10421,'hexa.configuration.size.user','0',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10422,'hexa.configuration.size.record','0',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10423,'hexa.configuration.paper.sensor','D',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10424,'hexa.configuration.paper.less','D',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10425,'hexa.configuration.locked','D',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10426,'hexa.configuration.erro.mrp','D',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10427,'hexa.configuration.no.employer','D',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10428,'hexa.configuration.size.tickets.coil','8500',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10429,'hexa.configuration.size.current.coil','300',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10430,'hexa.configuration.size.total.coil','300',45); INSERT INTO MODEL_CONFIGURATION(ID,PROPERTY,VALUE,ID_MODEL) VALUES (10431,'hexa.configuration.date.refresh.status','',45); |