jeecms-init-2.0.0-beta.sql

JEECSM是JavaEE版网站管理系统（Java Enterprise Edition Content Manage System）的简称

INSERT INTO `core_function` VALUES (1,NULL,'功能菜单','','','',100,1);
INSERT INTO `core_function` VALUES (81,1,'核心功能','/admin/cms/frame/core_main','/admin/cms/frame/core_left@/admin/cms/frame/core_right','',30,1);
INSERT INTO `core_function` VALUES (83,81,'用户管理','/admin/core/user/Com_list','/admin/core/user/Com_add@/admin/core/user/Com_edit@/admin/core/user/Com_update@/admin/core/user/Com_save@/admin/core/user/Com_delete','',20,1);
INSERT INTO `core_function` VALUES (87,81,'角色管理','/admin/core/role/Com_list','/admin/core/role/Com_add@/admin/core/role/Com_edit@/admin/core/role/Com_save@/admin/core/role/Com_update@/admin/core/role/Com_delete','',30,1);
INSERT INTO `core_function` VALUES (353,1,'辅助系统','/admin/cms/frame/auxiliary_main','/admin/cms/frame/auxiliary_left@/admin/cms/frame/auxiliary_right','',20,1);
INSERT INTO `core_function` VALUES (369,1,'模板管理','/admin/core/template/Com_main','/admin/core/template/Com_left@/admin/core/template/Com_right@/admin/core/template/Com_list@/admin/core/template/Com_Add@/admin/core/template/Com_edit@/admin/core/template/Com_save@/admin/core/template/Com_update@/admin/core/template/Com_delete@/admin/core/template/Com_createDir@/admin/core/template/ajax/update@/admin/core/template/ajax/rename','',40,1);
INSERT INTO `core_function` VALUES (370,81,'功能菜单','/admin/core/function/Com_main','/admin/core/function/Com_list@/admin/core/function/Com_left@/admin/core/function/Com_add@/admin/core/function/Com_edit@/admin/core/function/Com_save@/admin/core/function/Com_update@/admin/core/function/Com_delete@/admin/core/function/Com_priorityUpdate','',10,1);
INSERT INTO `core_function` VALUES (372,81,'站点设置','/admin/core/config/Com_siteEdit','/admin/core/config/Com_siteUpdate','',50,1);
INSERT INTO `core_function` VALUES (373,81,'邮件设置','/admin/core/config/Com_emailEdit','/admin/core/config/Com_emailUpdate','',60,1);
INSERT INTO `core_function` VALUES (374,1,'资源管理','/admin/core/resource/Com_resMain','/admin/core/resource/Com_resLeft@/admin/core/resource/Com_resRight@/admin/core/resource/Com_resList@/admin/core/resource/Com_resAdd@/admin/core/resource/Com_resEdit@/admin/core/resource/Com_resSave@/admin/core/resource/Com_resUpdate@/admin/core/resource/Com_resDeleteres@/admin/core/resource/Com_resCreateDir@/admin/core/resource/ajax/resUpdate@/admin/core/resource/ajax/resRename','',50,1);
INSERT INTO `core_function` VALUES (375,353,'留言类别','/admin/auxiliary/msg_ctg/Com_list','/admin/auxiliary/msg_ctg/Com_add@/admin/auxiliary/msg_ctg/Com_edit@/admin/auxiliary/msg_ctg/Com_save@/admin/auxiliary/msg_ctg/Com_update@/admin/auxiliary/msg_ctg/Com_delete','',100,1);
INSERT INTO `core_function` VALUES (376,353,'留言内容','/admin/auxiliary/msg/Com_list','/admin/auxiliary/msg/Com_add@/admin/auxiliary/msg/Com_edit@/admin/auxiliary/msg/Com_save@/admin/auxiliary/msg/Com_update@/admin/auxiliary/msg/Com_delete','',100,1);
INSERT INTO `core_function` VALUES (377,353,'辅助系统设置','/admin/auxiliary/config/Com_configEdit','','',100,1);
INSERT INTO `core_function` VALUES (378,1,'JEECMS','/admin/cms/Com_index','/admin/cms/Com_main@/admin/cms/Com_left@/admin/cms/Com_right','包括jeecms会员、管理员、配置等功能。',10,1);
INSERT INTO `core_function` VALUES (379,378,'管理员管理','/admin/cms/admin/Com_list','/admin/cms/admin/Com_add@/admin/cms/admin/Com_edit@/admin/cms/admin/Com_save@/admin/cms/admin/Com_update@/admin/cms/admin/Com_delete','',50,1);
INSERT INTO `core_function` VALUES (382,378,'文章栏目','/admin/article/channel/Com_main','/admin/article/channel/Com_left@/admin/article/channel/Com_right@/admin/article/channel/Com_list@/admin/article/channel/Com_add@/admin/article/channel/Com_edit@/admin/article/channel/Com_save@/admin/article/channel/Com_update@/admin/article/channel/Com_delete@/admin/article/channel/Com_priorityUpdate','',20,1);
INSERT INTO `core_function` VALUES (383,378,'文章内容','/admin/article/article/Com_main','/admin/article/article/Com_left@/admin/article/article/Com_right@/admin/article/article/Com_list@/admin/article/article/Com_add@/admin/article/article/Com_edit@/admin/article/article/Com_save@/admin/article/article/Com_update@/admin/article/article/Com_delete','',30,1);
INSERT INTO `core_function` VALUES (384,378,'网站配置','/admin/cms/frame/config_main','/admin/cms/frame/config_left@/admin/cms/frame/config_right@/admin/cms/config/Com_configEdit@/admin/cms/config/Com_configUpdate','',40,1);
INSERT INTO `core_function` VALUES (385,378,'栏目模型','/admin/article/chnl_model/Com_list','/admin/article/chnl_model/Com_add@/admin/article/chnl_model/Com_edit@/admin/article/chnl_model/Com_save@/admin/article/chnl_model/Com_update@/admin/article/chnl_model/Com_delete@/admin/article/chnl_model/Com_priorityUpdate','',10,1);

INSERT INTO `core_role` VALUES (1,'超级管理员','拥有系统最高权限');

INSERT INTO `core_role_function` VALUES (1,1);
INSERT INTO `core_role_function` VALUES (1,81);
INSERT INTO `core_role_function` VALUES (1,83);
INSERT INTO `core_role_function` VALUES (1,87);
INSERT INTO `core_role_function` VALUES (1,353);
INSERT INTO `core_role_function` VALUES (1,369);
INSERT INTO `core_role_function` VALUES (1,370);
INSERT INTO `core_role_function` VALUES (1,372);
INSERT INTO `core_role_function` VALUES (1,373);
INSERT INTO `core_role_function` VALUES (1,374);
INSERT INTO `core_role_function` VALUES (1,375);
INSERT INTO `core_role_function` VALUES (1,376);
INSERT INTO `core_role_function` VALUES (1,377);
INSERT INTO `core_role_function` VALUES (1,378);
INSERT INTO `core_role_function` VALUES (1,379);
INSERT INTO `core_role_function` VALUES (1,382);
INSERT INTO `core_role_function` VALUES (1,383);
INSERT INTO `core_role_function` VALUES (1,384);
INSERT INTO `core_role_function` VALUES (1,385);

INSERT INTO core_website (website_id, domain, name, res_path, context_path, port, current_system) VALUES (1,'localhost','JEECMS演示网站','jeecms_com_www','/JeeCms',8080,'jeecms');
INSERT INTO core_user (user_id, login_name, password, create_time) VALUES (1,'admin','54f0087a24066298b3f912ae29770134','2008-08-08');
INSERT INTO core_admin (admin_id, website_id, user_id, create_time) VALUES (1,1,1,'2008-8-8');
INSERT INTO core_member (member_id, website_id, user_id, create_time) VALUES(1,1,1,'2008-8-8');
INSERT INTO cms_config (config_id) VALUES(1);
INSERT INTO auxi_config (config_id) VALUES(1);
INSERT INTO cms_admin (admin_id, website_id) VALUES (1,1);
INSERT INTO cms_member_group (group_id, website_id, name) VALUES(1,1,'普通会员');
INSERT INTO cms_member (member_id, website_id, group_id) VALUES (1,1,1);

INSERT INTO `core_admin_role` VALUES (1,1);

INSERT INTO cms_chnl_model (MODEL_ID,WEBSITE_ID,SYS_TYPE,NAME,TPL_PREFIX_CHANNEL,TPL_PREFIX_CONTENT,HAS_CHILD,SHORT_NAME,CONFIG_ID) VALUES (2,1,'article','文章模型','channel','content',1,'文章',1);
INSERT INTO cms_chnl_model (MODEL_ID,WEBSITE_ID,SYS_TYPE,NAME,TPL_PREFIX_CHANNEL,TPL_PREFIX_CONTENT,HAS_CHILD,SHORT_NAME,CONFIG_ID) VALUES (7,1,'article','单页模型','alone','',0,'单页',1);
INSERT INTO cms_chnl_model (MODEL_ID,WEBSITE_ID,SYS_TYPE,NAME,TPL_PREFIX_CHANNEL,TPL_PREFIX_CONTENT,HAS_CHILD,SHORT_NAME,CONFIG_ID) VALUES (8,1,'article','跳转模型','','',0,'跳转',1);