74 lines
12 KiB
MySQL
74 lines
12 KiB
MySQL
|
--1.菜单修改
|
|||
|
|
UPDATE xt_mk_jbxx t SET t.mkurl='/nodePosition/nodeGroupPosition.do?action=showTopo' WHERE t.mkmc='业务拓扑图';
|
|||
|
|
UPDATE xt_mk_jbxx t SET t.mkurl='/nodePosition/topoShow.do?action=showTopo' WHERE t.mkmc='3D机房展示';
|
|||
|
|
|
|||
|
|
--2.新增子菜单 父菜单：配置管理 子菜单：端口状态配置 url：/detection/switchDetection.do?action=toConfigPort
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
--拓扑图预置数据
|
|||
|
|
|
|||
|
|
--底图
|
|||
|
|
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, 0, 0, 1, NULL, 'image', 0, 0, 1133, 755, 'red', 1, 'bgImg.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, 121, 0, 2, NULL, 'image', 858, 58, 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, 122, 0, 2, NULL, 'image', 858, 178, 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, 123, 0, 2, NULL, 'image', 858, 312, 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, 124, 0, 2, NULL, 'image', 859, 429, 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, 125, 0, 2, NULL, 'image', 944, 504, 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, 126, 0, 2, NULL, 'image', 859, 550, 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, 127, 0, 2, NULL, 'image', 946, 626, 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, 128, 0, 2, NULL, 'image', 859, 676, 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, 129, 0, 2, NULL, 'image', 602, 51, 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, 130, 0, 2, NULL, 'image', 606, 180, 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, 131, 0, 2, NULL, 'image', 605, 312, 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, 132, 0, 2, NULL, 'image', 605, 432, 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, 133, 0, 2, NULL, 'image', 452, 50, 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, 134, 0, 2, NULL, 'image', 450, 181, 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, 135, 0, 2, NULL, 'image', 450, 312, 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, 136, 0, 2, NULL, 'image', 450, 434, 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, 137, 0, 2, NULL, 'image', 450, 558, 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, 138, 0, 2, NULL, 'image', 450, 665, 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, 139, 0, 2, NULL, 'image', 732, 310, 25, 25, 'red', 1, 'red_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, 140, 0, 2, NULL, 'image', 523, 48, 25, 25, 'red', 1, 'red_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, 141, 0, 2, NULL, 'image', 528, 178, 25, 25, 'red', 1, 'red_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, 142, 0, 2, NULL, 'image', 528, 308, 25, 25, 'red', 1, 'red_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, 143, 0, 2, NULL, 'image', 530, 430, 25, 25, 'red', 1, 'red_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, 144, 0, 2, NULL, 'image', 532, 658, 25, 25, 'red', 1, 'red_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, 145, 0, 2, NULL, 'image', 375, 50, 25, 25, 'red', 1, 'red_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, 146, 0, 2, NULL, 'image', 378, 240, 25, 25, 'red', 1, 'red_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, 147, 0, 2, NULL, 'image', 378, 490, 25, 25, 'red', 1, 'red_bulb.png', 0, sysdate, NULL, sysdate,NULL );
|