gfwleak/nms-nmsweb
Archived
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
This repository has been archived on 2025-09-14. You can view files and clone it, but cannot push or open issues or pull requests.
Files
k18-1.0
nms-nmsweb/sql/sqlupdate(20130703-20130703).sql

383 lines
42 KiB
MySQL
Raw Permalink Normal View History

initial commit
2018-09-27 16:21:05 +08:00
---现在节点组中新增缺少的4个节点组（如下），其节点组ID依次为：148,149,150,151
--1、电信分流D/分流K设备（一级分流设备）
--2、移动、铁通共用分流D/分流K设备（一级分流设备）
--3、联通、教育共用分流D/分流K设备（一级分流设备）
--4、科技分流D（科技侧）
--新增分流设备灯泡位置数据
insert into NODEGROUP_POSITION (ID, SYSTEM_ID, GROUP_ID, PGROUP_ID, SHOW_LEVEL, SHOW_INDEX, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, SHOW_STATUS, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (seq_nodegroup_posITION.Nextval, 61, 148, 0, 2, NULL, 'image', 300,45, 25, 25, 'red', 1, 'green_bulb.png', 0, sysdate, NULL, sysdate,NULL );
insert into NODEGROUP_POSITION (ID, SYSTEM_ID, GROUP_ID, PGROUP_ID, SHOW_LEVEL, SHOW_INDEX, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, SHOW_STATUS, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (seq_nodegroup_posITION.Nextval, 61, 149, 0, 2, NULL, 'image', 307,235, 25, 25, 'red', 1, 'green_bulb.png', 0, sysdate, NULL, sysdate,NULL );
insert into NODEGROUP_POSITION (ID, SYSTEM_ID, GROUP_ID, PGROUP_ID, SHOW_LEVEL, SHOW_INDEX, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, SHOW_STATUS, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (seq_nodegroup_posITION.Nextval, 61, 150, 0, 2, NULL, 'image', 309,485, 25, 25, 'red', 1, 'green_bulb.png', 0, sysdate, NULL, sysdate,NULL );
insert into NODEGROUP_POSITION (ID, SYSTEM_ID, GROUP_ID, PGROUP_ID, SHOW_LEVEL, SHOW_INDEX, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, SHOW_STATUS, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (seq_nodegroup_posITION.Nextval, 61, 151, 0, 2, NULL, 'image', 304,653, 25, 25, 'red', 1, 'green_bulb.png', 0, sysdate, NULL, sysdate,NULL );
--NODEGROUP_ARROW_POSITION表预置数据更新
DELETE FROM NODEGROUP_ARROW_POSITION
-----------------------------服务器1.1-8------------------
--后端服务器-核心交换机
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 121, 139, 734, 58, 105, 4, 'arrow-green_h_xh.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 121, 139, 734, 58, 4, 230, 'arrow-green_v_xh_f.gif', sysdate, null, sysdate, null);
--日志服务器-核心交换机
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 122, 139, 744,178,95,4, 'arrow-green_h_xh.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 122, 139, 744,178,4,115, 'arrow-green_v_xh_f.gif', sysdate, null, sysdate, null);
--日志服务器-光纤交换机
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 122, NULL, 878,178,36,4, 'arrow-green_h_xh.gif', sysdate, null, sysdate, null);
--087交换机-核心交换机
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, NULL, 139, 754,264,164,4, 'arrow-green_h_xh.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, NULL, 139, 754,264,4,34, 'arrow-green_v_xh_f.gif', sysdate, null, sysdate, null);
--邮件服务器-核心交换机
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 123, 139, 758,312,80,4, 'arrow-green_h_xh.gif', sysdate, null, sysdate, null);
--087系统-核心交换机
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 124, 139, 754,332,4,100, 'arrow-green_v_xh.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 124, 139, 754,428,86,4, 'arrow-green_h_xh.gif', sysdate, null, sysdate, null);
--087系统-光纤交换机1-3
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 124, NULL, 877,428,40,4, 'arrow-green_h_xh.gif', sysdate, null, sysdate, null);
--界面服务器-核心交换机
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 125, 139, 746,337,4,164, 'arrow-green_v_xh.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 125, 139, 746,497,174,4, 'arrow-green_h_xh.gif', sysdate, null, sysdate, null);
--分中心-核心交换机
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 126, 139, 738,341,4,215, 'arrow-green_v_xh.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 126, 139, 738,552,102,4, 'arrow-green_h_xh.gif', sysdate, null, sysdate, null);
--省平台后端服务器-核心交换机
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 127, 139, 728,344,4,280, 'arrow-green_v_xh.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 127, 139, 730,620,194,4, 'arrow-green_h_xh.gif', sysdate, null, sysdate, null);
--黑盒服务器-核心交换机
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 128, 139, 718,341,4,337, 'arrow-green_v_xh.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 128, 139, 718,674,120,4, 'arrow-green_h_xh.gif', sysdate, null, sysdate, null);
--黑盒服务器-省平台用户接入交换机
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 128, NULL, 876,674,42,4, 'arrow-green_h_xh.gif', sysdate, null, sysdate, null);
-----------------------------交换机1.1-5------------------
--电信汇接交换机-核心交换机
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 140, 139, 720,95,4,195, 'arrow-green_v_xh_f.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 140, 139, 536,95,188,4, 'arrow-green_h_xh_f.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 140, 139, 536,75,4,24, 'arrow-green_v_xh_f.gif', sysdate, null, sysdate, null);
--电信汇接交换机-电信一级节点
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 133, 140, 472,58,30,4, 'arrow-green_h_xh.gif', sysdate, null, sysdate, null);
--电信汇接交换机-电信二级节点
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 140, 129, 550,58,30,4, 'arrow-green_h_xh.gif', sysdate, null, sysdate, null);
--电信汇接交换机-电信侧封堵路由
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 140, NULL, 516,75,4,24, 'arrow-green_v.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 140, NULL, 186,95,330,4, 'arrow-green_h_f.gif', sysdate, null, sysdate, null);
--移动汇接交换机-核心交换机
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 141, 139, 710,230,4,66, 'arrow-green_v_xh_f.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 141, 139, 530,230,184,4, 'arrow-green_h_xh_f.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 141, 139, 530,206,4,28, 'arrow-green_v_xh_f.gif', sysdate, null, sysdate, null);
--移动汇接交换机-移动一级节点
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 134, 141, 470,178,40,4, 'arrow-green_h_xh.gif', sysdate, null, sysdate, null);
--移动汇接交换机-移动二级节点
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 141, 130, 554,178,30,4, 'arrow-green_h_xh.gif', sysdate, null, sysdate, null);
--移动汇接交换机-移动侧封堵路由
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 141, NULL, 530,148,4,16, 'arrow-green_v_f.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 141, NULL, 234,148,300,4, 'arrow-green_h_f.gif', sysdate, null, sysdate, null);
--铁通汇接交换机-核心交换机
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 142, 139, 702,264,4,36, 'arrow-green_v_xh_f.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 142, 139, 530,264,4,30, 'arrow-green_v_xh.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 142, 139, 530,264,176,4, 'arrow-green_h_xh_f.gif', sysdate, null, sysdate, null);
--铁通汇接交换机-铁通一级节点
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 135, 142, 470,308,40,4, 'arrow-green_h_xh.gif', sysdate, null, sysdate, null);
--铁通汇接交换机-铁通二级节点
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 142, 131, 554,308,30,4, 'arrow-green_h_xh.gif', sysdate, null, sysdate, null);
--铁通汇接交换机-电信侧封堵路由
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 142, NULL, 530,338,4,14, 'arrow-green_v.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 142, NULL, 190,348,340,4, 'arrow-green_h_f.gif', sysdate, null, sysdate, null);
--联通教育汇接交换机-核心交换机
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 143, 139, 702,334,4,70, 'arrow-green_v_xh.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 143, 139, 544,400,4,22, 'arrow-green_v_xh.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 143, 139, 544,400,162,4, 'arrow-green_h_xh_f.gif', sysdate, null, sysdate, null);
--联通教育汇接交换机-联通一级节点
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 136, 143, 468,428,40,4, 'arrow-green_h_xh.gif', sysdate, null, sysdate, null);
--联通教育汇接交换机-联通教育二级节点
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 143, 132, 556,428,30,4, 'arrow-green_h_xh.gif', sysdate, null, sysdate, null);
--联通教育汇接交换机-教育一级节点
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 137, 143, 468,552,56,4, 'arrow-green_h_xh_f.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 137, 143, 520,454,4,102, 'arrow-green_v_xh.gif', sysdate, null, sysdate, null);
--联通教育汇接交换机-联通侧封堵路由
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 143, NULL, 520,400,4,22, 'arrow-green_v_f.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 143, NULL, 248,400,276,4, 'arrow-green_h_f.gif', sysdate, null, sysdate, null);
--联通教育汇接交换机-教育侧封堵路由
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 143, NULL, 544,454,4,144, 'arrow-green_v.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 143, NULL, 190,594,358,4, 'arrow-green_h_f.gif', sysdate, null, sysdate, null);
--科技汇接交换机-核心交换机
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 144, 139, 710,338,4,330, 'arrow-green_v_xh.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 144, 139, 560,668,154,4, 'arrow-green_h_xh_f.gif', sysdate, null, sysdate, null);
--科技汇接交换机-科技一级节点
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 138, 144, 472,668,40,4, 'arrow-green_h_xh.gif', sysdate, null, sysdate, null);
--科技汇接交换机-科技侧封堵路由
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 144, NULL, 535,688,4,22, 'arrow-green_v.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 144, NULL, 190,706,349,4, 'arrow-green_h_f.gif', sysdate, null, sysdate, null);
-----------------------------交换机2.1-3------------------
--电信分流交换机-电信一级
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 145, 133, 400,58,30,4, 'arrow-green_h.gif', sysdate, null, sysdate, null);
--电信分流交换机-电信分流D
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 145, 148, 322,58,30,4, 'arrow-green_h.gif', sysdate, null, sysdate, null);
--移动铁通分流交换机-移动一级
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 146, 134, 382,178,4,48, 'arrow-green_v_f.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 146, 134, 382,178,48,4, 'arrow-green_h.gif', sysdate, null, sysdate, null);
--移动铁通分流交换机-铁通一级
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 146, 135, 382,308,48,4, 'arrow-green_h.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 146, 135, 382,270,4,42, 'arrow-green_v.gif', sysdate, null, sysdate, null);
--移动铁通分流交换机-移动铁通分流D
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 146, 149, 328,244,30,4, 'arrow-green_h.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 146, 149, 328,250,30,4, 'arrow-green_h.gif', sysdate, null, sysdate, null);
--联通教育分流交换机-联通一级
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 147, 136, 382,428,46,4, 'arrow-green_h.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 147, 136, 382,428,4,48, 'arrow-green_v_f.gif', sysdate, null, sysdate, null);
--联通教育分流交换机-教育一级
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 147, 137, 382,552,46,4, 'arrow-green_h.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 147, 137, 382,519,4,38, 'arrow-green_v.gif', sysdate, null, sysdate, null);
--联通教育分流交换机-联通教育分流D
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 147, 150, 330,494,30,4, 'arrow-green_h.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 147, 150, 330,500,30,4, 'arrow-green_h.gif', sysdate, null, sysdate, null);
--科技一级-科技分流D
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, 138, 151, 324,668,106,4, 'arrow-green_h.gif', sysdate, null, sysdate, null);
------------------------------------------分流设备D 1.1-4
--波分设备（运营商侧）-电信分流D
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, NULL, 148, 252,58,40,4, 'arrow-green_h.gif', sysdate, null, sysdate, null);
--波分设备（运营商侧）-移动铁通分流D
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, NULL, 149, 242,204,4,40, 'arrow-green_v.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, NULL, 149, 242,244,58,4, 'arrow-green_h.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, NULL, 149, 242,250,58,4, 'arrow-green_h.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, NULL, 149, 242,250,4,44, 'arrow-green_v_f.gif', sysdate, null, sysdate, null);
--波分设备（运营商侧）-联通教育分流D
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, NULL, 150, 246,494,56,4, 'arrow-green_h.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, NULL, 150, 246,454,4,40, 'arrow-green_v.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, NULL, 150, 246,500,56,4, 'arrow-green_h.gif', sysdate, null, sysdate, null);
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, NULL, 150, 246,500,4,40, 'arrow-green_v_f.gif', sysdate, null, sysdate, null);
--出口-科技分流D
insert into NODEGROUP_ARROW_POSITION (ID,SYSTEM_ID, SRC_GROUP_ID, DESC_GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_arrow_position.Nextval,61, NULL, 151, 114,668,180,4, 'arrow-green_h.gif', sysdate, null, sysdate, null);
--拓扑图背景图片位置表
-- Create table
create table NODEGROUP_BGIMG_POSITION
(
ID NUMBER not null,
SYSTEM_ID NUMBER not null,
GROUP_ID NUMBER not null,
FIGURE_X NUMBER not null,
FIGURE_Y NUMBER not null,
FIGURE_WIDTH NUMBER not null,
FIGURE_HEIGHT NUMBER not null,
FIGURE_FILL VARCHAR2(100) not null,
CREATE_TIME DATE,
CREATE_USERID NUMBER,
LAST_UPDATE_TIME DATE,
LAST_UPDATE_USERID NUMBER
);
-- Add comments to the table
comment on table NODEGROUP_BGIMG_POSITION
is '逻辑拓扑图节点组背景图片位置表';
-- Add comments to the columns
comment on column NODEGROUP_BGIMG_POSITION.ID
is '主键ID';
comment on column NODEGROUP_BGIMG_POSITION.SYSTEM_ID
is '业务系统ID';
comment on column NODEGROUP_BGIMG_POSITION.GROUP_ID
is '节点组ID';
comment on column NODEGROUP_BGIMG_POSITION.FIGURE_X
is '图片X坐标';
comment on column NODEGROUP_BGIMG_POSITION.FIGURE_Y
is '图片Y坐标';
comment on column NODEGROUP_BGIMG_POSITION.FIGURE_WIDTH
is '图片宽度';
comment on column NODEGROUP_BGIMG_POSITION.FIGURE_HEIGHT
is '图片高度';
comment on column NODEGROUP_BGIMG_POSITION.FIGURE_FILL
is '图片名称';
comment on column NODEGROUP_BGIMG_POSITION.CREATE_TIME
is '创建时间';
comment on column NODEGROUP_BGIMG_POSITION.CREATE_USERID
is '创建人';
comment on column NODEGROUP_BGIMG_POSITION.LAST_UPDATE_TIME
is '最后更改时间';
comment on column NODEGROUP_BGIMG_POSITION.LAST_UPDATE_USERID
is '最后更改人';
-- Create sequence
create sequence SEQ_nodegroup_BGIMG_POSITION
minvalue 1
maxvalue 999999999999
start with 1
increment by 1
cache 20
cycle
order;
--NODEGROUP_BGIMG_POSITION背景图片位置基础数据
--------------服务器 1.1-8
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 121,834,30,45,62, 'server.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 122, 833,148,45,62, 'server.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 123, 833,284,45,62, 'server.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 124, 834,400,45,62, 'server.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 125, 915,476,45,62, 'server.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 126, 834,522,45,62, 'server.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 127, 915,596,45,62, 'server.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 128, 834,648,45,62, 'server.png', sysdate, null, sysdate, null);
--------------服务器 2.1-4
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 129, 578,24,45,62, 'server.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 130, 580,152,45,62, 'server.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 131, 580,283,45,62, 'server.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 132, 580,404,45,62, 'server.png', sysdate, null, sysdate, null);
--------------服务器 3.1-6
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 133, 427,23,45,62, 'server.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 134, 426,152,45,62, 'server.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 135, 425,283,45,62, 'server.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 136, 425,405,45,62, 'server.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 137, 424,530,45,62, 'server.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 138, 425,637,45,62, 'server.png', sysdate, null, sysdate, null);
--------------核心交换机
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 139, 696,282,70,68, 'core_switch.png', sysdate, null, sysdate, null);
--------------交换机 1.1-5
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 140, 502,34,50,48, 'switch.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 141, 507,161,50,48, 'switch.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 142, 507,293,50,48, 'switch.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 143, 509,415,50,48, 'switch.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 144, 512,643,50,48, 'switch.png', sysdate, null, sysdate, null);
--------------交换机 2.1-3
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 145, 353,35,50,48, 'switch.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 146, 358,225,50,48, 'switch.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 147, 358,475,50,48, 'switch.png', sysdate, null, sysdate, null);
--------------分流设备 1.1-4
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 148, 293,47,29,27, 'device.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 149, 299,237,29,27, 'device.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 150, 301,487,29,27, 'device.png', sysdate, null, sysdate, null);
insert into NODEGROUP_BGIMG_POSITION (ID, SYSTEM_ID, GROUP_ID, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_FILL, CREATE_TIME, CREATE_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID)
values (SEQ_nodegroup_BGIMG_POSITION.Nextval, 61, 151, 296,655,29,27, 'device.png', sysdate, null, sysdate, null);
Reference in New Issue Copy Permalink