jeecms-init-2.1.0-beta.sql

Hippo CMS 6.05.05chengxi

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@/admin/core/template/Com_solutionEdit@/admin/core/template/Com_solutionUpdate@/admin/core/template/Com_import@@/admin/core/template/Com_importSubmit@/admin/core/template/Com_export@/admin/core/template/Com_exportSubmit','',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','','',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','',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_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/article/ctg/Com_list','/admin/article/ctg/Com_add@/admin/article/ctg/Com_edit@/admin/article/ctg/Com_save@/admin/article/ctg/Com_update@/admin/article/ctg/Com_delete','',25,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_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_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 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');
INSERT INTO CORE_TPL_SOLUTION VALUES(1,'shop','default');

INSERT INTO ARTI_CTG (WEBSITE_ID,LABEL,NAME,IMG_WIDTH,IMG_HEIGHT) VALUES(1,'1','普通',139,94);
INSERT INTO ARTI_CTG (WEBSITE_ID,LABEL,NAME,IMG_WIDTH,IMG_HEIGHT) VALUES(1,'2','图文',139,94);
INSERT INTO ARTI_CTG (WEBSITE_ID,LABEL,NAME,IMG_WIDTH,IMG_HEIGHT) VALUES(1,'3','焦点',296,200);
INSERT INTO ARTI_CTG (WEBSITE_ID,LABEL,NAME,IMG_WIDTH,IMG_HEIGHT) VALUES(1,'4','头条',100,68);
INSERT INTO ARTI_CTG (WEBSITE_ID,LABEL,NAME,IMG_WIDTH,IMG_HEIGHT) VALUES(1,'5','滚动',139,94);

INSERT INTO AUXI_MSG_CTG (MSGCTG_ID,WEBSITE_ID,NAME) 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);