200 lines
20 KiB
MySQL
200 lines
20 KiB
MySQL
insert into NODEGROUP_TABLE (GROUP_ID, GROUP_NAME, VIEW_LEVEL, CREATE_USER_ID, CREATE_USERGROUP_ID, GROUP_TYPE, GROUP_DESC, SYSTEM_ID, IS_VALID, GROUP_CREATETIME, PARENT_GROUP_ID, LEAF_GROUP, GROUP_LEVEL, SHOW_INDEX)
|
||
values (168, '电信分流D分流K设备一级分流设备', 3, 41, null, 0, null, 1, 1, Sysdate, 0, 1, 1, 111);
|
||
insert into NODEGROUP_TABLE (GROUP_ID, GROUP_NAME, VIEW_LEVEL, CREATE_USER_ID, CREATE_USERGROUP_ID, GROUP_TYPE, GROUP_DESC, SYSTEM_ID, IS_VALID, GROUP_CREATETIME, PARENT_GROUP_ID, LEAF_GROUP, GROUP_LEVEL, SHOW_INDEX)
|
||
values (169, '移动铁通共用分流D分流K设备一级分流设备', 3, 41, null, 0, null, 1, 1, Sysdate, 0, 1, 1, 111);
|
||
insert into NODEGROUP_TABLE (GROUP_ID, GROUP_NAME, VIEW_LEVEL, CREATE_USER_ID, CREATE_USERGROUP_ID, GROUP_TYPE, GROUP_DESC, SYSTEM_ID, IS_VALID, GROUP_CREATETIME, PARENT_GROUP_ID, LEAF_GROUP, GROUP_LEVEL, SHOW_INDEX)
|
||
values (170, '联通教育共用分流D分流K设备一级分流设备', 3, 41, null, 0, null, 1, 1, Sysdate, 0, 1, 1, 111);
|
||
insert into NODEGROUP_TABLE (GROUP_ID, GROUP_NAME, VIEW_LEVEL, CREATE_USER_ID, CREATE_USERGROUP_ID, GROUP_TYPE, GROUP_DESC, SYSTEM_ID, IS_VALID, GROUP_CREATETIME, PARENT_GROUP_ID, LEAF_GROUP, GROUP_LEVEL, SHOW_INDEX)
|
||
values (171, '科技分流D科技侧', 3, 41, null, 0, null, 1, 1, Sysdate, 0, 1, 1, 111);
|
||
|
||
|
||
--分流设备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, 1, 168, 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, 1, 169, 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, 1, 170, 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, 1, 171, 0, 2, NULL, 'image', 304,653, 25, 25, 'red', 1, 'green_bulb.png', 0, sysdate, NULL, sysdate,NULL );
|
||
|
||
|
||
---------------update
|
||
--电信分流交换机-电信分流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,1, 160, 168, 322,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,1, 163, 169, 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,1, 163, 169, 328,250,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,1, 166, 170, 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,1, 166, 170, 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,1, 150, 171, 324,668,106,4, 'arrow-green_h.gif', sysdate, null, sysdate, null);
|
||
|
||
------------------------------------------insert 分流设备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,1, NULL, 168, 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,1, NULL, 169, 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,1, NULL, 169, 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,1, NULL, 169, 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,1, NULL, 169, 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,1, NULL, 170, 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,1, NULL, 170, 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,1, NULL, 170, 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,1, NULL, 170, 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,1, NULL, 171, 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;
|
||
|
||
--------------服务器 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, 1, 151,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, 1, 152, 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, 1, 153, 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, 1, 154, 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, 1, 155, 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, 1, 156, 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, 1, 157, 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, 1, 158, 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, 1, 142, 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, 1, 144, 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, 1, 145, 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, 1, 149, 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, 1, 141, 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, 1, 143, 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, 1, 145, 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, 1, 147, 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, 1, 148, 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, 1, 150, 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, 1, 159, 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, 1, 161, 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, 1, 162, 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, 1, 164, 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, 1, 165, 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, 1, 167, 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, 1, 160, 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, 1, 163, 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, 1, 166, 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, 1, 168, 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, 1, 169, 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, 1, 170, 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, 1, 171, 296,655,29,27, 'device.png', sysdate, null, sysdate, null);
|
||
|
||
|