?? jeecms-init-0.7.0-beta.sql
字號:
INSERT INTO `cms_function` VALUES (1,NULL,'功能菜單','','/admin/sys/admin@/admin/sys/FunctionTree@/admin/sys/right@/admin/sys/user_united/Com_editPassword@/admin/sys/ajax/updatePassword','',1000,1);
INSERT INTO `cms_function` VALUES (2,1,'文章系統','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (4,2,'模板管理','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (5,4,'頁面模板','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (6,5,'頁面模板添加','/admin/arti/tpl_page/Com_add',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (7,5,'頁面模板列表','/admin/arti/tpl_page/Com_list',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (8,5,'頁面模板刪除','/admin/arti/tpl_page/Com_delete',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (9,4,'片段模板','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (10,9,'片段模板添加','/admin/arti/tpl_part/Com_add',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (11,9,'片段模板列表','/admin/arti/tpl_part/Com_list',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (12,4,'包含模板','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (13,12,'包含模板添加','/admin/arti/tpl_incl/Com_add',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (14,12,'包含模板列表','/admin/arti/tpl_incl/Com_list',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (15,2,'欄目管理','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (16,2,'文章管理','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (17,15,'欄目','','','',1500,1);
INSERT INTO `cms_function` VALUES (18,15,'文章類別','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (19,15,'專題','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (20,17,'欄目添加','/admin/arti/chnl/Com_add',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (21,17,'欄目列表','/admin/arti/chnl/Com_list',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (22,18,'文章類別添加','/admin/arti/chnl_category/Com_add',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (23,18,'文章類別列表','/admin/arti/chnl_category/Com_list',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (24,19,'專題添加','/admin/arti/special_topic/Com_add',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (25,19,'專題列表','/admin/arti/special_topic/Com_list',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (26,16,'文章添加','/admin/arti/arti/Com_add',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (27,16,'文章列表','/admin/arti/arti/Com_list',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (48,1,'網站配置','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (49,48,'共用腳本和樣式','/admin/cms/common_js_css/JsCss',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (50,48,'通用模板管理','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (51,50,'頁面模板','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (52,50,'片段模板','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (53,50,'包含模板','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (54,51,'頁面模板添加','/admin/cms/tpl_page/Com_add',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (55,51,'頁面模板列表','/admin/cms/tpl_page/Com_list',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (56,52,'片段模板添加','/admin/cms/tpl_part/Com_add',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (57,52,'片段模板列表','/admin/cms/tpl_part/Com_list',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (58,53,'包含模板添加','/admin/cms/tpl_incl/Com_add',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (59,53,'包含模板列表','/admin/cms/tpl_incl/Com_list',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (60,1,'資源管理','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (61,60,'資源添加','/admin/cms/res/Com_add','','',1000,0);
INSERT INTO `cms_function` VALUES (62,60,'資源列表','/admin/cms/res/Com_list','/admin/cms/res/ajax/creatfile@/admin/cms/res/ajax/deletefile@/admin/cms/res/ajax/renamefile','',1000,1);
INSERT INTO `cms_function` VALUES (81,1,'系統管理','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (83,81,'統一用戶管理','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (84,81,'管理員管理','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (85,81,'用戶管理','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (86,81,'功能菜單管理','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (87,81,'角色管理','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (90,83,'統一用戶添加','/admin/sys/user_united/Com_add',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (91,83,'統一用戶列表','/admin/sys/user_united/Com_list',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (92,84,'管理員添加','/admin/sys/user_admin/Com_add',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (93,84,'管理員列表','/admin/sys/user_admin/Com_list',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (94,85,'用戶添加','/admin/sys/user_guest/Com_add',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (95,85,'用戶列表','/admin/sys/user_guest/Com_list',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (96,86,'功能菜單添加','/admin/sys/func/Com_add',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (97,86,'功能菜單列表','/admin/sys/func/Com_list',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (98,87,'角色添加','/admin/sys/role/Com_add',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (99,87,'角色列表','/admin/sys/role/Com_list',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (100,5,'頁面模板修改','/admin/arti/tpl_page/Com_edit',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (101,5,'頁面模板歷史記錄','/admin/arti/tpl_page/Com_history',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (102,9,'片段模板修改','/admin/arti/tpl_part/Com_edit',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (103,9,'片段模板歷史記錄','/admin/arti/tpl_part/Com_history',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (104,9,'片段模板刪除','/admin/arti/tpl_part/Com_delete',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (105,12,'包含模板修改','/admin/arti/tpl_incl/Com_edit',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (106,12,'包含模板歷史記錄','/admin/arti/tpl_incl/Com_history',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (107,12,'包含模板刪除','/admin/arti/tpl_incl/Com_delete',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (108,17,'欄目修改','/admin/arti/chnl/Com_edit',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (109,17,'欄目刪除','/admin/arti/chnl/Com_delete',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (110,5,'頁面模板保存','/admin/arti/tpl_page/Com_save',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (111,5,'頁面模板更新','/admin/arti/tpl_page/Com_update',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (112,9,'片段模板保存','/admin/arti/tpl_part/Com_save',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (113,9,'片段模板更新','/admin/arti/tpl_part/Com_update',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (114,12,'包含模板保存','/admin/arti/tpl_incl/Com_save',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (115,12,'包含模板更新','/admin/arti/tpl_incl/Com_update',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (116,17,'欄目保存','/admin/arti/chnl/Com_save',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (117,18,'文章類別修改','/admin/arti/chnl_category/Com_edit',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (118,18,'文章類別刪除','/admin/arti/chnl_category/Com_delete',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (119,18,'文章類別保存','/admin/arti/chnl_category/Com_save',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (120,18,'文章類別更新','/admin/arti/chnl_category/Com_update',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (121,17,'欄目更新','/admin/arti/chnl/Com_update',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (122,19,'專題修改','/admin/arti/special_topic/Com_edit',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (123,19,'專題刪除','/admin/arti/special_topic/Com_delete',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (124,19,'專題保存','/admin/arti/special_topic/Com_save',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (125,19,'專題更新','/admin/arti/special_topic/Com_update',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (126,16,'文章修改','/admin/arti/arti/Com_edit',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (127,16,'文章刪除','/admin/arti/arti/Com_delete',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (128,16,'文章保存','/admin/arti/arti/Com_save',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (129,16,'文章更新','/admin/arti/arti/Com_update',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (157,51,'頁面模板修改','/admin/cms/tpl_page/Com_edit',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (158,51,'頁面模板刪除','/admin/cms/tpl_page/Com_delete',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (159,51,'頁面模板保存','/admin/cms/tpl_page/Com_save',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (160,51,'頁面模板更新','/admin/cms/tpl_page/Com_update',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (161,51,'頁面模板歷史記錄','/admin/cms/tpl_page/Com_history',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (162,52,'片段模板修改','/admin/cms/tpl_part/Com_edit',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (163,52,'片段模板刪除','/admin/cms/tpl_part/Com_delete',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (164,52,'片段模板保存','/admin/cms/tpl_part/Com_save',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (165,52,'片段模板更新','/admin/cms/tpl_part/Com_update',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (166,52,'片段模板歷史記錄','/admin/cms/tpl_part/Com_history',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (167,53,'包含模板修改','/admin/cms/tpl_incl/Com_edit',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (168,53,'包含模板刪除','/admin/cms/tpl_incl/Com_delete',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (169,53,'包含模板保存','/admin/cms/tpl_incl/Com_save',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (170,53,'包含模板更新','/admin/cms/tpl_incl/Com_update',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (171,53,'包含模板歷史記錄','/admin/cms/tpl_incl/Com_history',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (172,60,'資源修改','/admin/cms/res/Com_edit',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (173,60,'資源刪除','/admin/cms/res/Com_delete',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (174,60,'資源保存','/admin/cms/res/Com_upload',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (175,60,'資源更新','/admin/cms/res/Com_update',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (202,83,'統一用戶修改','/admin/sys/user_united/Com_edit',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (203,83,'統一用戶刪除','/admin/sys/user_united/Com_delete',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (204,83,'統一用戶保存','/admin/sys/user_united/Com_save',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (205,83,'統一用戶更新','/admin/sys/user_united/Com_update',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (206,84,'管理員修改','/admin/sys/user_admin/Com_edit',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (207,84,'管理員刪除','/admin/sys/user_admin/Com_delete',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (208,84,'管理員保存','/admin/sys/user_admin/Com_save',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (209,84,'管理員更新','/admin/sys/user_admin/Com_update',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (210,85,'用戶修改','/admin/sys/user_guest/Com_edit',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (211,85,'用戶刪除','/admin/sys/user_guest/Com_delete',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (212,85,'用戶保存','/admin/sys/user_guest/Com_save',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (213,85,'用戶更新','/admin/sys/user_guest/Com_update',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (214,86,'功能菜單修改','/admin/sys/func/Com_edit',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (215,86,'功能菜單刪除','/admin/sys/func/Com_delete',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (216,86,'功能菜單保存','/admin/sys/func/Com_save',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (217,86,'功能菜單更新','/admin/sys/func/Com_update',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (218,87,'角色修改','/admin/sys/role/Com_edit',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (219,87,'角色刪除','/admin/sys/role/Com_delete',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (220,87,'角色保存','/admin/sys/role/Com_save',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (221,87,'角色更新','/admin/sys/role/Com_update',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (234,1,'留言板管理','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (235,234,'模板','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (236,235,'模板添加','/admin/msg/tpl_inde/Com_add',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (237,235,'模板列表','/admin/msg/tpl_inde/Com_list',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (238,234,'留言類別','',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (239,238,'留言類別添加','/admin/msg/msg_board_ctg/Com_add',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (240,238,'留言類別列表','/admin/msg/msg_board_ctg/Com_list',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (241,235,'模板保存','/admin/msg/tpl_inde/Com_save',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (242,235,'模板刪除','/admin/msg/tpl_inde/Com_delete',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (243,235,'模板更新','/admin/msg/tpl_inde/Com_update',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (244,238,'留言類別保存','/admin/msg/msg_board_ctg/Com_save',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (245,238,'留言類別刪除','/admin/msg/msg_board_ctg/Com_delete',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (246,238,'留言類別更新','/admin/msg/msg_board_ctg/Com_update',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (247,235,'模板修改','/admin/msg/tpl_inde/Com_edit',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (248,238,'留言類別修改','/admin/msg/msg_board_ctg/Com_edit',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (249,234,'配置','/admin/msg/sys_value/Com_edit',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (250,234,'網友留言','/admin/msg/msg_board/Com_list',NULL,'',1000,1);
INSERT INTO `cms_function` VALUES (251,234,'配置更新','/admin/msg/sys_value/Com_update',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (252,234,'留言更新','/admin/msg/msg_board/Com_update',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (253,234,'留言刪除','/admin/msg/msg_board/Com_delete',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (254,234,'留言修改','/admin/msg/msg_board/Com_edit',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (256,16,'圖片上傳','/admin/arti/arti/Com_upload',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (258,5,'頁面模板歷史記錄查看','/admin/arti/tpl_page/Com_bakfile',NULL,'',1000,0);
INSERT INTO `cms_function` VALUES (335,48,'郵件配置','/admin/cms/server_email/Com_emailEdit','/admin/cms/server_email/Com_emailUpdate','',1000,1);
INSERT INTO `cms_function` VALUES (347,2,'內容推薦','','','',1000,1);
INSERT INTO `cms_function` VALUES (348,347,'推薦組添加','/admin/arti/rcm_group/Com_add','','',1000,1);
INSERT INTO `cms_function` VALUES (349,347,'推薦組列表','/admin/arti/rcm_group/Com_list','/admin/arti/rcm_group/Com_edit@/admin/arti/rcm_group/Com_update@/admin/arti/rcm_group/Com_save@/admin/arti/rcm_group/Com_delete','',1000,1);
INSERT INTO `cms_function` VALUES (350,347,'推薦項添加','/admin/arti/rcm_item/Com_add','','',1000,1);
INSERT INTO `cms_function` VALUES (351,347,'推薦項列表','/admin/arti/rcm_item/Com_list','/admin/arti/rcm_item/Com_edit@/admin/arti/rcm_item/Com_update@/admin/arti/rcm_item/Com_save@/admin/arti/rcm_item/Com_delete','',1000,1);
INSERT INTO `cms_website` (WEBSITE_ID, DOMAIN, RES_PATH, PORT, NAME, LIMIT_TIME, IS_CHECK, IS_DISABLED, CONTEXT_PATH, SUFFIX, RES_DOMAIN, DEFAULT_SYSTEM) VALUES (1,'localhost','nc138',8080,'JEECMS演示網站','2008-08-08',1,0,'/CmsSys','htm','http://localhost:8080/CmsSys','arti');
INSERT INTO `cms_user_united` (UNITED_USER_ID, LOGIN_NAME,PASSWORD, IS_DISABLED) VALUES (1,'admin','54f0087a24066298b3f912ae29770134','0');
INSERT INTO `cms_user_united` (UNITED_USER_ID, LOGIN_NAME,PASSWORD, IS_DISABLED) VALUES (2,'guest','54f0087a24066298b3f912ae29770134','0');
INSERT INTO `cms_user_guest` (GUEST_ID, UNITED_USER_ID, WEBSITE_ID, IS_SEPARATE, IS_DISABLED) VALUES (1,2,1,0,0);
INSERT INTO `cms_user_admin` (ADMIN_ID, WEBSITE_ID, UNITED_USER_ID, IS_DISABLED) VALUES (1,1,1,0);
INSERT INTO `cms_role` VALUES (1,'超級管理員','擁有系統最高權限');
INSERT INTO `cms_role_function` VALUES (1,1);
INSERT INTO `cms_role_function` VALUES (1,2);
INSERT INTO `cms_role_function` VALUES (1,4);
INSERT INTO `cms_role_function` VALUES (1,5);
INSERT INTO `cms_role_function` VALUES (1,6);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -