1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
|
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);
|
