76 lines
11 KiB
MySQL
76 lines
11 KiB
MySQL
|
||
----注意：内外网更新执行不同的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------------------
|