jeecms-init-2.3.1-beta.sql

jeecms网站管理系统,jeecms网站管理系统,jeecms网站管理系统

SET UNIQUE_CHECKS=0;
SET FOREIGN_KEY_CHECKS=0;
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@/admin/core/user/checkLoginName@/admin/core/user/checkEmail','',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@/admin/core/template/Com_solutionEdit@/admin/core/template/Com_solutionUpdate@/admin/core/template/Com_importTpl@/admin/core/template/Com_importTplSubmit@/admin/core/template/Com_exportTpl@/admin/core/template/Com_exportTplSubmit','',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','/admin/auxiliary/config/Com_configUpdate','',90,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@/admin/article/channel/Com_checkPath','',10,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@/admin/article/article/Com_disable@/admin/article/article/Com_undisable','',20,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/cms/chnl_model/Com_list','/admin/cms/chnl_model/Com_add@/admin/cms/chnl_model/Com_edit@/admin/cms/chnl_model/Com_save@/admin/cms/chnl_model/Com_update@/admin/cms/chnl_model/Com_delete@/admin/cms/chnl_model/Com_copy@/admin/cms/chnl_model/Com_priorityUpdate@/admin/cms/chnl_model/Com_addItem@/admin/cms/chnl_model/Com_editItem@/admin/cms/chnl_model/Com_saveItem@/admin/cms/chnl_model/Com_updateItem','',80,1);
INSERT INTO CORE_FUNCTION VALUES (386,353,'投票管理','/admin/auxiliary/vote_topic/Com_list','/admin/auxiliary/vote_topic/Com_add@/admin/auxiliary/vote_topic/Com_save@/admin/auxiliary/vote_topic/Com_edit@/admin/auxiliary/vote_topic/Com_update@/admin/auxiliary/vote_topic/Com_delete','',100,1);
INSERT INTO CORE_FUNCTION VALUES (387,378,'内容属性','/admin/cms/content_ctg/Com_list','/admin/cms/content_ctg/Com_add@/admin/cms/content_ctg/Com_edit@/admin/cms/content_ctg/Com_save@/admin/cms/content_ctg/Com_update@/admin/cms/content_ctg/Com_delete','',90,1);
INSERT INTO CORE_FUNCTION VALUES (388,81,'图片处理','/admin/core/common/UploadImg','/admin/core/common/ImgAreaSelect@/admin/core/common/ImgCut','图片上传、图片剪裁',100,1);
INSERT INTO CORE_FUNCTION VALUES (389,81,'站点管理','/admin/core/website/Com_list','/admin/core/website/Com_list@/admin/core/website/Com_add@/admin/core/website/Com_edit@/admin/core/website/Com_save@/admin/core/website/Com_update@/admin/core/website/Com_delete','',5,1);
INSERT INTO CORE_FUNCTION VALUES (390,378,'会员组管理','/admin/cms/group/Com_list','/admin/cms/group/Com_add@/admin/cms/group/Com_edit@/admin/cms/group/Com_save@/admin/cms/group/Com_update@/admin/cms/group/Com_delete','',60,1);
INSERT INTO CORE_FUNCTION VALUES (391,378,'会员管理','/admin/cms/member/Com_list','/admin/cms/member/Com_add@/admin/cms/member/Com_edit@/admin/cms/member/Com_save@/admin/cms/member/Com_update@/admin/cms/member/Com_delete','',70,1);
INSERT INTO CORE_FUNCTION VALUES (392,378,'文档维护','/admin/cms/frame/document_main','/admin/cms/frame/document_left@/admin/cms/frame/document_right','',30,1);
INSERT INTO CORE_FUNCTION VALUES (393,392,'文章审核','/admin/article/article/Com_listUncheck','/admin/article/article/Com_checkView@/admin/article/article/Com_pass@/admin/article/article/Com_reject','',100,1);
INSERT INTO CORE_FUNCTION VALUES (395,81,'附件管理','/admin/core/attachment/Com_list','','',100,1);
INSERT INTO CORE_FUNCTION VALUES (396,392,'评论审核','/admin/cms/comment/Com_list','/admin/cms/comment/Com_list@/admin/cms/comment/Com_edit@/admin/cms/comment/Com_update@/admin/cms/comment/Com_delete@/admin/cms/comment/Com_check','',100,1);
INSERT INTO CORE_FUNCTION VALUES (397,392,'文章签收','/admin/article/article/Com_listSignin','/admin/article/article/Com_listSignin@/admin/article/article/Com_signinView@/admin/article/article/Com_signin@/admin/article/article/Com_reject','',100,1);
INSERT INTO CORE_FUNCTION VALUES (398,378,'缓存管理','/admin/cms/config/Cache_configEdit','/admin/cms/config/Cache_configUpdate@/admin/cms/config/ajax/clearHomepageCache@/admin/cms/config/ajax/clearChannelCache','',100,1);
INSERT INTO CORE_FUNCTION VALUES (399,378,'个人信息','/admin/cms/config/Self_edit','/admin/cms/config/Self_update@/admin/cms/config/Self_checkEmail','',110,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_ROLE_FUNCTION VALUES (1,386);
INSERT INTO CORE_ROLE_FUNCTION VALUES (1,387);
INSERT INTO CORE_ROLE_FUNCTION VALUES (1,388);
INSERT INTO CORE_ROLE_FUNCTION VALUES (1,389);
INSERT INTO CORE_ROLE_FUNCTION VALUES (1,390);
INSERT INTO CORE_ROLE_FUNCTION VALUES (1,391);
INSERT INTO CORE_ROLE_FUNCTION VALUES (1,392);
INSERT INTO CORE_ROLE_FUNCTION VALUES (1,393);
INSERT INTO CORE_ROLE_FUNCTION VALUES (1,395);
INSERT INTO CORE_ROLE_FUNCTION VALUES (1,396);
INSERT INTO CORE_ROLE_FUNCTION VALUES (1,397);
INSERT INTO CORE_ROLE_FUNCTION VALUES (1,398);
INSERT INTO CORE_ROLE_FUNCTION VALUES (1,399);

INSERT INTO CORE_GLOBAL VALUES(1,'/jeecms',8080);
INSERT INTO CORE_WEBSITE (WEBSITE_ID, GLOBAL_ID, DOMAIN, NAME, RES_PATH, CURRENT_SYSTEM, CREATE_TIME, COPYRIGHT) VALUES (1,1,'localhost','JEECMS演示网站','jeecms_com_www','jeecms',CURDATE(),'Copyright © 2007-2009 www.jeecms.com, All Rights Reserved');
INSERT INTO CORE_USER (USER_ID, LOGIN_NAME, PASSWORD, CREATE_TIME, EMAIL) VALUES (1,'admin','54f0087a24066298b3f912ae29770134',CURDATE(),'[e-mail]');
INSERT INTO CORE_ADMIN (ADMIN_ID, WEBSITE_ID, USER_ID, CREATE_TIME) VALUES (1,1,1,CURDATE());
INSERT INTO CORE_MEMBER (MEMBER_ID, WEBSITE_ID, USER_ID, CREATE_TIME) VALUES(1,1,1,CURDATE());
INSERT INTO CMS_CONFIG (CONFIG_ID,REGISTER_GROUP,REGISTER_RULE,DEF_ARTICLE_MODEL) VALUES(1,1,'请遵守我们的协议',2);
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,UPLOAD_STAT_DATE) VALUES (1,1,1,CURDATE());

INSERT INTO CORE_ADMIN_ROLE VALUES (1,1);

INSERT INTO CORE_TPL_SOLUTION VALUES(1,'article','default');
INSERT INTO CORE_TPL_SOLUTION VALUES(1,'auxiliary','default');
INSERT INTO CORE_TPL_SOLUTION VALUES(1,'cms_common','default');
INSERT INTO CORE_TPL_SOLUTION VALUES(1,'cms_member','default');
INSERT INTO CORE_TPL_SOLUTION VALUES(1,'picture','default');
INSERT INTO CORE_TPL_SOLUTION VALUES(1,'forum','default');
INSERT INTO CORE_TPL_SOLUTION VALUES(1,'download','default');