-- --------------------------------------- 2020-04-04 zhangjr begin -----------------
CREATE TABLE `T_CORE_TOPOLOGY`  (
  `ID` bigint(20) NOT NULL COMMENT '主键',
  `CODE` varchar(64) NOT NULL COMMENT '编号（唯一值）',
  `USAGE` varchar(192) NOT NULL COMMENT '用途',
  `JSON` TEXT DEFAULT NULL COMMENT 'JSON格式的图表',
  `SVG` TEXT DEFAULT NULL COMMENT 'SVG格式的图表',
  `CREATEDBYID` varchar(32) DEFAULT NULL COMMENT '制单人编码',
  `CREATEDBYNAME` varchar(64) DEFAULT NULL COMMENT '制单人名称',
  `CREATEDTIME` datetime DEFAULT NULL COMMENT '制单时间',
  `CREATEDBYORGID` varchar(32) DEFAULT NULL COMMENT '制单人单位编码',
  `CREATEDBYORGNAME` varchar(256) DEFAULT NULL COMMENT '制单人单位名称',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT = '拓扑结构图' 
;

INSERT INTO T_CORE_MENU(ID, MENUNAME, HREF, PARENTID, ORDERNO, MENUINITNAME, ICON, TODOICON)
VALUES ('9331', '拓扑结构图', '/secure/core/module/topologies/page/edit-list', '93', 9331, '拓扑结构图', '036.svg', NULL);
COMMIT;
-- --------------------------------------- 2020-04-04 zhangjr end -----------------