jeecms-init-2.3.1-beta.sql

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

INSERT INTO CORE_TPL_SOLUTION VALUES(1,'shop','default');

INSERT INTO CMS_CONTENT_CTG (WEBSITE_ID,LABEL,NAME,IMG_WIDTH,IMG_HEIGHT) VALUES(1,'1','普通',139,94);
INSERT INTO CMS_CONTENT_CTG (WEBSITE_ID,LABEL,NAME,IMG_WIDTH,IMG_HEIGHT) VALUES(1,'2','图文',139,94);
INSERT INTO CMS_CONTENT_CTG (WEBSITE_ID,LABEL,NAME,IMG_WIDTH,IMG_HEIGHT) VALUES(1,'3','焦点',296,200);
INSERT INTO CMS_CONTENT_CTG (WEBSITE_ID,LABEL,NAME,IMG_WIDTH,IMG_HEIGHT) VALUES(1,'4','头条',100,68);
INSERT INTO CMS_CONTENT_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 VOTE_TOPIC VALUES (1,1,'你是从哪儿得知本站的？','了解用户的来源',0,NULL,NULL,24,1,0,0,1,1,0);

INSERT INTO VOTE_ITEM VALUES (1,1,'朋友介绍',NULL,0,1);
INSERT INTO VOTE_ITEM VALUES (2,1,'门户网站的搜索引擎',NULL,0,2);
INSERT INTO VOTE_ITEM VALUES (3,1,'Google或百度搜索',NULL,0,3);
INSERT INTO VOTE_ITEM VALUES (4,1,'别的网站上的链接',NULL,0,4);
INSERT INTO VOTE_ITEM VALUES (5,1,'其它途径',NULL,0,5);

INSERT INTO CMS_CHNL_MODEL VALUES (1,1,'','首页模型','首页','index','content',1,1,1);
INSERT INTO CMS_CHNL_MODEL VALUES (2,1,'article','文章模型','文章','channel','content',2,1,1);
INSERT INTO CMS_CHNL_MODEL VALUES (3,1,'','单页模型','单页','alone','',3,1,0);
INSERT INTO CMS_CHNL_MODEL VALUES (4,1,'','跳转模型','跳转','','',4,1,0);

INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (1,2,1,'title','title','',1,1,60,NULL,NULL,NULL,'','',4,1,1);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (2,2,1,'priority','排列顺序','',1,1,12,NULL,NULL,NULL,'10','',10,1,1);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (3,2,1,'keywords','keywords','',1,1,60,NULL,NULL,NULL,'','',5,1,1);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (4,2,1,'description','description','',1,1,60,NULL,NULL,NULL,'','',6,1,1);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (15,2,1,'tplIndex','栏目页模板','',1,1,NULL,NULL,NULL,NULL,'','',2,1,1);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (16,2,1,'tplContent','内容页模板','',1,1,NULL,NULL,NULL,NULL,'','',3,1,1);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (18,2,1,'paramData','栏目数据','多个栏目共享同一模板时，可以通过栏目数据实现栏目页个性化',1,1,NULL,NULL,NULL,NULL,'','',15,1,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (43,2,1,'display','是否显示','',1,1,NULL,NULL,NULL,NULL,'','',11,1,1);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (75,2,1,'path','访问路径','栏目的访问路径',1,1,NULL,NULL,NULL,NULL,'','',0,1,1);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (77,2,1,'outerUrl','外部链接','',1,1,50,NULL,NULL,NULL,'','',1,1,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (110,2,2,'origin','来源','',1,1,NULL,NULL,NULL,NULL,'','',2,1,1);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (111,2,2,'shortTitle','简短标题','',1,1,NULL,NULL,NULL,NULL,'','',1,1,1);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (112,2,2,'description','摘要','',1,1,NULL,NULL,NULL,NULL,'','',3,1,1);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (113,2,1,'content','内容','',1,1,NULL,NULL,NULL,NULL,'','',12,1,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (114,2,1,'titleImg','缩略图','',1,1,NULL,NULL,NULL,NULL,'','',13,1,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (115,2,1,'contentImg','内容图','',1,1,NULL,NULL,NULL,NULL,'','',14,1,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (116,2,1,'groupContribute','投稿控制','',1,1,NULL,NULL,NULL,NULL,'','',8,1,1);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (117,2,1,'groupVisit','访问控制','',1,1,NULL,NULL,NULL,NULL,'','',7,1,1);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (118,2,1,'admins','管理权限','',1,1,NULL,NULL,NULL,NULL,'','',9,1,1);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (157,2,1,'defStr1','自定义字符串1','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (158,2,1,'defStr2','自定义字符串2','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (159,2,1,'defStr3','自定义字符串3','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (160,2,1,'defStr4','自定义字符串4','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (161,2,1,'defStr5','自定义字符串5','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (162,2,1,'defStr6','自定义字符串6','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (163,2,1,'defStr7','自定义字符串7','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (164,2,1,'defStr8','自定义字符串8','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (165,2,1,'defStr9','自定义字符串9','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (166,2,1,'defLong1','自定义整数1','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (167,2,1,'defLong2','自定义整数2','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (168,2,1,'defLong3','自定义整数3','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (169,2,1,'defLong4','自定义整数4','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (170,2,1,'defLong5','自定义整数5','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (171,2,1,'defMoney1','自定义金额1','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (172,2,1,'defMoney2','自定义金额2','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (173,2,1,'defMoney3','自定义金额3','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (174,2,1,'defDate1','自定义日期1','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (175,2,1,'defDate2','自定义日期2','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (176,2,1,'defDate3','自定义日期3','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (177,2,1,'defBool1','自定义布尔1','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (178,2,1,'defBool2','自定义布尔2','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (179,2,1,'defBool3','自定义布尔3','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (180,2,2,'tags','Tag标签','',1,1,NULL,NULL,NULL,NULL,'','',4,1,1);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (181,2,2,'relatedIds','相关文章','',1,1,NULL,NULL,NULL,NULL,'','',5,1,1);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (182,2,2,'topLevel','固顶级别','',1,1,NULL,NULL,NULL,NULL,'','',6,1,1);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (183,2,2,'draft','是否草稿','',1,1,NULL,NULL,NULL,NULL,'','',7,1,1);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (184,2,2,'content','内容','',1,1,NULL,NULL,NULL,NULL,'','',8,1,1);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (185,2,2,'titleImg','缩略图','',1,1,NULL,NULL,NULL,NULL,'','',9,1,1);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (186,2,2,'contentImg','内容图','',1,1,NULL,NULL,NULL,NULL,'','',10,1,1);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (187,2,2,'releaseDate','发布时间','',1,1,NULL,NULL,NULL,NULL,'','',11,1,1);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (188,2,2,'paramData','栏目数据','',1,1,NULL,NULL,NULL,NULL,'','',12,1,1);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (189,2,2,'defStr1','自定义字符串1','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (190,2,2,'defStr2','自定义字符串2','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (191,2,2,'defStr3','自定义字符串3','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (192,2,2,'defStr4','自定义字符串4','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (193,2,2,'defStr5','自定义字符串5','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (194,2,2,'defStr6','自定义字符串6','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (195,2,2,'defStr7','自定义字符串7','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (196,2,2,'defStr8','自定义字符串8','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (197,2,2,'defStr9','自定义字符串9','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (198,2,2,'defLong1','自定义整数1','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (199,2,2,'defLong2','自定义整数2','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (200,2,2,'defLong3','自定义整数3','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (201,2,2,'defLong4','自定义整数4','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (202,2,2,'defLong5','自定义整数5','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (203,2,2,'defMoney1','自定义金额1','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0);
INSERT INTO CMS_CHNL_MODEL_ITEM VALUES (204,2,2,'defMoney2','自定义金额2','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0);