强大的SQL语法分析器:SQLReader

说起SQL语法分析器,可能很多人首先会想到antlr、calcite或者sqlparser等。


这里给大家介绍一款强大的国产SQL语法分析器:SQLReader。


它具有以下特点:

1、独立性,不依赖任何第三方工具;

2、高效性,一秒以内可以分析多个SQL脚本;

3、结果详细,兼顾到字段级血缘和条件级血缘;

4、兼容性,支持各种常见数据库的语法;

5、智能识别,可以自动识别出各种脚本(如:perl、shell、存储过程)中的SQL语句;

6、易用性,无需过多配置,一步分析,结果自动结构化保存到数据库表中;


SQLReader是基于SQL图形化数据血缘系统的核心,是数据资产地图实现的基础。


围绕SQLReader的出现,相信将来会衍生出越来越多强大的功能或产品。


这些功能或产品,将会大幅度提升企业对数据管理和治理的效率。






2020-07-23 16:46:02 | 张良 | 技术 & 提问 | 阅读588次

回 复 :

收费吗?

免费????


INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BDEV19LP1','BAY106','BDEV19LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BRFL03LP1','BAY202','BRFL03LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BRFL03LP2','BAY202','BRFL03LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BRFL04LP1','BAY202','BRFL04LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE107-MI1','BAY107','OPE107-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE107-MO1','BAY107','OPE107-MO1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT15LP2','BAY213','BPLT15LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT14LP2','BAY213','BPLT14LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('EX213-0A','BAY02','EX213-0A','PORT','0','0','EX213-01','BAY213',5,0,5,0,'0'),

('EX213-0B','BAY02','EX213-0B','PORT','0','1','EX213-02','BAY213',5,0,5,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('EX213-01','BAY213','EX213-01','PORT','0','1','EX213-0A','BAY02',5,0,5,0,'0'),

('EX213-02','BAY213','EX213-02','PORT','0','0','EX213-0B','BAY02',5,0,5,0,'0'),

('OPE213-MI1','BAY213','OPE213-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE213-MO1','BAY213','OPE213-MO1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM03LP1','BAY208','BATM03LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM03LP2','BAY208','BATM03LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI06LP1','BAY109','BAOI06LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI06LP2','BAY109','BAOI06LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('EX105-02','BAY105','EX105-02','PORT','0','1','EX105-0B','BAY01',5,0,5,0,'0'),

('OPE105-MI1','BAY105','OPE105-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OPE105-MO1','BAY105','OPE105-MO1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM02LP1','BAY106','BATM02LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM02LP2','BAY106','BATM02LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('EX106-01','BAY106','EX106-01','PORT','0','0','EX106-0A','BAY01',5,0,5,0,'0'),

('EX106-02','BAY106','EX106-02','PORT','0','1','EX106-0B','BAY01',5,0,5,0,'0'),

('OPE106-MI1','BAY106','OPE106-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE106-MO1','BAY106','OPE106-MO1','PORT','1','1',NULL,NULL,5,0,0,0,'0'),

('BSOT01LP2','BAY108','BSOT01LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT01LP3','BAY108','BSOT01LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT02LP1','BAY108','BSOT02LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BSOT02LP2','BAY108','BSOT02LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT02LP3','BAY108','BSOT02LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('EX108-01','BAY108','EX108-01','PORT','0','1','EX108-0A','BAY01',5,0,5,0,'0'),

('EX108-02','BAY108','EX108-02','PORT','0','0','EX108-0B','BAY01',5,0,5,0,'0'),

('OPE108-MI1','BAY108','OPE108-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE108-MO1','BAY108','OPE108-MO1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD01LP1','BAY109','BPVD01LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD01LP2','BAY109','BPVD01LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD02LP1','BAY109','BPVD02LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD02LP2','BAY109','BPVD02LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BPVD03LP1','BAY109','BPVD03LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD03LP2','BAY109','BPVD03LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD04LP1','BAY109','BPVD04LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD04LP2','BAY109','BPVD04LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD05LP1','BAY109','BPVD05LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD05LP2','BAY109','BPVD05LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('EX109-01','BAY109','EX109-01','PORT','0','0','EX109-0A','BAY01',5,0,5,0,'0'),

('EX109-02','BAY109','EX109-02','PORT','0','1','EX109-0B','BAY01',5,0,5,0,'0'),

('OPE109-MI1','BAY109','OPE109-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE109-MO1','BAY109','OPE109-MO1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('EX110-01','BAY110','EX110-01','PORT','0','1','EX110-0A','BAY01',5,0,5,0,'0'),

('EX110-02','BAY110','EX110-02','PORT','0','0','EX110-0B','BAY01',5,0,5,0,'0'),

('EX110-03','BAY110','EX110-03','PORT','0','1','EX110-0C','BAY01',5,0,5,0,'0'),

('EX110-04','BAY110','EX110-04','PORT','0','0','EX110-0D','BAY01',5,0,5,0,'0'),

('OPE110-MI1','BAY110','OPE110-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE110-MO1','BAY110','OPE110-MO1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('EX111-01','BAY111','EX111-01','PORT','0','1','EX111-0A','BAY01',5,0,5,0,'0'),

('EX111-02','BAY111','EX111-02','PORT','0','1','EX111-0B','BAY01',5,0,5,0,'0'),

('OPE111-MI1','BAY111','OPE111-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE111-MO1','BAY111','OPE111-MO1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('EX112-01','BAY112','EX112-01','PORT','0','0','EX112-0A','BAY01',5,0,5,0,'0'),

('EX112-02','BAY112','EX112-02','PORT','0','0','EX112-0B','BAY01',5,0,5,0,'0'),

('OPE112-MI1','BAY112','OPE112-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE112-MO1','BAY112','OPE112-MO1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('EX201-01','BAY201','EX201-01','PORT','0','1','EX201-0A','BAY02',5,0,5,0,'0'),

('EX201-02','BAY201','EX201-02','PORT','0','0','EX201-0B','BAY02',5,0,5,0,'0'),

('EX202-01','BAY202','EX202-01','PORT','0','1','EX202-0A','BAY02',5,0,5,0,'0'),

('EX202-02','BAY202','EX202-02','PORT','0','0','EX202-0B','BAY02',5,0,5,0,'0'),

('EX203-01','BAY203','EX203-01','PORT','0','1','EX203-0A','BAY02',5,0,5,0,'0'),

('EX203-02','BAY203','EX203-02','PORT','0','0','EX203-0B','BAY02',5,0,5,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BDEV21LP1','BAY105','BDEV21LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('EX204-01','BAY204','EX204-01','PORT','0','1','EX204-0A','BAY02',5,0,5,0,'0'),

('EX204-02','BAY204','EX204-02','PORT','0','0','EX204-0B','BAY02',5,0,5,0,'0'),

('EX204-03','BAY204','EX204-03','PORT','0','1','EX204-0C','BAY02',5,0,5,0,'0'),

('EX204-04','BAY204','EX204-04','PORT','0','0','EX204-0D','BAY02',5,0,5,0,'0'),

('EX205-01','BAY205','EX205-01','PORT','0','1','EX205-0A','BAY02',5,0,5,0,'0'),

('EX205-02','BAY205','EX205-02','PORT','0','0','EX205-0B','BAY02',5,0,5,0,'0'),

('EX206-01','BAY206','EX206-01','PORT','0','1','EX206-0A','BAY02',5,0,5,0,'0'),

('EX206-02','BAY206','EX206-02','PORT','0','0','EX206-0B','BAY02',5,0,5,0,'0'),

('EX207-01','BAY207','EX207-01','PORT','0','1','EX207-0A','BAY02',5,0,5,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('EX207-02','BAY207','EX207-02','PORT','0','0','EX207-0B','BAY02',5,0,5,0,'0'),

('EX207-03','BAY207','EX207-03','PORT','0','1','EX207-0C','BAY02',5,0,5,0,'0'),

('EX207-04','BAY207','EX207-04','PORT','0','0','EX207-0D','BAY02',5,0,5,0,'0'),

('EX208-01','BAY208','EX208-01','PORT','0','1','EX208-0A','BAY02',5,0,5,0,'0'),

('EX208-02','BAY208','EX208-02','PORT','0','0','EX208-0B','BAY02',5,0,5,0,'0'),

('EX208-03','BAY208','EX208-03','PORT','0','1','EX208-0C','BAY02',5,0,5,0,'0'),

('EX208-04','BAY208','EX208-04','PORT','0','0','EX208-0D','BAY02',5,0,5,0,'0'),

('EX209-01','BAY209','EX209-01','PORT','0','1','EX209-0A','BAY02',5,0,5,0,'0'),

('EX209-02','BAY209','EX209-02','PORT','0','0','EX209-0B','BAY02',5,0,5,0,'0'),

('EX210-01','BAY210','EX210-01','PORT','0','1','EX210-0A','BAY02',5,0,5,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('EX210-02','BAY210','EX210-02','PORT','0','0','EX210-0B','BAY02',5,0,5,0,'0'),

('EX210-03','BAY210','EX210-03','PORT','0','1','EX210-0C','BAY02',5,0,5,0,'0'),

('EX210-04','BAY210','EX210-04','PORT','0','0','EX210-0D','BAY02',5,0,5,0,'0'),

('EX211-01','BAY211','EX211-01','PORT','0','1','EX211-0A','BAY02',5,0,5,0,'0'),

('EX211-02','BAY211','EX211-02','PORT','0','0','EX211-0B','BAY02',5,0,5,0,'0'),

('EX211-03','BAY211','EX211-03','PORT','0','1','EX211-0C','BAY02',5,0,5,0,'0'),

('EX211-04','BAY211','EX211-04','PORT','0','0','EX211-0D','BAY02',5,0,5,0,'0'),

('EX212-01','BAY212','EX212-01','PORT','0','1','EX212-0A','BAY02',5,0,5,0,'0'),

('EX212-02','BAY212','EX212-02','PORT','0','0','EX212-0B','BAY02',5,0,5,0,'0'),

('EX212-03','BAY212','EX212-03','PORT','0','1','EX212-0C','BAY02',5,0,5,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('EX212-04','BAY212','EX212-04','PORT','0','0','EX212-0D','BAY02',5,0,5,0,'0'),

('OPE212-MI1','BAY212','OPE212-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE212-MO1','BAY212','OPE212-MO1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('LFT01-MI1','LFT01','LFT01-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('LFT01-MO1','LFT01','LFT01-MO1','PORT','1','1',NULL,NULL,5,0,0,0,'0'),

('LX101-01','LFT01','LX101-01','PORT','0','1','LX101-0A','BAY01',5,0,5,0,'0'),

('LX101-02','LFT01','LX101-02','PORT','0','0','LX101-0B','BAY01',5,0,5,0,'0'),

('LX201-01','LFT01','LX201-01','PORT','0','1','LX201-0A','BAY02',5,0,5,0,'0'),

('LX201-02','LFT01','LX201-02','PORT','0','0','LX201-0B','BAY02',5,0,5,0,'0'),

('OPE208-MO1','BAY208','OPE208-MO1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('STK101-MI1','STK101','STK101-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('STK101-MO1','STK101','STK101-MO1','PORT','1','1',NULL,NULL,5,0,0,0,'0'),

('SX101-01','STK101','SX101-01','PORT','0','0','SX101-0A','BAY01',5,0,5,0,'0'),

('SX101-02','STK101','SX101-02','PORT','0','1','SX101-0B','BAY01',5,0,5,0,'0'),

('SX101-03','STK101','SX101-03','PORT','0','0','SX101-0C','BAY01',5,0,5,0,'0'),

('OPE208-MI1','BAY208','OPE208-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('EX210-0A','BAY02','EX210-0A','PORT','0','0','EX210-01','BAY210',5,0,5,0,'0'),

('EX210-0B','BAY02','EX210-0B','PORT','0','1','EX210-02','BAY210',5,0,5,0,'0'),

('EX210-0C','BAY02','EX210-0C','PORT','0','0','EX210-03','BAY210',5,0,5,0,'0'),

('EX210-0D','BAY02','EX210-0D','PORT','0','1','EX210-04','BAY210',5,0,5,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('EX211-0A','BAY02','EX211-0A','PORT','0','0','EX211-01','BAY211',5,0,5,0,'0'),

('EX211-0B','BAY02','EX211-0B','PORT','0','1','EX211-02','BAY211',5,0,5,0,'0'),

('EX211-0C','BAY02','EX211-0C','PORT','0','0','EX211-03','BAY211',5,0,5,0,'0'),

('EX211-0D','BAY02','EX211-0D','PORT','0','1','EX211-04','BAY211',5,0,5,0,'0'),

('EX212-0A','BAY02','EX212-0A','PORT','0','0','EX212-01','BAY212',5,0,5,0,'0'),

('EX212-0B','BAY02','EX212-0B','PORT','0','1','EX212-02','BAY212',5,0,5,0,'0'),

('EX212-0C','BAY02','EX212-0C','PORT','0','0','EX212-03','BAY212',5,0,5,0,'0'),

('EX212-0D','BAY02','EX212-0D','PORT','0','1','EX212-04','BAY212',5,0,5,0,'0'),

('LX201-0A','BAY02','LX201-0A','PORT','0','0','LX201-01','LFT01',5,0,5,0,'0'),

('LX201-0B','BAY02','LX201-0B','PORT','0','1','LX201-02','LFT01',5,0,5,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('EX101-01','BAY101','EX101-01','PORT','0','0','EX101-0A','BAY01',5,0,5,0,'0'),

('EX101-02','BAY101','EX101-02','PORT','0','0','EX101-0B','BAY01',5,0,5,0,'0'),

('OPE101-MI1','BAY101','OPE101-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT05LP1','BAY212','BPLT05LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT05LP2','BAY212','BPLT05LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPRB10LP1','BAY203','BPRB10LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM22LP1','BAY106','BATM22LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE103-MO2','BAY103','OPE103-MO2','PORT','1','1',NULL,NULL,5,0,0,0,'0'),

('BDEV20LP2','BAY105','BDEV20LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT07LP1','BAY212','BPLT07LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BPLT07LP2','BAY212','BPLT07LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT07LP3','BAY212','BPLT07LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD13LP1','BAY110','BPVD13LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE101-MO1','BAY101','OPE101-MO1','PORT','1','1',NULL,NULL,5,0,0,0,'0'),

('EX102-01','BAY102','EX102-01','PORT','0','0','EX102-0A','BAY01',5,0,5,0,'0'),

('EX102-02','BAY102','EX102-02','PORT','0','1','EX102-0B','BAY01',5,0,5,0,'0'),

('OPE102-MI1','BAY102','OPE102-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE102-MO1','BAY102','OPE102-MO1','PORT','1','1',NULL,NULL,5,0,0,0,'0'),

('BAOM04LP1','BAY103','BAOM04LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOM04LP2','BAY103','BAOM04LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BEXP02LP1','BAY103','BEXP02LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BEXP02LP2','BAY103','BEXP02LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BEXP03LP1','BAY103','BEXP03LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BEXP03LP2','BAY103','BEXP03LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BEXP04LP1','BAY103','BEXP04LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BEXP04LP2','BAY103','BEXP04LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BEXP05LP1','BAY103','BEXP05LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BEXP05LP2','BAY103','BEXP05LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BEXP06LP1','BAY103','BEXP06LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BEXP06LP2','BAY103','BEXP06LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BSPN02LP1','BAY103','BSPN02LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN02LP2','BAY103','BSPN02LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN02LP3','BAY103','BSPN02LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN03LP1','BAY103','BSPN03LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN03LP2','BAY103','BSPN03LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN04LP1','BAY103','BSPN04LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN04LP2','BAY103','BSPN04LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN05LP1','BAY103','BSPN05LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN05LP2','BAY103','BSPN05LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN05LP3','BAY103','BSPN05LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BSPN06LP1','BAY103','BSPN06LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN06LP2','BAY103','BSPN06LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN07LP1','BAY103','BSPN07LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN07LP2','BAY103','BSPN07LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN08LP1','BAY103','BSPN08LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN08LP2','BAY103','BSPN08LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BWEE01LP1','BAY103','BWEE01LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BWEE01LP2','BAY103','BWEE01LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('EX103-01','BAY103','EX103-01','PORT','0','0','EX103-0A','BAY01',5,0,5,0,'0'),

('EX103-02','BAY103','EX103-02','PORT','0','1','EX103-0B','BAY01',5,0,5,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('EX103-03','BAY103','EX103-03','PORT','0','0','EX103-0C','BAY01',5,0,5,0,'0'),

('EX103-04','BAY103','EX103-04','PORT','0','1','EX103-0D','BAY01',5,0,5,0,'0'),

('OPE103-MI1','BAY103','OPE103-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE103-MI2','BAY103','OPE103-MI2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE103-MO1','BAY103','OPE103-MO1','PORT','1','1',NULL,NULL,5,0,0,0,'0'),

('EX104-01','BAY104','EX104-01','PORT','0','0','EX104-0A','BAY01',5,0,5,0,'0'),

('EX104-02','BAY104','EX104-02','PORT','0','1','EX104-0B','BAY01',5,0,5,0,'0'),

('EX104-03','BAY104','EX104-03','PORT','0','0','EX104-0C','BAY01',5,0,5,0,'0'),

('EX104-04','BAY104','EX104-04','PORT','0','1','EX104-0D','BAY01',5,0,5,0,'0'),

('OPE104-MI1','BAY104','OPE104-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OPE104-MO1','BAY104','OPE104-MO1','PORT','1','1',NULL,NULL,5,0,0,0,'0'),

('BDEV01LP1','BAY105','BDEV01LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV01LP2','BAY105','BDEV01LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV06LP1','BAY105','BDEV06LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV06LP2','BAY105','BDEV06LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV07LP1','BAY105','BDEV07LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV07LP2','BAY105','BDEV07LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV08LP1','BAY105','BDEV08LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV08LP2','BAY105','BDEV08LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV09LP1','BAY105','BDEV09LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BDEV09LP2','BAY105','BDEV09LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BXRA03LP1','BAY202','BXRA03LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BXRA03LP2','BAY202','BXRA03LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLM08LP1','BAY111','BPLM08LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLM08LP2','BAY111','BPLM08LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BTIE14LP1','BAY204','BTIE14LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BTIE14LP2','BAY204','BTIE14LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPTM05LP2','BAY202','BPTM05LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM21LP1','BAY106','BATM21LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPRB04LP1','BAY203','BPRB04LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BPRB05LP1','BAY203','BPRB05LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE204-MI1','BAY204','OPE204-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE204-MO1','BAY204','OPE204-MO1','PORT','1','1',NULL,NULL,5,0,0,0,'0'),

('OPE207-MI1','BAY207','OPE207-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE207-MO1','BAY207','OPE207-MO1','PORT','1','1',NULL,NULL,5,0,0,0,'0'),

('BPRB06LP1','BAY203','BPRB06LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPRB07LP1','BAY203','BPRB07LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPRB08LP1','BAY203','BPRB08LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPRB09LP1','BAY203','BPRB09LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE209-MI1','BAY209','OPE209-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OPE209-MO1','BAY209','OPE209-MO1','PORT','1','1',NULL,NULL,5,0,0,0,'0'),

('EX205-0C','BAY204','EX205-0C','PORT','0','0','EX205-03','BAY205',5,0,5,0,'0'),

('BSCR05LP2','BAY201','BSCR05LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('EX205-03','BAY205','EX205-03','PORT','0','1','EX205-0C','BAY204',5,0,5,0,'0'),

('BPTM04LP1','BAY202','BPTM04LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BTIE13LP1','BAY204','BTIE13LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN14LP1','BAY102','BSPN14LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN14LP2','BAY102','BSPN14LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN15LP1','BAY102','BSPN15LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN15LP2','BAY102','BSPN15LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BSPN16LP1','BAY102','BSPN16LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN16LP2','BAY102','BSPN16LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('HEXP01LP1','BAY104','HEXP01LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('HEXP01LP2','BAY104','HEXP01LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV15LP1','BAY105','BDEV15LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV15LP2','BAY105','BDEV15LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV16LP1','BAY105','BDEV16LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV16LP2','BAY105','BDEV16LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV18LP1','BAY105','BDEV18LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV18LP2','BAY105','BDEV18LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BDEV05LP1','BAY106','BDEV05LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV05LP2','BAY106','BDEV05LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV05LP3','BAY106','BDEV05LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLM10LP1','BAY111','BPLM10LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLM10LP2','BAY111','BPLM10LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPTM02LP1','BAY202','BPTM02LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPTM02LP2','BAY202','BPTM02LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLM09LP1','BAY211','BPLM09LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLM09LP2','BAY211','BPLM09LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT09LP1','BAY212','BPLT09LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BPLT09LP2','BAY212','BPLT09LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT09LP3','BAY212','BPLT09LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT10LP1','BAY212','BPLT10LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT10LP2','BAY212','BPLT10LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT10LP3','BAY212','BPLT10LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSCR08LP1','BAY201','BSCR08LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSCR08LP2','BAY201','BSCR08LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BTIE11LP1','BAY204','BTIE11LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BTIE11LP2','BAY204','BTIE11LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BTIE12LP1','BAY204','BTIE12LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BTIE12LP2','BAY204','BTIE12LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOM12LP1','BAY206','BAOM12LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOM12LP2','BAY206','BAOM12LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPRB11LP1','BAY203','BPRB11LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOM16LP1','BAY106','BAOM16LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('EX101-0A','BAY01','EX101-0A','PORT','0','1','EX101-01','BAY101',5,0,5,0,'0'),

('EX101-0B','BAY01','EX101-0B','PORT','0','1','EX101-02','BAY101',5,0,5,0,'0'),

('EX102-0A','BAY01','EX102-0A','PORT','0','1','EX102-01','BAY102',5,0,5,0,'0'),

('EX102-0B','BAY01','EX102-0B','PORT','0','0','EX102-02','BAY102',5,0,5,0,'0'),

('EX103-0A','BAY01','EX103-0A','PORT','0','1','EX103-01','BAY103',5,0,5,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('EX103-0B','BAY01','EX103-0B','PORT','0','0','EX103-02','BAY103',5,0,5,0,'0'),

('EX103-0C','BAY01','EX103-0C','PORT','0','1','EX103-03','BAY103',5,0,5,0,'0'),

('EX103-0D','BAY01','EX103-0D','PORT','0','0','EX103-04','BAY103',5,0,5,0,'0'),

('EX104-0A','BAY01','EX104-0A','PORT','0','1','EX104-01','BAY104',5,0,5,0,'0'),

('EX104-0B','BAY01','EX104-0B','PORT','0','0','EX104-02','BAY104',5,0,5,0,'0'),

('EX104-0C','BAY01','EX104-0C','PORT','0','1','EX104-03','BAY104',5,0,5,0,'0'),

('EX104-0D','BAY01','EX104-0D','PORT','0','0','EX104-04','BAY104',5,0,5,0,'0'),

('EX105-0B','BAY01','EX105-0B','PORT','0','0','EX105-02','BAY105',5,0,5,0,'0'),

('EX106-0A','BAY01','EX106-0A','PORT','0','1','EX106-01','BAY106',5,0,5,0,'0'),

('EX106-0B','BAY01','EX106-0B','PORT','0','0','EX106-02','BAY106',5,0,5,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('EX107-0A','BAY01','EX107-0A','PORT','0','0','EX107-01','BAY107',5,0,5,0,'0'),

('EX107-0B','BAY01','EX107-0B','PORT','0','1','EX107-02','BAY107',5,0,5,0,'0'),

('EX108-0A','BAY01','EX108-0A','PORT','0','0','EX108-01','BAY108',5,0,5,0,'0'),

('EX108-0B','BAY01','EX108-0B','PORT','0','1','EX108-02','BAY108',5,0,5,0,'0'),

('EX109-0A','BAY01','EX109-0A','PORT','0','1','EX109-01','BAY109',5,0,5,0,'0'),

('EX109-0B','BAY01','EX109-0B','PORT','0','0','EX109-02','BAY109',5,0,5,0,'0'),

('EX110-0A','BAY01','EX110-0A','PORT','0','0','EX110-01','BAY110',5,0,5,0,'0'),

('EX110-0B','BAY01','EX110-0B','PORT','0','1','EX110-02','BAY110',5,0,5,0,'0'),

('EX110-0C','BAY01','EX110-0C','PORT','0','0','EX110-03','BAY110',5,0,5,0,'0'),

('EX110-0D','BAY01','EX110-0D','PORT','0','1','EX110-04','BAY110',5,0,5,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('EX111-0A','BAY01','EX111-0A','PORT','0','0','EX111-01','BAY111',5,0,5,0,'0'),

('EX111-0B','BAY01','EX111-0B','PORT','0','0','EX111-02','BAY111',5,0,5,0,'0'),

('EX112-0A','BAY01','EX112-0A','PORT','0','1','EX112-01','BAY112',5,0,5,0,'0'),

('EX112-0B','BAY01','EX112-0B','PORT','0','1','EX112-02','BAY112',5,0,5,0,'0'),

('LX101-0A','BAY01','LX101-0A','PORT','0','0','LX101-01','LFT01',5,0,5,0,'0'),

('LX101-0B','BAY01','LX101-0B','PORT','0','1','LX101-02','LFT01',5,0,5,0,'0'),

('SX101-0A','BAY01','SX101-0A','PORT','0','1','SX101-01','STK101',5,0,5,0,'0'),

('SX101-0B','BAY01','SX101-0B','PORT','0','0','SX101-02','STK101',5,0,5,0,'0'),

('SX101-0C','BAY01','SX101-0C','PORT','0','1','SX101-03','STK101',5,0,5,0,'0'),

('EX201-0A','BAY02','EX201-0A','PORT','0','0','EX201-01','BAY201',5,0,5,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('EX201-0B','BAY02','EX201-0B','PORT','0','1','EX201-02','BAY201',5,0,5,0,'0'),

('EX202-0A','BAY02','EX202-0A','PORT','0','0','EX202-01','BAY202',5,0,5,0,'0'),

('EX202-0B','BAY02','EX202-0B','PORT','0','1','EX202-02','BAY202',5,0,5,0,'0'),

('EX203-0A','BAY02','EX203-0A','PORT','0','0','EX203-01','BAY203',5,0,5,0,'0'),

('EX203-0B','BAY02','EX203-0B','PORT','0','1','EX203-02','BAY203',5,0,5,0,'0'),

('EX204-0A','BAY02','EX204-0A','PORT','0','0','EX204-01','BAY204',5,0,5,0,'0'),

('EX204-0B','BAY02','EX204-0B','PORT','0','1','EX204-02','BAY204',5,0,5,0,'0'),

('EX204-0C','BAY02','EX204-0C','PORT','0','0','EX204-03','BAY204',5,0,5,0,'0'),

('EX204-0D','BAY02','EX204-0D','PORT','0','1','EX204-04','BAY204',5,0,5,0,'0'),

('EX205-0A','BAY02','EX205-0A','PORT','0','0','EX205-01','BAY205',5,0,5,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('EX205-0B','BAY02','EX205-0B','PORT','0','1','EX205-02','BAY205',5,0,5,0,'0'),

('EX206-0A','BAY02','EX206-0A','PORT','0','0','EX206-01','BAY206',5,0,5,0,'0'),

('EX206-0B','BAY02','EX206-0B','PORT','0','1','EX206-02','BAY206',5,0,5,0,'0'),

('EX207-0A','BAY02','EX207-0A','PORT','0','0','EX207-01','BAY207',5,0,5,0,'0'),

('EX207-0B','BAY02','EX207-0B','PORT','0','1','EX207-02','BAY207',5,0,5,0,'0'),

('EX207-0C','BAY02','EX207-0C','PORT','0','0','EX207-03','BAY207',5,0,5,0,'0'),

('EX207-0D','BAY02','EX207-0D','PORT','0','1','EX207-04','BAY207',5,0,5,0,'0'),

('EX208-0A','BAY02','EX208-0A','PORT','0','0','EX208-01','BAY208',5,0,5,0,'0'),

('EX208-0B','BAY02','EX208-0B','PORT','0','1','EX208-02','BAY208',5,0,5,0,'0'),

('EX208-0C','BAY02','EX208-0C','PORT','0','0','EX208-03','BAY208',5,0,5,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('EX208-0D','BAY02','EX208-0D','PORT','0','1','EX208-04','BAY208',5,0,5,0,'0'),

('EX209-0A','BAY02','EX209-0A','PORT','0','0','EX209-01','BAY209',5,0,5,0,'0'),

('EX209-0B','BAY02','EX209-0B','PORT','0','1','EX209-02','BAY209',5,0,5,0,'0'),

('EX107-01','BAY107','EX107-01','PORT','0','1','EX107-0A','BAY01',5,0,5,0,'0'),

('EX107-02','BAY107','EX107-02','PORT','0','0','EX107-0B','BAY01',5,0,5,0,'0'),

('BCUE06LP1','BAY206','BCUE06LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('LX102-0A','BAY01','LX102-0A','PORT','0','0','LX102-01','LFT02',5,0,5,0,'0'),

('LX102-0B','BAY01','LX102-0B','PORT','0','1','LX102-02','LFT02',5,0,5,0,'0'),

('LX202-0A','BAY02','LX202-0A','PORT','0','0','LX202-01','LFT02',5,0,5,0,'0'),

('LX202-0B','BAY02','LX202-0B','PORT','0','1','LX202-02','LFT02',5,0,5,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('SX201-0A','BAY02','SX201-0A','PORT','0','1','SX201-01','STK201',5,0,5,0,'0'),

('SX201-0B','BAY02','SX201-0B','PORT','0','0','SX201-02','STK201',5,0,5,0,'0'),

('SX201-0C','BAY02','SX201-0C','PORT','0','1','SX201-03','STK201',5,0,5,0,'0'),

('LX102-01','LFT02','LX102-01','PORT','0','1','LX102-0A','BAY01',5,0,5,0,'0'),

('LX102-02','LFT02','LX102-02','PORT','0','0','LX102-0B','BAY01',5,0,5,0,'0'),

('LX202-01','LFT02','LX202-01','PORT','0','1','LX202-0A','BAY02',5,0,5,0,'0'),

('LX202-02','LFT02','LX202-02','PORT','0','0','LX202-0B','BAY02',5,0,5,0,'0'),

('STK102-MI1','STK102','STK102-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('STK102-MO1','STK102','STK102-MO1','PORT','1','1',NULL,NULL,5,0,0,0,'0'),

('BAOM15LP1','BAY207','BAOM15LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('STK201-MI1','STK201','STK201-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('STK201-MO1','STK201','STK201-MO1','PORT','1','1',NULL,NULL,5,0,0,0,'0'),

('SX201-01','STK201','SX201-01','PORT','0','0','SX201-0A','BAY02',5,0,5,0,'0'),

('SX201-02','STK201','SX201-02','PORT','0','1','SX201-0B','BAY02',5,0,5,0,'0'),

('SX201-03','STK201','SX201-03','PORT','0','0','SX201-0C','BAY02',5,0,5,0,'0'),

('CX101-0A','CVB101','CX101-0A','PORT','0','0','CX101-01','BAY101',5,0,5,0,'0'),

('CX102-0A','CVB101','CX102-0A','PORT','0','0','CX102-01','BAY102',5,0,5,0,'0'),

('CX103-0A','CVB101','CX103-0A','PORT','0','1','CX103-01','BAY103',5,0,5,0,'0'),

('CX103-0B','CVB101','CX103-0B','PORT','0','0','CX103-02','BAY103',5,0,5,0,'0'),

('CX104-0A','CVB101','CX104-0A','PORT','0','0','CX104-01','BAY104',5,0,5,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('CX104-0B','CVB101','CX104-0B','PORT','0','1','CX104-02','BAY104',5,0,5,0,'0'),

('CX105-0A','CVB101','CX105-0A','PORT','0','1','CX105-01','BAY105',5,0,5,0,'0'),

('CX106-0A','CVB101','CX106-0A','PORT','0','1','CX106-01','BAY106',5,0,5,0,'0'),

('CX101-01','BAY101','CX101-01','PORT','0','1','CX101-0A','CVB101',5,0,5,0,'0'),

('CX102-01','BAY102','CX102-01','PORT','0','1','CX102-0A','CVB101',5,0,5,0,'0'),

('CX103-01','BAY103','CX103-01','PORT','0','0','CX103-0A','CVB101',5,0,5,0,'0'),

('CX103-02','BAY103','CX103-02','PORT','0','1','CX103-0B','CVB101',5,0,5,0,'0'),

('CX104-01','BAY104','CX104-01','PORT','0','1','CX104-0A','CVB101',5,0,5,0,'0'),

('CX104-02','BAY104','CX104-02','PORT','0','0','CX104-0B','CVB101',5,0,5,0,'0'),

('CX105-01','BAY105','CX105-01','PORT','0','0','CX105-0A','CVB101',5,0,5,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('CX106-01','BAY106','CX106-01','PORT','0','0','CX106-0A','CVB101',5,0,5,0,'0'),

('BAOM15LP2','BAY207','BAOM15LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPDB04LP2','BAY112','BPDB04LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSCR11LP2','BAY201','BSCR11LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BRFL07LP1','BAY202','BRFL07LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT02LP1','BAY212','BPLT02LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT02LP2','BAY212','BPLT02LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSCR07LP1','BAY108','BSCR07LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSCR07LP2','BAY108','BSCR07LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSTP07LP1','BAY208','BSTP07LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BSTP07LP2','BAY208','BSTP07LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSTP08LP1','BAY208','BSTP08LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSTP08LP2','BAY208','BSTP08LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSTP08LP3','BAY208','BSTP08LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSTP08LP4','BAY208','BSTP08LP4','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLM14LP1','BAY111','BPLM14LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM05LP1','BAY208','BATM05LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM05LP2','BAY208','BATM05LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOM05LP1','BAY208','BAOM05LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOM05LP2','BAY208','BAOM05LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BPLM14LP2','BAY111','BPLM14LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BXRF02LP1','BAY202','BXRF02LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BRFL05LP1','BAY202','BRFL05LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BXRF02LP2','BAY202','BXRF02LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE203-MI1','BAY203','OPE203-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE203-MO1','BAY203','OPE203-MO1','PORT','1','1',NULL,NULL,5,0,0,0,'0'),

('OPE206-MI1','BAY206','OPE206-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-112D','BAY112','OHB-112D','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BSPN09LP1','BAY101','BSPN09LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN09LP2','BAY101','BSPN09LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('EX203-0C','BAY202','EX203-0C','PORT','0','0','EX203-03','BAY203',5,0,5,0,'0'),

('EX203-03','BAY203','EX203-03','PORT','0','1','EX203-0C','BAY202',5,0,5,0,'0'),

('OPE206-MO1','BAY206','OPE206-MO1','PORT','1','1',NULL,NULL,5,0,0,0,'0'),

('OPE210-MI1','BAY210','OPE210-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE210-MO1','BAY210','OPE210-MO1','PORT','1','1',NULL,NULL,5,0,0,0,'0'),

('OHB-106J','BAY106','OHB-106J','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-201L','BAY201','OHB-201L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-106L','BAY106','OHB-106L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-202D','BAY202','OHB-202D','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('TWVL01LP1','BAY101','TWVL01LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('TWVL01LP2','BAY101','TWVL01LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI01LP1','BAY210','BAOI01LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI01LP2','BAY210','BAOI01LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE202-MI1','BAY202','OPE202-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSCR06LP1','BAY108','BSCR06LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE202-MO1','BAY202','OPE202-MO1','PORT','1','1',NULL,NULL,5,0,0,0,'0'),

('BSCR06LP2','BAY108','BSCR06LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI03LP1','BAY210','BAOI03LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI03LP2','BAY210','BAOI03LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-204I','BAY204','OHB-204I','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('EX210-0E','BAY209','EX210-0E','PORT','0','0','EX210-05','BAY210',5,0,5,0,'0'),

('BAOI04LP1','BAY210','BAOI04LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI04LP2','BAY210','BAOI04LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI05LP1','BAY210','BAOI05LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI05LP2','BAY210','BAOI05LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI07LP1','BAY210','BAOI07LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI07LP2','BAY210','BAOI07LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI08LP1','BAY210','BAOI08LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOM01LP1','BAY105','BAOM01LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT03LP1','BAY212','BPLT03LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BAOM01LP2','BAY105','BAOM01LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM01LP1','BAY105','BATM01LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM01LP2','BAY105','BATM01LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT03LP2','BAY212','BPLT03LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT06LP1','BAY212','BPLT06LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV04LP1','BAY105','BDEV04LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV04LP2','BAY105','BDEV04LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT06LP2','BAY212','BPLT06LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT06LP3','BAY212','BPLT06LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT08LP1','BAY212','BPLT08LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BPLT08LP2','BAY212','BPLT08LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT08LP3','BAY212','BPLT08LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI08LP2','BAY210','BAOI08LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI09LP1','BAY210','BAOI09LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI09LP2','BAY210','BAOI09LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI10LP1','BAY210','BAOI10LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI10LP2','BAY210','BAOI10LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI11LP1','BAY210','BAOI11LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI11LP2','BAY210','BAOI11LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-205D','BAY205','OHB-205D','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-01I','BAY01','OHB-01I','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-109K','BAY109','OHB-109K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-110E','BAY110','OHB-110E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-01C','BAY01','OHB-01C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BPLT14LP1','BAY213','BPLT14LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-105D','BAY105','OHB-105D','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BATM24LP2','BAY211','BATM24LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-205J','BAY205','OHB-205J','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-207C','BAY207','OHB-207C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-207M','BAY207','OHB-207M','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BSTP10LP2','BAY208','BSTP10LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-208G','BAY208','OHB-208G','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-209C','BAY209','OHB-209C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('EX211-0E','BAY209','EX211-0E','PORT','0','0','EX211-05','BAY211',5,0,5,0,'0'),

('OHB-209H','BAY209','OHB-209H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BTIE03LP1','BAY206','BTIE03LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BTIE03LP2','BAY206','BTIE03LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BCUE02LP1','BAY206','BCUE02LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BCUE02LP2','BAY206','BCUE02LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BCUE04LP1','BAY206','BCUE04LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BCUE04LP2','BAY206','BCUE04LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BCUE05LP1','BAY206','BCUE05LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLM07LP1','BAY111','BPLM07LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLM07LP2','BAY111','BPLM07LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BCUE05LP2','BAY206','BCUE05LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-209L','BAY209','OHB-209L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('EX210-05','BAY210','EX210-05','PORT','0','1','EX210-0E','BAY209',5,0,5,0,'0'),

('OHB-210C','BAY210','OHB-210C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-211C','BAY211','OHB-211C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('EX211-05','BAY211','EX211-05','PORT','0','1','EX211-0E','BAY209',5,0,5,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-211F','BAY211','OHB-211F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('EX108-0C','BAY107','EX108-0C','PORT','0','0','EX108-03','BAY108',5,0,5,0,'0'),

('BCUE09LP2','BAY206','BCUE09LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('EX108-03','BAY108','EX108-03','PORT','0','1','EX108-0C','BAY107',5,0,5,0,'0'),

('EX107-0C','BAY108','EX107-0C','PORT','0','0','EX107-03','BAY107',5,0,5,0,'0'),

('BAOM07LP1','BAY207','BAOM07LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOM07LP2','BAY207','BAOM07LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM04LP1','BAY207','BATM04LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM04LP2','BAY207','BATM04LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM06LP1','BAY207','BATM06LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BATM06LP2','BAY207','BATM06LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM12LP1','BAY207','BATM12LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM12LP2','BAY207','BATM12LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM13LP1','BAY207','BATM13LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM13LP2','BAY207','BATM13LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('HATM01LP1','BAY207','HATM01LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('HATM01LP2','BAY207','HATM01LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('EX107-03','BAY107','EX107-03','PORT','0','1','EX107-0C','BAY108',5,0,5,0,'0'),

('EX112-0C','BAY111','EX112-0C','PORT','0','0','EX112-03','BAY112',5,0,5,0,'0'),

('EX112-03','BAY112','EX112-03','PORT','0','1','EX112-0C','BAY111',5,0,5,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BEXP10LP1','BAY104','BEXP10LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BEXP10LP2','BAY104','BEXP10LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BEXP11LP1','BAY104','BEXP11LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BEXP11LP2','BAY104','BEXP11LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOM11LP1','BAY106','BAOM11LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOM11LP2','BAY106','BAOM11LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT08LP1','BAY108','BSOT08LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT08LP2','BAY108','BSOT08LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN13LP1','BAY101','BSPN13LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN13LP2','BAY101','BSPN13LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BPVD08LP1','BAY110','BPVD08LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD08LP2','BAY110','BPVD08LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD09LP1','BAY110','BPVD09LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD09LP2','BAY110','BPVD09LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT08LP3','BAY108','BSOT08LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD10LP1','BAY111','BPVD10LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD10LP2','BAY111','BPVD10LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BRFL06LP1','BAY202','BRFL06LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BRFL06LP2','BAY202','BRFL06LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLM11LP1','BAY211','BPLM11LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BPLM11LP2','BAY211','BPLM11LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLM12LP1','BAY211','BPLM12LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BEXP08LP1','BAY103','BEXP08LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BEXP08LP2','BAY103','BEXP08LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLM12LP2','BAY211','BPLM12LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN20LP1','BAY102','BSPN20LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAHM01LP1','BAY102','BAHM01LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN10LP1','BAY101','BSPN10LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN10LP2','BAY101','BSPN10LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV10LP1','BAY105','BDEV10LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BDEV10LP2','BAY105','BDEV10LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD06LP1','BAY109','BPVD06LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD06LP2','BAY109','BPVD06LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD07LP1','BAY109','BPVD07LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD07LP2','BAY109','BPVD07LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM07LP1','BAY208','BATM07LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM07LP2','BAY208','BATM07LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM08LP1','BAY208','BATM08LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM08LP2','BAY208','BATM08LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BEXP09LP1','BAY103','BEXP09LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BEXP09LP2','BAY103','BEXP09LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAHM01LP2','BAY102','BAHM01LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN11LP1','BAY101','BSPN11LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN11LP2','BAY101','BSPN11LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN12LP1','BAY101','BSPN12LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN12LP2','BAY101','BSPN12LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOM08LP1','BAY101','BAOM08LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOM08LP2','BAY101','BAOM08LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV11LP1','BAY105','BDEV11LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV11LP2','BAY105','BDEV11LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BDEV12LP1','BAY105','BDEV12LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV12LP2','BAY105','BDEV12LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('SX102-0A','BAY108','SX102-0A','PORT','0','0','SX102-01','STK102',5,0,5,0,'0'),

('BAOM03LP1','BAY204','BAOM03LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOM03LP2','BAY204','BAOM03LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOM06LP1','BAY204','BAOM06LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOM06LP2','BAY204','BAOM06LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM09LP1','BAY204','BATM09LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM09LP2','BAY204','BATM09LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM10LP1','BAY204','BATM10LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BATM10LP2','BAY204','BATM10LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM11LP1','BAY204','BATM11LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM11LP2','BAY204','BATM11LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BTIE04LP1','BAY204','BTIE04LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BTIE04LP2','BAY204','BTIE04LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BTIE05LP1','BAY204','BTIE05LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BTIE05LP2','BAY204','BTIE05LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BTIE06LP1','BAY204','BTIE06LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BTIE06LP2','BAY204','BTIE06LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BTIE07LP1','BAY204','BTIE07LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BTIE07LP2','BAY204','BTIE07LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BTIE08LP1','BAY204','BTIE08LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BTIE08LP2','BAY204','BTIE08LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('SX102-0B','BAY108','SX102-0B','PORT','0','1','SX102-02','STK102',5,0,5,0,'0'),

('SX102-01','STK102','SX102-01','PORT','0','1','SX102-0A','BAY108',5,0,5,0,'0'),

('SX102-02','STK102','SX102-02','PORT','0','0','SX102-0B','BAY108',5,0,5,0,'0'),

('BDEV13LP1','BAY105','BDEV13LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV13LP2','BAY105','BDEV13LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV14LP1','BAY105','BDEV14LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV14LP2','BAY105','BDEV14LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BPLM02LP1','BAY111','BPLM02LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLM02LP2','BAY111','BPLM02LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPTM03LP1','BAY202','BPTM03LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPRB12LP1','BAY203','BPRB12LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI17LP1','BAY210','BAOI17LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLM15LP1','BAY211','BPLM15LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPTM03LP2','BAY202','BPTM03LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BRFL04LP2','BAY202','BRFL04LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD14LP2','BAY110','BPVD14LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT01LP1','BAY212','BPLT01LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BPLT01LP2','BAY212','BPLT01LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BRFL05LP2','BAY202','BRFL05LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BCUE03LP1','BAY206','BCUE03LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BRFL07LP2','BAY202','BRFL07LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSCR04LP1','BAY107','BSCR04LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BCUE03LP2','BAY206','BCUE03LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BEXP07LP1','BAY103','BEXP07LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BEXP07LP2','BAY103','BEXP07LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOM10LP1','BAY211','BAOM10LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOM10LP2','BAY211','BAOM10LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BAOM16LP2','BAY106','BAOM16LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSCR04LP2','BAY107','BSCR04LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM16LP1','BAY106','BATM16LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT17LP1','BAY213','BPLT17LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM16LP2','BAY106','BATM16LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT06LP2','BAY112','BSOT06LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT09LP1','BAY112','BSOT09LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT09LP2','BAY112','BSOT09LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT09LP3','BAY112','BSOT09LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT04LP1','BAY107','BSOT04LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BSOT04LP2','BAY107','BSOT04LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM14LP1','BAY207','BATM14LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT04LP3','BAY107','BSOT04LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT05LP1','BAY107','BSOT05LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT05LP2','BAY107','BSOT05LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT05LP3','BAY107','BSOT05LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BTIE09LP1','BAY204','BTIE09LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT10LP1','BAY112','BSOT10LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT10LP2','BAY112','BSOT10LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT10LP3','BAY112','BSOT10LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BTIE09LP2','BAY204','BTIE09LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BTIE10LP1','BAY204','BTIE10LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BTIE10LP2','BAY204','BTIE10LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLM05LP1','BAY211','BPLM05LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLM05LP2','BAY211','BPLM05LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLM05LP3','BAY211','BPLM05LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLM06LP1','BAY211','BPLM06LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLM06LP2','BAY211','BPLM06LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI02LP1','BAY211','BAOI02LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI02LP2','BAY211','BAOI02LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BAOI16LP1','BAY210','BAOI16LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-207K','BAY207','OHB-207K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OPE211-MI1','BAY211','OPE211-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE211-MO1','BAY211','OPE211-MO1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI12LP1','BAY210','BAOI12LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM14LP2','BAY207','BATM14LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT06LP1','BAY112','BSOT06LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT06LP3','BAY112','BSOT06LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI16LP2','BAY210','BAOI16LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI17LP2','BAY210','BAOI17LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-208E','BAY208','OHB-208E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-208K','BAY208','OHB-208K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-209G','BAY209','OHB-209G','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BPLT04LP1','BAY212','BPLT04LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT04LP2','BAY212','BPLT04LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI12LP2','BAY210','BAOI12LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT04LP3','BAY212','BPLT04LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT11LP1','BAY212','BPLT11LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT11LP2','BAY212','BPLT11LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT11LP3','BAY212','BPLT11LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BPLT12LP1','BAY212','BPLT12LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT12LP2','BAY212','BPLT12LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT12LP3','BAY212','BPLT12LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BCUE06LP2','BAY206','BCUE06LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOM13LP1','BAY207','BAOM13LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOM13LP2','BAY207','BAOM13LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM17LP1','BAY207','BATM17LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM17LP2','BAY207','BATM17LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM18LP1','BAY207','BATM18LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM18LP2','BAY207','BATM18LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-211B','BAY211','OHB-211B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-103H','BAY103','OHB-103H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BPLT13LP1','BAY212','BPLT13LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT13LP2','BAY212','BPLT13LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM20LP2','BAY106','BATM20LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-212F','BAY212','OHB-212F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-103K','BAY103','OHB-103K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-01G','BAY01','OHB-01G','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BPLT17LP3','BAY213','BPLT17LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT16LP3','BAY213','BPLT16LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BPLT13LP3','BAY212','BPLT13LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-106K','BAY106','OHB-106K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-02M','BAY02','OHB-02M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BPDB01LP1','BAY112','BPDB01LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPDB01LP2','BAY112','BPDB01LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPDB02LP1','BAY112','BPDB02LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPDB02LP2','BAY112','BPDB02LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-107D','BAY107','OHB-107D','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-01H','BAY01','OHB-01H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-01J','BAY01','OHB-01J','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-109D','BAY109','OHB-109D','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-01K','BAY01','OHB-01K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-109F','BAY109','OHB-109F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-109I','BAY109','OHB-109I','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-02I','BAY02','OHB-02I','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-104C','BAY104','OHB-104C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-104D','BAY104','OHB-104D','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-101E','BAY101','OHB-101E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-110G','BAY110','OHB-110G','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-108D','BAY108','OHB-108D','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-108G','BAY108','OHB-108G','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BATM24LP1','BAY211','BATM24LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-109B','BAY109','OHB-109B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BATM20LP1','BAY106','BATM20LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-110M','BAY110','OHB-110M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-102A','BAY102','OHB-102A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-104E','BAY104','OHB-104E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-104F','BAY104','OHB-104F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-105A','BAY105','OHB-105A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-111F','BAY111','OHB-111F','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-111H','BAY111','OHB-111H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-112E','BAY112','OHB-112E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-112F','BAY112','OHB-112F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-107I','BAY107','OHB-107I','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-108A','BAY108','OHB-108A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-108C','BAY108','OHB-108C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-112G','BAY112','OHB-112G','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-105G','BAY105','OHB-105G','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-207F','BAY207','OHB-207F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-02D','BAY02','OHB-02D','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-02H','BAY02','OHB-02H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-103B','BAY103','OHB-103B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-104M','BAY104','OHB-104M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BPVD12LP2','BAY110','BPVD12LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-103E','BAY103','OHB-103E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-104I','BAY104','OHB-104I','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-105C','BAY105','OHB-105C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-105I','BAY105','OHB-105I','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-106A','BAY106','OHB-106A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-01F','BAY01','OHB-01F','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-106B','BAY106','OHB-106B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-106F','BAY106','OHB-106F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-106H','BAY106','OHB-106H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-107A','BAY107','OHB-107A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-107F','BAY107','OHB-107F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-107H','BAY107','OHB-107H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BPVD12LP1','BAY110','BPVD12LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('SKB-101C','STK101','SKB-101C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BEXP12LP1','BAY104','BEXP12LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-111G','BAY111','OHB-111G','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('SKB-202A','STK202','SKB-202A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-209D','BAY209','OHB-209D','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OPE205-MI1','BAY205','OPE205-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BEXP12LP2','BAY104','BEXP12LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV17LP1','BAY105','BDEV17LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BDEV17LP2','BAY105','BDEV17LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSCR09LP1','BAY107','BSCR09LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE205-MO1','BAY205','OPE205-MO1','PORT','1','1',NULL,NULL,5,0,0,0,'0'),

('BSCR09LP2','BAY107','BSCR09LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT15LP1','BAY213','BPLT15LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BSCR10LP1','BAY107','BSCR10LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSCR10LP2','BAY107','BSCR10LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD11LP1','BAY110','BPVD11LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD11LP2','BAY110','BPVD11LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM15LP1','BAY204','BATM15LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM15LP2','BAY204','BATM15LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM19LP1','BAY204','BATM19LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BATM19LP2','BAY204','BATM19LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOM14LP1','BAY208','BAOM14LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOM14LP2','BAY208','BAOM14LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BAOI13LP1','BAY210','BAOI13LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI13LP2','BAY210','BAOI13LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLM13LP1','BAY211','BPLM13LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLM13LP2','BAY211','BPLM13LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-111I','BAY111','OHB-111I','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-112K','BAY112','OHB-112K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BDEV20LP1','BAY105','BDEV20LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-112M','BAY112','OHB-112M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BSPN17LP2','BAY102','BSPN17LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-210A','BAY210','OHB-210A','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-211I','BAY211','OHB-211I','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-201E','BAY201','OHB-201E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BPLT19LP1','BAY213','BPLT19LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-201H','BAY201','OHB-201H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-202A','BAY202','OHB-202A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('TMP205LP1','BAY205','TMP205LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('TMP209LP1','BAY209','TMP209LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-202E','BAY202','OHB-202E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BPTM04LP2','BAY202','BPTM04LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-202G','BAY202','OHB-202G','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BSCR05LP1','BAY201','BSCR05LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSTP09LP2','BAY208','BSTP09LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-206D','BAY206','OHB-206D','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-202K','BAY202','OHB-202K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-212J','BAY212','OHB-212J','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-202M','BAY202','OHB-202M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-203L','BAY203','OHB-203L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-203M','BAY203','OHB-203M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-204B','BAY204','OHB-204B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-204D','BAY204','OHB-204D','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BATM23LP1','BAY211','BATM23LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-205E','BAY205','OHB-205E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BATM23LP2','BAY211','BATM23LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN17LP1','BAY102','BSPN17LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN18LP1','BAY102','BSPN18LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN18LP2','BAY102','BSPN18LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN19LP1','BAY102','BSPN19LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSPN19LP2','BAY102','BSPN19LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-207G','BAY207','OHB-207G','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-206G','BAY206','OHB-206G','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-206J','BAY206','OHB-206J','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-205F','BAY205','OHB-205F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-208D','BAY208','OHB-208D','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-108H','BAY108','OHB-108H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BPLT16LP1','BAY213','BPLT16LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT17LP2','BAY213','BPLT17LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-204J','BAY204','OHB-204J','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BDEV21LP2','BAY105','BDEV21LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-203B','BAY203','OHB-203B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-212I','BAY212','OHB-212I','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BSPN20LP2','BAY102','BSPN20LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT14LP3','BAY213','BPLT14LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-201B','BAY201','OHB-201B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-212M','BAY212','OHB-212M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-201C','BAY201','OHB-201C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('SKB-102A','STK102','SKB-102A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-202I','BAY202','OHB-202I','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-01M','BAY01','OHB-01M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-204L','BAY204','OHB-204L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-205C','BAY205','OHB-205C','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-02B','BAY02','OHB-02B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-02L','BAY02','OHB-02L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-111E','BAY111','OHB-111E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-213A','BAY213','OHB-213A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-101A','BAY101','OHB-101A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-109G','BAY109','OHB-109G','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-102E','BAY102','OHB-102E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-111J','BAY111','OHB-111J','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-211J','BAY211','OHB-211J','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-102I','BAY102','OHB-102I','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-210I','BAY210','OHB-210I','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BAOM18LP1','BAY205','BAOM18LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-207H','BAY207','OHB-207H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-205G','BAY205','OHB-205G','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-205K','BAY205','OHB-205K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-208C','BAY208','OHB-208C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BATM21LP2','BAY106','BATM21LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-209A','BAY209','OHB-209A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-207D','BAY207','OHB-207D','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-209K','BAY209','OHB-209K','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-210D','BAY210','OHB-210D','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-111B','BAY111','OHB-111B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-206M','BAY206','OHB-206M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-210E','BAY210','OHB-210E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-102L','BAY102','OHB-102L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-102M','BAY102','OHB-102M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BATM22LP2','BAY106','BATM22LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-103D','BAY103','OHB-103D','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-103F','BAY103','OHB-103F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-103J','BAY103','OHB-103J','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-104A','BAY104','OHB-104A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-213E','BAY213','OHB-213E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-210M','BAY210','OHB-210M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-203D','BAY203','OHB-203D','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-204A','BAY204','OHB-204A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-211A','BAY211','OHB-211A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-212C','BAY212','OHB-212C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-212E','BAY212','OHB-212E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-111K','BAY111','OHB-111K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-111L','BAY111','OHB-111L','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-213H','BAY213','OHB-213H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-213L','BAY213','OHB-213L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-213M','BAY213','OHB-213M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('SKB-101A','STK101','SKB-101A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('SKB-201A','STK201','SKB-201A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('SKB-201B','STK201','SKB-201B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BAHM01LP3','BAY102','BAHM01LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('EX105-01','BAY105','EX105-01','PORT','0','1','EX105-0A','BAY01',5,0,5,0,'0'),

('EX105-0A','BAY01','EX105-0A','PORT','0','0','EX105-01','BAY105',5,0,5,0,'0'),

('BSOT11LP1','BAY108','BSOT11LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BDEV19LP2','BAY106','BDEV19LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT11LP2','BAY108','BSOT11LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT11LP3','BAY108','BSOT11LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT03LP1','BAY112','BSOT03LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSOT03LP2','BAY112','BSOT03LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPVD13LP2','BAY110','BPVD13LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSTP09LP1','BAY208','BSTP09LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPLT15LP3','BAY213','BPLT15LP3','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-202F','BAY202','OHB-202F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BAOI15LP1','BAY210','BAOI15LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-213K','BAY213','OHB-213K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-207B','BAY207','OHB-207B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BAOI15LP2','BAY210','BAOI15LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOI14LP1','BAY210','BAOI14LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-208F','BAY208','OHB-208F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BSTP10LP1','BAY208','BSTP10LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-209F','BAY209','OHB-209F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-213B','BAY213','OHB-213B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BCUE08LP2','BAY206','BCUE08LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-211D','BAY211','OHB-211D','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-211M','BAY211','OHB-211M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-212B','BAY212','OHB-212B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-212D','BAY212','OHB-212D','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-01A','BAY01','OHB-01A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BAOI14LP2','BAY210','BAOI14LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-105B','BAY105','OHB-105B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-02J','BAY02','OHB-02J','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-101B','BAY101','OHB-101B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-101C','BAY101','OHB-101C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-203A','BAY203','OHB-203A','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-204C','BAY204','OHB-204C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-105K','BAY105','OHB-105K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-106D','BAY106','OHB-106D','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-106E','BAY106','OHB-106E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-106G','BAY106','OHB-106G','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-106I','BAY106','OHB-106I','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-101M','BAY101','OHB-101M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('LFT02-MI1','LFT02','LFT02-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE201-MI1','BAY201','OPE201-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OPE201-MO1','BAY201','OPE201-MO1','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('LFT02-MO1','LFT02','LFT02-MO1','PORT','1','1',NULL,NULL,5,0,0,0,'0'),

('OHB-102B','BAY102','OHB-102B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('STK202-MI1','STK202','STK202-MI1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('STK202-MO1','STK202','STK202-MO1','PORT','1','1',NULL,NULL,5,0,0,0,'0'),

('SX202-01','STK202','SX202-01','PORT','0','0','SX202-0A','BAY210',5,0,5,0,'0'),

('SX202-02','STK202','SX202-02','PORT','0','1','SX202-0B','BAY210',5,0,5,0,'0'),

('SX202-0A','BAY210','SX202-0A','PORT','0','1','SX202-01','STK202',5,0,5,0,'0'),

('SX202-0B','BAY210','SX202-0B','PORT','0','0','SX202-02','STK202',5,0,5,0,'0'),

('OHB-102F','BAY102','OHB-102F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-103G','BAY103','OHB-103G','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-104K','BAY104','OHB-104K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-106M','BAY106','OHB-106M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-107C','BAY107','OHB-107C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-107J','BAY107','OHB-107J','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-108B','BAY108','OHB-108B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-108K','BAY108','OHB-108K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-109C','BAY109','OHB-109C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-110D','BAY110','OHB-110D','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-110L','BAY110','OHB-110L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-111M','BAY111','OHB-111M','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-112I','BAY112','OHB-112I','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-112L','BAY112','OHB-112L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-202C','BAY202','OHB-202C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-206C','BAY206','OHB-206C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-206E','BAY206','OHB-206E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BPLM15LP2','BAY211','BPLM15LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-202B','BAY202','OHB-202B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-105E','BAY105','OHB-105E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-105F','BAY105','OHB-105F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-210G','BAY210','OHB-210G','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-210H','BAY210','OHB-210H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-210B','BAY210','OHB-210B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-210F','BAY210','OHB-210F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-107B','BAY107','OHB-107B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-01L','BAY01','OHB-01L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-201G','BAY201','OHB-201G','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-201M','BAY201','OHB-201M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-208H','BAY208','OHB-208H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-02A','BAY02','OHB-02A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-208J','BAY208','OHB-208J','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-203K','BAY203','OHB-203K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-211G','BAY211','OHB-211G','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-02K','BAY02','OHB-02K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-101H','BAY101','OHB-101H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-101J','BAY101','OHB-101J','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-101L','BAY101','OHB-101L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-102G','BAY102','OHB-102G','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-103I','BAY103','OHB-103I','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-107G','BAY107','OHB-107G','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-108J','BAY108','OHB-108J','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-108L','BAY108','OHB-108L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-109A','BAY109','OHB-109A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-109J','BAY109','OHB-109J','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-110J','BAY110','OHB-110J','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-111C','BAY111','OHB-111C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-211K','BAY211','OHB-211K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-212G','BAY212','OHB-212G','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-104B','BAY104','OHB-104B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-112A','BAY112','OHB-112A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-213G','BAY213','OHB-213G','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BPLT19LP2','BAY213','BPLT19LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-213D','BAY213','OHB-213D','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-213J','BAY213','OHB-213J','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-104G','BAY104','OHB-104G','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-105L','BAY105','OHB-105L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-107M','BAY107','OHB-107M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-103A','BAY103','OHB-103A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-101D','BAY101','OHB-101D','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-203F','BAY203','OHB-203F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-203H','BAY203','OHB-203H','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-108F','BAY108','OHB-108F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-102H','BAY102','OHB-102H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-108E','BAY108','OHB-108E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-206F','BAY206','OHB-206F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-208I','BAY208','OHB-208I','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-110H','BAY110','OHB-110H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-203J','BAY203','OHB-203J','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-205M','BAY205','OHB-205M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-208M','BAY208','OHB-208M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-209E','BAY209','OHB-209E','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-211E','BAY211','OHB-211E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BSCR12LP1','BAY107','BSCR12LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-112C','BAY112','OHB-112C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-107L','BAY107','OHB-107L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-101I','BAY101','OHB-101I','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-208L','BAY208','OHB-208L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-108M','BAY108','OHB-108M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-02C','BAY02','OHB-02C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-209M','BAY209','OHB-209M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-01E','BAY01','OHB-01E','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-101F','BAY101','OHB-101F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-102C','BAY102','OHB-102C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-103M','BAY103','OHB-103M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-106C','BAY106','OHB-106C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BCUE07LP1','BAY206','BCUE07LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-107E','BAY107','OHB-107E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-109E','BAY109','OHB-109E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-109H','BAY109','OHB-109H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-109M','BAY109','OHB-109M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-110C','BAY110','OHB-110C','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-112B','BAY112','OHB-112B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-112H','BAY112','OHB-112H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-201I','BAY201','OHB-201I','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-201K','BAY201','OHB-201K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-202J','BAY202','OHB-202J','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-204F','BAY204','OHB-204F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-204H','BAY204','OHB-204H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-206B','BAY206','OHB-206B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-206H','BAY206','OHB-206H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-206K','BAY206','OHB-206K','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-207A','BAY207','OHB-207A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-207L','BAY207','OHB-207L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-208B','BAY208','OHB-208B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BPTM05LP1','BAY202','BPTM05LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-210L','BAY210','OHB-210L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-211H','BAY211','OHB-211H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-213C','BAY213','OHB-213C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('SLF-101','STK101','SLF-101','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BPVD14LP1','BAY110','BPVD14LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BTIE15LP2','BAY205','BTIE15LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BPLT16LP2','BAY213','BPLT16LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSCR12LP2','BAY107','BSCR12LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BPDB03LP2','BAY112','BPDB03LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BTIE15LP1','BAY205','BTIE15LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BCUE09LP1','BAY206','BCUE09LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BTIE13LP2','BAY204','BTIE13LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-110A','BAY110','OHB-110A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BPDB04LP1','BAY112','BPDB04LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BSCR11LP1','BAY201','BSCR11LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-205B','BAY205','OHB-205B','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-110I','BAY110','OHB-110I','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BAOM17LP2','BAY205','BAOM17LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('BAOM17LP1','BAY205','BAOM17LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-01B','BAY01','OHB-01B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BAOM18LP2','BAY205','BAOM18LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-02E','BAY02','OHB-02E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-02G','BAY02','OHB-02G','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-111A','BAY111','OHB-111A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-110F','BAY110','OHB-110F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-101G','BAY101','OHB-101G','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-209B','BAY209','OHB-209B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-101K','BAY101','OHB-101K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-212A','BAY212','OHB-212A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-211L','BAY211','OHB-211L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-209J','BAY209','OHB-209J','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-206L','BAY206','OHB-206L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-203C','BAY203','OHB-203C','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-111D','BAY111','OHB-111D','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-203E','BAY203','OHB-203E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-112J','BAY112','OHB-112J','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('BPDB03LP1','BAY112','BPDB03LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-203G','BAY203','OHB-203G','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-203I','BAY203','OHB-203I','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-201F','BAY201','OHB-201F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-201A','BAY201','OHB-201A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-104L','BAY104','OHB-104L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-201D','BAY201','OHB-201D','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-109L','BAY109','OHB-109L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-202H','BAY202','OHB-202H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-108I','BAY108','OHB-108I','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-202L','BAY202','OHB-202L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-105H','BAY105','OHB-105H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-204E','BAY204','OHB-204E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-204G','BAY204','OHB-204G','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-204K','BAY204','OHB-204K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-102D','BAY102','OHB-102D','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-105M','BAY105','OHB-105M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-204M','BAY204','OHB-204M','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-102K','BAY102','OHB-102K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-103C','BAY103','OHB-103C','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-104H','BAY104','OHB-104H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-105J','BAY105','OHB-105J','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-107K','BAY107','OHB-107K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-205A','BAY205','OHB-205A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-205I','BAY205','OHB-205I','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-206I','BAY206','OHB-206I','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-207I','BAY207','OHB-207I','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-208A','BAY208','OHB-208A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-210J','BAY210','OHB-210J','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-210K','BAY210','OHB-210K','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-212H','BAY212','OHB-212H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-212K','BAY212','OHB-212K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BCUE08LP1','BAY206','BCUE08LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-205H','BAY205','OHB-205H','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-01D','BAY01','OHB-01D','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-104J','BAY104','OHB-104J','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BCUE07LP2','BAY206','BCUE07LP2','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-02F','BAY02','OHB-02F','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-205L','BAY205','OHB-205L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-213F','BAY213','OHB-213F','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-206A','BAY206','OHB-206A','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-207E','BAY207','OHB-207E','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-207J','BAY207','OHB-207J','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('BPRB13LP1','BAY203','BPRB13LP1','PORT','1','0',NULL,NULL,5,0,0,0,'0'),

('OHB-209I','BAY209','OHB-209I','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-212L','BAY212','OHB-212L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-213I','BAY213','OHB-213I','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('SKB-101B','STK101','SKB-101B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-103L','BAY103','OHB-103L','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-102J','BAY102','OHB-102J','ZONE','1','0',NULL,NULL,0,0,0,0,'0');

INSERT INTO HTKS.NODE (NODEID,EQPID,NAME,"TYPE",ENDEFFECTOR,DIRECTION,MAPNODEID,MAPEQPID,X,Y,"STATIC","USING",BIDIRECTION) VALUES

('OHB-110B','BAY110','OHB-110B','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-110K','BAY110','OHB-110K','ZONE','1','0',NULL,NULL,0,0,0,0,'0'),

('OHB-201J','BAY201','OHB-201J','ZONE','1','0',NULL,NULL,0,0,0,0,'0');