API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 12th, 2018
71
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.37 KB | None | 0 0
raw download clone embed print report
  1. USE PROD
  2. GO
  3. begin transaction
  4.  
  5. Insert into CHANNEL (PROTOCOL,CHANNEL,NAME,DEVICETYPE,CONNECTIONTYPE,POLLINGINTERVAL,MAXRETRYCOUNT,PHONENUMBER,BAUD,DATABITS,STOPBITS,PARITY,MODEMINITCOMMAND,MODEMDIALCOMMAND,MODEMCONNECTRESPONSE,MODEMHANGUPCOMMAND,MODEMESCAPESEQUENCE,CONNECTTIMEOUT,RESPONSETIMEOUT,ESCAPETIMEOUT,ESCAPESPACING,RESPONSERETRIES,CONNECTRETRIES,UNIVERSALUPDATETIME,LOCALUPDATETIME,UPDATEUSER) values ('EIS',393,'COM393','RTMS','TCP',30,3,null,9600,8,'1.0','NONE','ATZ','ATDT','CONNECT','ATH','+++',60000,1000,1000,50,3,5,getdate(),getdate(),'launderrs');
  6. Insert into CHANNEL (PROTOCOL,CHANNEL,NAME,DEVICETYPE,CONNECTIONTYPE,POLLINGINTERVAL,MAXRETRYCOUNT,PHONENUMBER,BAUD,DATABITS,STOPBITS,PARITY,MODEMINITCOMMAND,MODEMDIALCOMMAND,MODEMCONNECTRESPONSE,MODEMHANGUPCOMMAND,MODEMESCAPESEQUENCE,CONNECTTIMEOUT,RESPONSETIMEOUT,ESCAPETIMEOUT,ESCAPESPACING,RESPONSERETRIES,CONNECTRETRIES,UNIVERSALUPDATETIME,LOCALUPDATETIME,UPDATEUSER) values ('EIS',394,'COM394','RTMS','TCP',30,3,null,9600,8,'1.0','NONE','ATZ','ATDT','CONNECT','ATH','+++',60000,1000,1000,50,3,5,getdate(),getdate(),'launderrs');
  7.  
  8.  
  9. Insert into DEVICE (DEVICETYPE, DEVICEID, DESCRIPTION, DISPLAYID, CONTRACTID, ISOUTPUTDEVICE, X, Y, ROADNAME, ORGANIZATION, XOFFSET, YOFFSET, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER, PUBLICDESC, PUBLICNAME) values ('RTMS',
  10. 1171,'I-84 WB Waterbury @ X25',171,'151_273 SITE 3','NO',284401,231042,'I84W','CONNDOT',100,100,getdate(),getdate(),'launderrs','I-84 WB Waterbury @ X25','I-84 WB Waterbury @ X25');
  11. Insert into DEVICE (DEVICETYPE, DEVICEID, DESCRIPTION, DISPLAYID, CONTRACTID, ISOUTPUTDEVICE, X, Y, ROADNAME, ORGANIZATION, XOFFSET, YOFFSET, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER, PUBLICDESC, PUBLICNAME) values ('RTMS',
  12. 1172,'I-84 EB Waterbury @ X25',172,'151_273 SITE 3','NO',284439,230999,'I84E','CONNDOT',100,100,getdate(),getdate(),'launderrs','I-84 EB Waterbury @ X25','I-84 EB Waterbury @ X25');
  13. Insert into DEVICE (DEVICETYPE, DEVICEID, DESCRIPTION, DISPLAYID, CONTRACTID, ISOUTPUTDEVICE, X, Y, ROADNAME, ORGANIZATION, XOFFSET, YOFFSET, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER, PUBLICDESC, PUBLICNAME) values ('RTMS',
  14. 1173,'I-84 WB Waterbury E/O X23',173,'151_273 SITE 2','NO',283117,230831,'I84W','CONNDOT',100,100,getdate(),getdate(),'launderrs','I-84 WB Waterbury E/O X23','I-84 WB Waterbury E/O X23');
  15. Insert into DEVICE (DEVICETYPE, DEVICEID, DESCRIPTION, DISPLAYID, CONTRACTID, ISOUTPUTDEVICE, X, Y, ROADNAME, ORGANIZATION, XOFFSET, YOFFSET, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER, PUBLICDESC, PUBLICNAME) values ('RTMS',
  16. 1174,'I-84 EB Waterbury E/O X23',174,'151_273 SITE 2','NO',283008,230804,'I84E','CONNDOT',100,100,getdate(),getdate(),'launderrs','I-84 EB Waterbury E/O X23','I-84 EB Waterbury E/O X23');
  17. Insert into DEVICE (DEVICETYPE, DEVICEID, DESCRIPTION, DISPLAYID, CONTRACTID, ISOUTPUTDEVICE, X, Y, ROADNAME, ORGANIZATION, XOFFSET, YOFFSET, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER, PUBLICDESC, PUBLICNAME) values ('RTMS',
  18. 1175,'I-84 WB Waterbury W/O X23',175,'151_273 SITE 1','NO',281760,231509,'I84W','CONNDOT',100,100,getdate(),getdate(),'launderrs','I-84 WB Waterbury W/O X23','I-84 WB Waterbury W/O X23');
  19. Insert into DEVICE (DEVICETYPE, DEVICEID, DESCRIPTION, DISPLAYID, CONTRACTID, ISOUTPUTDEVICE, X, Y, ROADNAME, ORGANIZATION, XOFFSET, YOFFSET, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER, PUBLICDESC, PUBLICNAME) values ('RTMS',
  20. 1176,'I-84 EB Waterbury W/O X23',176,'151_273 SITE 1','NO',281720,231481,'I84E','CONNDOT',100,100,getdate(),getdate(),'launderrs','I-84 EB Waterbury W/O X23','I-84 EB Waterbury W/O X23');
  21.  
  22. Insert into DEVICE (DEVICETYPE, DEVICEID, DESCRIPTION, DISPLAYID, CONTRACTID, ISOUTPUTDEVICE, X, Y, ROADNAME, ORGANIZATION, XOFFSET, YOFFSET, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER, PUBLICDESC, PUBLICNAME) values ('CCTV CAMERA',
  23. 4135,'I-84 WB Waterbury @ X25',135,'151_273 SITE 3','NO',284401,231042,'I84W','CONNDOT',100,100,getdate(),getdate(),'launderrs','I-84 WB Waterbury @ X25','I-84 WB Waterbury @ X25');
  24. Insert into DEVICE (DEVICETYPE, DEVICEID, DESCRIPTION, DISPLAYID, CONTRACTID, ISOUTPUTDEVICE, X, Y, ROADNAME, ORGANIZATION, XOFFSET, YOFFSET, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER, PUBLICDESC, PUBLICNAME) values ('CCTV CAMERA',
  25. 4136,'I-84 EB Waterbury E/O X23',136,'151_273 SITE 2','NO',283008,230804,'I84E','CONNDOT',100,100,getdate(),getdate(),'launderrs','I-84 EB Waterbury E/O X23','I-84 EB Waterbury E/O X23');
  26. Insert into DEVICE (DEVICETYPE, DEVICEID, DESCRIPTION, DISPLAYID, CONTRACTID, ISOUTPUTDEVICE, X, Y, ROADNAME, ORGANIZATION, XOFFSET, YOFFSET, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER, PUBLICDESC, PUBLICNAME) values ('CCTV CAMERA',
  27. 4137,'I-84 EB Waterbury W/O X23',137,'151_273 SITE 1','NO',281720,231481,'I84E','CONNDOT',100,100,getdate(),getdate(),'launderrs','I-84 EB Waterbury W/O X23','I-84 EB Waterbury W/O X23');
  28.  
  29.  
  30. INSERT INTO RTMS (RTMSID, CHANNEL, SENSORID, PROTOCOL, OVERRIDEPHONENUMBER, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER, IPADDRESS, IPPORT) VALUES (1171,393,1,'EIS',null,getdate(),getdate(),'launderrs','192.168.114.49',2000);
  31. INSERT INTO RTMS (RTMSID, CHANNEL, SENSORID, PROTOCOL, OVERRIDEPHONENUMBER, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER, IPADDRESS, IPPORT) VALUES (1172,393,2,'EIS',null,getdate(),getdate(),'launderrs','192.168.114.50',2000);
  32. INSERT INTO RTMS (RTMSID, CHANNEL, SENSORID, PROTOCOL, OVERRIDEPHONENUMBER, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER, IPADDRESS, IPPORT) VALUES (1173,393,1,'EIS',null,getdate(),getdate(),'launderrs','192.168.114.51',2000);
  33. INSERT INTO RTMS (RTMSID, CHANNEL, SENSORID, PROTOCOL, OVERRIDEPHONENUMBER, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER, IPADDRESS, IPPORT) VALUES (1174,394,2,'EIS',null,getdate(),getdate(),'launderrs','192.168.114.52',2000);
  34. INSERT INTO RTMS (RTMSID, CHANNEL, SENSORID, PROTOCOL, OVERRIDEPHONENUMBER, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER, IPADDRESS, IPPORT) VALUES (1175,394,1,'EIS',null,getdate(),getdate(),'launderrs','192.168.114.53',2000);
  35. INSERT INTO RTMS (RTMSID, CHANNEL, SENSORID, PROTOCOL, OVERRIDEPHONENUMBER, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER, IPADDRESS, IPPORT) VALUES (1176,394,2,'EIS',null,getdate(),getdate(),'launderrs','192.168.114.54',2000);
  36.  
  37.  
  38. Insert into DEVICE (DEVICETYPE, DEVICEID, DESCRIPTION, DISPLAYID, CONTRACTID, ISOUTPUTDEVICE, X, Y, ROADNAME, ORGANIZATION, XOFFSET, YOFFSET, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER, PUBLICDESC, PUBLICNAME) values ('VDS',
  39. 2171,'I-84 WB Waterbury @ X25',171,'151_273 SITE 3','NO',284401,231042,'I84W','CONNDOT',100,100,getdate(),getdate(),'launderrs','I-84 WB Waterbury @ X25','I-84 WB Waterbury @ X25');
  40. Insert into DEVICE (DEVICETYPE, DEVICEID, DESCRIPTION, DISPLAYID, CONTRACTID, ISOUTPUTDEVICE, X, Y, ROADNAME, ORGANIZATION, XOFFSET, YOFFSET, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER, PUBLICDESC, PUBLICNAME) values ('VDS',
  41. 2172,'I-84 EB Waterbury @ X25',172,'151_273 SITE 3','NO',284439,230999,'I84E','CONNDOT',100,100,getdate(),getdate(),'launderrs','I-84 EB Waterbury @ X25','I-84 EB Waterbury @ X25');
  42. Insert into DEVICE (DEVICETYPE, DEVICEID, DESCRIPTION, DISPLAYID, CONTRACTID, ISOUTPUTDEVICE, X, Y, ROADNAME, ORGANIZATION, XOFFSET, YOFFSET, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER, PUBLICDESC, PUBLICNAME) values ('VDS',
  43. 2173,'I-84 WB Waterbury E/O X23',173,'151_273 SITE 2','NO',283117,230831,'I84W','CONNDOT',100,100,getdate(),getdate(),'launderrs','I-84 WB Waterbury E/O X23','I-84 WB Waterbury E/O X23');
  44. Insert into DEVICE (DEVICETYPE, DEVICEID, DESCRIPTION, DISPLAYID, CONTRACTID, ISOUTPUTDEVICE, X, Y, ROADNAME, ORGANIZATION, XOFFSET, YOFFSET, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER, PUBLICDESC, PUBLICNAME) values ('VDS',
  45. 2174,'I-84 EB Waterbury E/O X23',174,'151_273 SITE 2','NO',283008,230804,'I84E','CONNDOT',100,100,getdate(),getdate(),'launderrs','I-84 EB Waterbury E/O X23','I-84 EB Waterbury E/O X23');
  46. Insert into DEVICE (DEVICETYPE, DEVICEID, DESCRIPTION, DISPLAYID, CONTRACTID, ISOUTPUTDEVICE, X, Y, ROADNAME, ORGANIZATION, XOFFSET, YOFFSET, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER, PUBLICDESC, PUBLICNAME) values ('VDS',
  47. 2175,'I-84 WB Waterbury W/O X23',175,'151_273 SITE 1','NO',281760,231509,'I84W','CONNDOT',100,100,getdate(),getdate(),'launderrs','I-84 WB Waterbury W/O X23','I-84 WB Waterbury W/O X23');
  48. Insert into DEVICE (DEVICETYPE, DEVICEID, DESCRIPTION, DISPLAYID, CONTRACTID, ISOUTPUTDEVICE, X, Y, ROADNAME, ORGANIZATION, XOFFSET, YOFFSET, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER, PUBLICDESC, PUBLICNAME) values ('VDS',
  49. 2176,'I-84 EB Waterbury W/O X23',176,'151_273 SITE 1','NO',281720,231481,'I84E','CONNDOT',100,100,getdate(),getdate(),'launderrs','I-84 EB Waterbury W/O X23','I-84 EB Waterbury W/O X23');
  50.  
  51.  
  52. INSERT INTO VDSRTMS (RTMSID, ZONE, VDS, LANE, DESCRIPTION, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER) VALUES (1171,1,2171,1,'Lane 1',getdate(),getdate(),'launderrs');
  53. INSERT INTO VDSRTMS (RTMSID, ZONE, VDS, LANE, DESCRIPTION, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER) VALUES (1171,2,2171,2,'Lane 2',getdate(),getdate(),'launderrs');
  54. INSERT INTO VDSRTMS (RTMSID, ZONE, VDS, LANE, DESCRIPTION, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER) VALUES (1171,3,2171,3,'Lane 3',getdate(),getdate(),'launderrs');
  55. INSERT INTO VDSRTMS (RTMSID, ZONE, VDS, LANE, DESCRIPTION, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER) VALUES (1172,1,2172,1,'Lane 1',getdate(),getdate(),'launderrs');
  56. INSERT INTO VDSRTMS (RTMSID, ZONE, VDS, LANE, DESCRIPTION, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER) VALUES (1172,2,2172,2,'Lane 2',getdate(),getdate(),'launderrs');
  57. INSERT INTO VDSRTMS (RTMSID, ZONE, VDS, LANE, DESCRIPTION, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER) VALUES (1172,3,2172,3,'Lane 3',getdate(),getdate(),'launderrs');
  58. INSERT INTO VDSRTMS (RTMSID, ZONE, VDS, LANE, DESCRIPTION, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER) VALUES (1173,1,2173,1,'Lane 1',getdate(),getdate(),'launderrs');
  59. INSERT INTO VDSRTMS (RTMSID, ZONE, VDS, LANE, DESCRIPTION, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER) VALUES (1173,2,2173,2,'Lane 2',getdate(),getdate(),'launderrs');
  60. INSERT INTO VDSRTMS (RTMSID, ZONE, VDS, LANE, DESCRIPTION, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER) VALUES (1173,3,2173,3,'Lane 3',getdate(),getdate(),'launderrs');
  61. INSERT INTO VDSRTMS (RTMSID, ZONE, VDS, LANE, DESCRIPTION, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER) VALUES (1174,1,2174,1,'Lane 1',getdate(),getdate(),'launderrs');
  62. INSERT INTO VDSRTMS (RTMSID, ZONE, VDS, LANE, DESCRIPTION, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER) VALUES (1174,2,2174,2,'Lane 2',getdate(),getdate(),'launderrs');
  63. INSERT INTO VDSRTMS (RTMSID, ZONE, VDS, LANE, DESCRIPTION, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER) VALUES (1174,3,2174,3,'Lane 3',getdate(),getdate(),'launderrs');
  64. INSERT INTO VDSRTMS (RTMSID, ZONE, VDS, LANE, DESCRIPTION, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER) VALUES (1175,1,2175,1,'Lane 1',getdate(),getdate(),'launderrs');
  65. INSERT INTO VDSRTMS (RTMSID, ZONE, VDS, LANE, DESCRIPTION, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER) VALUES (1175,2,2175,2,'Lane 2',getdate(),getdate(),'launderrs');
  66. INSERT INTO VDSRTMS (RTMSID, ZONE, VDS, LANE, DESCRIPTION, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER) VALUES (1175,3,2175,3,'Lane 3',getdate(),getdate(),'launderrs');
  67. INSERT INTO VDSRTMS (RTMSID, ZONE, VDS, LANE, DESCRIPTION, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER) VALUES (1176,1,2176,1,'Lane 1',getdate(),getdate(),'launderrs');
  68. INSERT INTO VDSRTMS (RTMSID, ZONE, VDS, LANE, DESCRIPTION, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER) VALUES (1176,2,2176,2,'Lane 2',getdate(),getdate(),'launderrs');
  69. INSERT INTO VDSRTMS (RTMSID, ZONE, VDS, LANE, DESCRIPTION, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER) VALUES (1176,3,2176,3,'Lane 3',getdate(),getdate(),'launderrs');
  70.  
  71.  
  72.  
  73. INSERT INTO IQ_VDS VALUES(2171,'VDS 2171',1,1,1,1,getdate(),getdate(),'launderrs');
  74. INSERT INTO IQ_VDS VALUES(2172,'VDS 2172',1,1,1,1,getdate(),getdate(),'launderrs');
  75. INSERT INTO IQ_VDS VALUES(2173,'VDS 2173',1,1,1,1,getdate(),getdate(),'launderrs');
  76. INSERT INTO IQ_VDS VALUES(2174,'VDS 2174',1,1,1,1,getdate(),getdate(),'launderrs');
  77. INSERT INTO IQ_VDS VALUES(2175,'VDS 2175',1,1,1,1,getdate(),getdate(),'launderrs');
  78. INSERT INTO IQ_VDS VALUES(2176,'VDS 2176',1,1,1,1,getdate(),getdate(),'launderrs');
  79.  
  80.  
  81. Insert into DEVICE (DEVICETYPE, DEVICEID, DESCRIPTION, DISPLAYID, CONTRACTID, ISOUTPUTDEVICE, X, Y, ROADNAME, ORGANIZATION, XOFFSET, YOFFSET, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER, PUBLICDESC, PUBLICNAME) values ('VMS',
  82. 321,'84W Waterbury @ X23',21,'151_273 VMS','YES',282063,231161,'I84W','CONNDOT',100,100,getdate(),getdate(),'launderrs','84W Waterbury @ X23','84W Waterbury @ X23');
  83.  
  84. Insert into CMS (DEVICEID, CMSSUBTYPE, PHYSICALSIGNID, CMSCONTROLLERADDRESS, CHANNEL, DISPLAYFORMATNAME, OVERRIDEPHONENUMBER, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER, FIBERCHANNEL, DIALUPCHANNEL, USE_IN_RESPONSE, PASSWORD, IPADDRESS, IPPORT) values (321,'OVERHEAD VMS',1,1,21,'3x65pixels','9,12037590054',getdate(),getdate(),'DEFAULT',402,21,1,'administrator','192.168.114.56',161);
  85.  
  86. Insert into CMS_COMPONENT (DEVICEID, COMPONENTID, STATICTEXT, DEFAULTSTATE, STARTUPSTATE, UNIVERSALUPDATETIME, LOCALUPDATETIME, UPDATEUSER) values (321,1,' ','BLANK','N/A',getdate(),getdate(),'DEFAULT');
  87.  
  88. Insert into COMM_DEVICE_STATUS (DEVICETYPE,DEVICEID,STATUS,CONTROLSOURCE,CONTROLREASON,CONTROLUPDATETIME) values ('VMS',321,'COMM HALTED',null,null,null);
  89.  
  90.  
  91.  
  92. commit; --rollback;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!