⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 jeecms-init-0.7.0-beta.sql

📁 JSP(Java Server Pages)是由Sun Microsystems公司倡导、许多公司参与一起建立的一种动态网页技术标准。 JSP技术是用JAVA语言作为脚本语言的
💻 SQL
📖 第 1 页 / 共 2 页
字号:
🔍
12 
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);
12

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -