jeecms-init-2.0.0-beta.sql

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

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 (9,1,'article','首页模型','index','',1,'首页',1);

INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (1,2,'title','title',NULL,NULL,1,4);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (2,2,'priority','排列顺序',NULL,NULL,1,7);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (3,2,'keywords','keywords',NULL,NULL,1,5);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (4,2,'description','description',NULL,NULL,1,6);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (15,2,'tplIndex','栏目页模板',NULL,NULL,1,2);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (16,2,'tplContent','内容页模板',NULL,NULL,1,3);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (17,2,'contributeLevel','允许投稿级别',NULL,NULL,1,8);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (18,2,'paramData','栏目数据',NULL,NULL,1,10);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (43,2,'display','是否显示',NULL,NULL,1,9);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (45,7,'tplIndex','单页模板',NULL,NULL,1,2);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (46,7,'tplContent','内容页模板',NULL,NULL,0,3);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (47,7,'title','title',NULL,NULL,1,4);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (48,7,'keywords','keywords',NULL,NULL,1,5);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (49,7,'description','description',NULL,NULL,1,6);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (50,7,'priority','排列顺序',NULL,NULL,1,7);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (51,7,'contributeLevel','允许投稿级别',NULL,NULL,0,8);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (52,7,'display','是否显示',NULL,NULL,1,9);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (53,7,'paramData','栏目数据',NULL,NULL,1,10);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (54,8,'tplIndex','栏目页模板',NULL,NULL,0,3);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (55,8,'tplContent','内容页模板',NULL,NULL,0,4);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (56,8,'title','title',NULL,NULL,0,5);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (57,8,'keywords','keywords',NULL,NULL,0,6);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (58,8,'description','description',NULL,NULL,0,7);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (59,8,'priority','排列顺序',NULL,NULL,1,8);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (60,8,'contributeLevel','允许投稿级别',NULL,NULL,0,9);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (61,8,'display','是否显示',NULL,NULL,1,10);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (62,8,'paramData','栏目数据',NULL,NULL,0,11);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (63,9,'tplIndex','首页模板',NULL,NULL,1,2);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (64,9,'tplContent','内容页模板',NULL,NULL,0,3);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (65,9,'title','title',NULL,NULL,1,4);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (66,9,'keywords','keywords',NULL,NULL,1,5);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (67,9,'description','description',NULL,NULL,1,6);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (68,9,'priority','排列顺序',NULL,NULL,0,7);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (69,9,'contributeLevel','允许投稿级别',NULL,NULL,0,8);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (70,9,'display','是否显示',NULL,NULL,0,9);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (71,9,'paramData','栏目数据',NULL,NULL,1,10);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (72,9,'path','访问路径',NULL,NULL,1,0);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (73,8,'path','访问路径',NULL,NULL,0,1);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (74,7,'path','访问路径',NULL,NULL,1,0);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (75,2,'path','访问路径',NULL,NULL,1,0);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (76,8,'outerUrl','外部链接',NULL,NULL,1,2);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (77,2,'outerUrl','外部链接',NULL,NULL,0,1);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (78,7,'outerUrl','外部链接',NULL,NULL,0,1);
INSERT INTO cms_chnl_model_item (MITEM_ID,MODEL_ID,NAME,LABEL,HELP,INPUT_TYPE,IS_CHECKED,PRIORITY) VALUES (79,9,'outerUrl','外部链接',NULL,NULL,0,1);

INSERT INTO `cms_channel` VALUES (1,1,NULL,9,'article','main','首页',NULL,'',NULL,'JEECMS演示站','JEECMS演示站','JEECMS演示站',3,0,'2008-11-29',NULL,2147483647,100,1,1,'','','');
INSERT INTO `cms_channel` VALUES (2,1,1,2,'article','gnxw','国内新闻',NULL,'','','','国内,新闻','国内最权威的新闻',0,0,'2008-11-29','',1000,10,1,1,'','','');
INSERT INTO `cms_channel` VALUES (3,1,1,2,'article','gwxw','国外新闻',NULL,'','','','国外,新闻','报道国外最新动态',0,0,'2008-11-29',NULL,1000,10,1,1,'','','');
INSERT INTO `cms_channel` VALUES (4,1,1,7,'article','about','关于我们',NULL,'/article/default/alone_about.html',NULL,'','jeecms,jspcms,javacms','国内专业的开源java版cms',10,0,'2008-11-29',NULL,2147483647,10,0,1,'','','');
INSERT INTO `cms_channel` VALUES (5,1,1,8,'article',NULL,'留言板',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2008-11-29','/jeecms/Guestbook.htm',2147483647,10,0,1,NULL,NULL,NULL);

INSERT INTO `arti_article` VALUES (1,1,NULL,NULL,NULL,2,NULL,NULL,NULL,1,'中国队勇夺世界杯','中国队勇夺世界杯',NULL,NULL,NULL,'中国队勇夺世界杯',NULL,'jeecms','原创','2008-11-29 16:03:45','2008-11-29 16:03:45',NULL,NULL,0,0,'2008-11-29','',NULL,1,NULL,NULL,NULL,0,0,1,0,0,'','','');
INSERT INTO `arti_article` VALUES (2,1,NULL,NULL,NULL,2,NULL,NULL,NULL,1,'奥运会在中国开幕','奥运会在中国开幕',NULL,NULL,NULL,'奥运会在中国开幕',NULL,'jeecms','原创','2008-11-29 16:05:07','2008-11-29 16:05:07',NULL,NULL,0,0,'2008-11-29','',NULL,1,NULL,NULL,NULL,0,0,1,0,0,'','','');
INSERT INTO `arti_article` VALUES (3,1,NULL,NULL,NULL,3,NULL,NULL,NULL,1,'美国爆发金融海啸','美国爆发金融海啸',NULL,NULL,NULL,'美国爆发金融海啸',NULL,'评论员','人们网','2008-11-29 16:05:58','2008-11-29 16:05:58',NULL,NULL,0,0,'2008-11-29','',NULL,1,NULL,NULL,NULL,0,0,1,0,0,'','','');