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
|
----注意：内外网更新执行不同的sql，请自行选择
----------------------内网部署更新执行 begin------------------
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, 172, 0, 2, NULL, 'image', 166,85, 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, 173, 0, 2, NULL, 'image', 166,142, 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, 174, 0, 2, NULL, 'image', 166,336, 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, 175, 0, 2, NULL, 'image', 166,390, 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, 176, 0, 2, NULL, 'image', 166,582, 25, 25, 'red', 1, 'green_bulb.png', 0, 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, 172, NULL, 138,95,25,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,1, 173, NULL, 138,154,25,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,1, 174, NULL, 138,346,25,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,1, 175, NULL, 138,400,25,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,1, 176, NULL, 138,592,25,4, 'arrow-green_h_f.gif', 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, 172, 163,85,25,24, 'router.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, 173, 163,142,25,24, 'router.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, 174, 163,336,25,24, 'router.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, 175, 163,390,25,24, 'router.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, 176, 163,582,25,24, 'router.png', sysdate, null, sysdate, null);
----------------------内网部署更新执行 end------------------
------------------------------外网部署更新执行 begin------------------
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, 152, 0, 2, NULL, 'image', 166,85, 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, 153, 0, 2, NULL, 'image', 166,142, 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, 154, 0, 2, NULL, 'image', 166,336, 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, 155, 0, 2, NULL, 'image', 166,390, 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, 156, 0, 2, NULL, 'image', 166,582, 25, 25, 'red', 1, 'green_bulb.png', 0, 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, 152, NULL, 138,95,25,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,1, 153, NULL, 138,154,25,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,1, 154, NULL, 138,346,25,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,1, 155, NULL, 138,400,25,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,1, 156, NULL, 138,592,25,4, 'arrow-green_h_f.gif', 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, 163,85,25,24, 'router.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, 163,142,25,24, 'router.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, 163,336,25,24, 'router.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, 163,390,25,24, 'router.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, 163,582,25,24, 'router.png', sysdate, null, sysdate, null);
------------------------------外网部署更新执行 end------------------
|
