INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) VALUES ('20', '网站管理', '0', NULL, NULL, 'admin', '2016-07-28 18:13:18', '/0/20/', '1', NULL, NULL, 'false', 'true', 'web.manage.lis', 'menu', '2.00');
INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) VALUES ('202', '栏目管理', '20', NULL, NULL, NULL, NULL, '/0/20/202/', '2', '/myconsole/column', NULL, 'true', 'true', 'web.column.columnlist', 'menu', '2.00');
INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) VALUES ('20201', '添加', '202', NULL, NULL, NULL, NULL, '/0/20/202/20201/', '3', '/myconsole/column/saveOrUpdate', NULL, 'true', 'true', 'web.column.insert', 'function', '1.00');
INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) VALUES ('20202', '编辑', '202', NULL, NULL, NULL, NULL, '/0/20/202/20202/', '3', '/myconsole/column/saveOrUpdate', NULL, 'true', 'true', 'web.column.update', 'function', '2.00');
INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) VALUES ('20203', '删除', '202', NULL, NULL, NULL, NULL, '/0/20/202/20203/', '3', '/myconsole/column/saveOrUpdate', NULL, 'true', 'true', 'web.column.delete', 'function', '3.00');


INSERT INTO "T_SITE" VALUES ('1', 'gszz', '公司主站', '0', NULL, '0', NULL, NULL, NULL, 1, '启用', NULL, NULL, NULL, NULL, 'false', NULL, NULL, '管理员', '2017-01-10 07:25:34', 1, '/0/gszz/', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
--添加菜单后设置用户的站点和栏目权限即可


--下面可以不要，
INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) VALUES ('10', '我的工作台', '0', NULL, NULL, 'admin', '2016-11-01 11:00:56', '/0/10/', '1', NULL, NULL, 'false', 'true', 'work.mywork.list', 'menu', '1.00');
INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) VALUES ('101', '信息发布', '10', NULL, NULL, 'admin', '2016-07-22 16:17:05', '/0/10/101/', '2', '/myconsole/webinfo', NULL, 'false', 'true', 'work.web.weblist', 'menu', '1.00');
INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) VALUES ('10101', '新建', '101', NULL, NULL, 'admin', '2016-07-22 16:17:05', '/0/10/101/10101/', '3', '/myconsole/webinfo/saveOrUpdate', NULL, 'true', 'true', 'work.web.insert', 'function', '1.00');
INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) VALUES ('10102', '编辑', '101', NULL, NULL, 'admin', '2016-07-22 16:17:05', '/0/10/101/10102/', '3', '/myconsole/webinfo/saveOrUpdate', NULL, 'true', 'true', 'work.web.update', 'function', '2.00');
INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) VALUES ('10103', '发布', '101', NULL, NULL, 'admin', '2016-07-22 16:17:05', '/0/10/101/10103/', '3', '/myconsole/webinfo/release', NULL, 'true', 'true', 'work.web.release', 'function', '3.00');
INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) VALUES ('10104', '定时发布', '101', NULL, NULL, 'admin', '2016-07-22 16:17:05', '/0/10/101/10104/', '3', '/myconsole/webinfo/timeRelease', NULL, 'true', 'true', 'work.web.timerelease', 'function', '4.00');
INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) VALUES ('10105', '撤稿', '101', NULL, NULL, 'admin', '2016-07-22 16:17:05', '/0/10/101/10105/', '3', '/myconsole/webinfo/setWithdraw', NULL, 'true', 'true', 'work.web.withdraw', 'function', '5.00');
INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) VALUES ('10106', '置顶', '101', NULL, NULL, 'admin', '2016-07-22 16:17:05', '/0/10/101/10106/', '3', '/myconsole/webinfo/setTop', NULL, 'true', 'true', 'work.web.settop', 'function', '6.00');
INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) VALUES ('10107', '取消置顶', '101', NULL, NULL, 'admin', '2016-07-22 16:17:05', '/0/10/101/10107/', '3', '/myconsole/webinfo/cancelTop', NULL, 'true', 'true', 'work.web.canceltop', 'function', '7.00');
INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) VALUES ('10108', '复制', '101', NULL, NULL, 'admin', '2016-07-22 16:17:05', '/0/10/101/10108/', '3', '/myconsole/webinfo/batchCopy', NULL, 'true', 'true', 'work.web.batchcopy', 'function', '8.00');
INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) VALUES ('10109', '移动', '101', NULL, NULL, 'admin', '2016-07-22 16:17:05', '/0/10/101/10109/', '3', '/myconsole/webinfo/batchMove', NULL, 'true', 'true', 'work.web.batchmove', 'function', '9.00');
INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) VALUES ('10110', '引用', '101', NULL, NULL, 'admin', '2016-07-22 16:17:05', '/0/10/101/10110/', '3', '/myconsole/webinfo/batchQuote', NULL, 'true', 'true', 'work.web.batchquote', 'function', '10.00');
INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) VALUES ('10111', '删除', '101', NULL, NULL, 'admin', '2016-07-22 16:17:05', '/0/10/101/10111/', '3', '/myconsole/webinfo/saveOrUpdate', NULL, 'true', 'true', 'work.web.delete', 'function', '11.00');