Головна сторінка Огляд Довідка
Реєстрація Увійти
projects
/
gdymtsceshi
5
0
Відгалуження 0
Файли Проблеми 0 Запити на злиття 0 Wiki
Дерево: 9ab0f1b8d3
Гілки Теги
gdymtsceshi
/
WebContent
/
WEB-INF
/
complaint
/
doc
/
知识库管理
/
菜单表添加sql.txt

菜单表添加sql.txt 6.7 KB
Історія Запис

12345678910111213141516171819202122232425 
  1. 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');
    2. 

  2. 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');
    3. 

  3. 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');
    4. 

  4. 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');
    5. 

  5. 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');
    6. 

  6. 

  7. 

  8. 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);
    9. 

  9. --添加菜单后设置用户的站点和栏目权限即可
    10. 

  10. 

  11. 

  12. --下面可以不要，
    13. 

  13. 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');
    14. 

  14. 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');
    15. 

  15. 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');
    16. 

  16. 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');
    17. 

  17. 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');
    18. 

  18. 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');
    19. 

  19. 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');
    20. 

  20. 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');
    21. 

  21. 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');
    22. 

  22. 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');
    23. 

  23. 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');
    24. 

  24. 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');
    25. 

  25. 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');
    26.