jeecms-init-0.7.0-beta.sql

JSP(Java Server Pages)是由Sun Microsystems公司倡导、许多公司参与一起建立的一种动态网页技术标准。 JSP技术是用JAVA语言作为脚本语言的

INSERT INTO `cms_role_function` VALUES (1,7);
INSERT INTO `cms_role_function` VALUES (1,8);
INSERT INTO `cms_role_function` VALUES (1,9);
INSERT INTO `cms_role_function` VALUES (1,10);
INSERT INTO `cms_role_function` VALUES (1,11);
INSERT INTO `cms_role_function` VALUES (1,12);
INSERT INTO `cms_role_function` VALUES (1,13);
INSERT INTO `cms_role_function` VALUES (1,14);
INSERT INTO `cms_role_function` VALUES (1,15);
INSERT INTO `cms_role_function` VALUES (1,16);
INSERT INTO `cms_role_function` VALUES (1,17);
INSERT INTO `cms_role_function` VALUES (1,18);
INSERT INTO `cms_role_function` VALUES (1,19);
INSERT INTO `cms_role_function` VALUES (1,20);
INSERT INTO `cms_role_function` VALUES (1,21);
INSERT INTO `cms_role_function` VALUES (1,22);
INSERT INTO `cms_role_function` VALUES (1,23);
INSERT INTO `cms_role_function` VALUES (1,24);
INSERT INTO `cms_role_function` VALUES (1,25);
INSERT INTO `cms_role_function` VALUES (1,26);
INSERT INTO `cms_role_function` VALUES (1,27);
INSERT INTO `cms_role_function` VALUES (1,48);
INSERT INTO `cms_role_function` VALUES (1,49);
INSERT INTO `cms_role_function` VALUES (1,50);
INSERT INTO `cms_role_function` VALUES (1,51);
INSERT INTO `cms_role_function` VALUES (1,52);
INSERT INTO `cms_role_function` VALUES (1,53);
INSERT INTO `cms_role_function` VALUES (1,54);
INSERT INTO `cms_role_function` VALUES (1,55);
INSERT INTO `cms_role_function` VALUES (1,56);
INSERT INTO `cms_role_function` VALUES (1,57);
INSERT INTO `cms_role_function` VALUES (1,58);
INSERT INTO `cms_role_function` VALUES (1,59);
INSERT INTO `cms_role_function` VALUES (1,60);
INSERT INTO `cms_role_function` VALUES (1,61);
INSERT INTO `cms_role_function` VALUES (1,62);
INSERT INTO `cms_role_function` VALUES (1,81);
INSERT INTO `cms_role_function` VALUES (1,83);
INSERT INTO `cms_role_function` VALUES (1,84);
INSERT INTO `cms_role_function` VALUES (1,85);
INSERT INTO `cms_role_function` VALUES (1,86);
INSERT INTO `cms_role_function` VALUES (1,87);
INSERT INTO `cms_role_function` VALUES (1,90);
INSERT INTO `cms_role_function` VALUES (1,91);
INSERT INTO `cms_role_function` VALUES (1,92);
INSERT INTO `cms_role_function` VALUES (1,93);
INSERT INTO `cms_role_function` VALUES (1,94);
INSERT INTO `cms_role_function` VALUES (1,95);
INSERT INTO `cms_role_function` VALUES (1,96);
INSERT INTO `cms_role_function` VALUES (1,97);
INSERT INTO `cms_role_function` VALUES (1,98);
INSERT INTO `cms_role_function` VALUES (1,99);
INSERT INTO `cms_role_function` VALUES (1,100);
INSERT INTO `cms_role_function` VALUES (1,101);
INSERT INTO `cms_role_function` VALUES (1,102);
INSERT INTO `cms_role_function` VALUES (1,103);
INSERT INTO `cms_role_function` VALUES (1,104);
INSERT INTO `cms_role_function` VALUES (1,105);
INSERT INTO `cms_role_function` VALUES (1,106);
INSERT INTO `cms_role_function` VALUES (1,107);
INSERT INTO `cms_role_function` VALUES (1,108);
INSERT INTO `cms_role_function` VALUES (1,109);
INSERT INTO `cms_role_function` VALUES (1,110);
INSERT INTO `cms_role_function` VALUES (1,111);
INSERT INTO `cms_role_function` VALUES (1,112);
INSERT INTO `cms_role_function` VALUES (1,113);
INSERT INTO `cms_role_function` VALUES (1,114);
INSERT INTO `cms_role_function` VALUES (1,115);
INSERT INTO `cms_role_function` VALUES (1,116);
INSERT INTO `cms_role_function` VALUES (1,117);
INSERT INTO `cms_role_function` VALUES (1,118);
INSERT INTO `cms_role_function` VALUES (1,119);
INSERT INTO `cms_role_function` VALUES (1,120);
INSERT INTO `cms_role_function` VALUES (1,121);
INSERT INTO `cms_role_function` VALUES (1,122);
INSERT INTO `cms_role_function` VALUES (1,123);
INSERT INTO `cms_role_function` VALUES (1,124);
INSERT INTO `cms_role_function` VALUES (1,125);
INSERT INTO `cms_role_function` VALUES (1,126);
INSERT INTO `cms_role_function` VALUES (1,127);
INSERT INTO `cms_role_function` VALUES (1,128);
INSERT INTO `cms_role_function` VALUES (1,129);
INSERT INTO `cms_role_function` VALUES (1,157);
INSERT INTO `cms_role_function` VALUES (1,158);
INSERT INTO `cms_role_function` VALUES (1,159);
INSERT INTO `cms_role_function` VALUES (1,160);
INSERT INTO `cms_role_function` VALUES (1,161);
INSERT INTO `cms_role_function` VALUES (1,162);
INSERT INTO `cms_role_function` VALUES (1,163);
INSERT INTO `cms_role_function` VALUES (1,164);
INSERT INTO `cms_role_function` VALUES (1,165);
INSERT INTO `cms_role_function` VALUES (1,166);
INSERT INTO `cms_role_function` VALUES (1,167);
INSERT INTO `cms_role_function` VALUES (1,168);
INSERT INTO `cms_role_function` VALUES (1,169);
INSERT INTO `cms_role_function` VALUES (1,170);
INSERT INTO `cms_role_function` VALUES (1,171);
INSERT INTO `cms_role_function` VALUES (1,172);
INSERT INTO `cms_role_function` VALUES (1,173);
INSERT INTO `cms_role_function` VALUES (1,174);
INSERT INTO `cms_role_function` VALUES (1,175);
INSERT INTO `cms_role_function` VALUES (1,202);
INSERT INTO `cms_role_function` VALUES (1,203);
INSERT INTO `cms_role_function` VALUES (1,204);
INSERT INTO `cms_role_function` VALUES (1,205);
INSERT INTO `cms_role_function` VALUES (1,206);
INSERT INTO `cms_role_function` VALUES (1,207);
INSERT INTO `cms_role_function` VALUES (1,208);
INSERT INTO `cms_role_function` VALUES (1,209);
INSERT INTO `cms_role_function` VALUES (1,210);
INSERT INTO `cms_role_function` VALUES (1,211);
INSERT INTO `cms_role_function` VALUES (1,212);
INSERT INTO `cms_role_function` VALUES (1,213);
INSERT INTO `cms_role_function` VALUES (1,214);
INSERT INTO `cms_role_function` VALUES (1,215);
INSERT INTO `cms_role_function` VALUES (1,216);
INSERT INTO `cms_role_function` VALUES (1,217);
INSERT INTO `cms_role_function` VALUES (1,218);
INSERT INTO `cms_role_function` VALUES (1,219);
INSERT INTO `cms_role_function` VALUES (1,220);
INSERT INTO `cms_role_function` VALUES (1,221);
INSERT INTO `cms_role_function` VALUES (1,234);
INSERT INTO `cms_role_function` VALUES (1,235);
INSERT INTO `cms_role_function` VALUES (1,236);
INSERT INTO `cms_role_function` VALUES (1,237);
INSERT INTO `cms_role_function` VALUES (1,238);
INSERT INTO `cms_role_function` VALUES (1,239);
INSERT INTO `cms_role_function` VALUES (1,240);
INSERT INTO `cms_role_function` VALUES (1,241);
INSERT INTO `cms_role_function` VALUES (1,242);
INSERT INTO `cms_role_function` VALUES (1,243);
INSERT INTO `cms_role_function` VALUES (1,244);
INSERT INTO `cms_role_function` VALUES (1,245);
INSERT INTO `cms_role_function` VALUES (1,246);
INSERT INTO `cms_role_function` VALUES (1,247);
INSERT INTO `cms_role_function` VALUES (1,248);
INSERT INTO `cms_role_function` VALUES (1,249);
INSERT INTO `cms_role_function` VALUES (1,250);
INSERT INTO `cms_role_function` VALUES (1,251);
INSERT INTO `cms_role_function` VALUES (1,252);
INSERT INTO `cms_role_function` VALUES (1,253);
INSERT INTO `cms_role_function` VALUES (1,254);
INSERT INTO `cms_role_function` VALUES (1,256);
INSERT INTO `cms_role_function` VALUES (1,258);
INSERT INTO `cms_role_function` VALUES (1,335);
INSERT INTO `cms_role_function` VALUES (1,347);
INSERT INTO `cms_role_function` VALUES (1,348);
INSERT INTO `cms_role_function` VALUES (1,349);
INSERT INTO `cms_role_function` VALUES (1,350);
INSERT INTO `cms_role_function` VALUES (1,351);

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

INSERT INTO `cms_template` VALUES (1,1,'page',1,'arti','1','首页模板','2008-10-16 16:48:24','2008-10-16 16:58:02',2,NULL);
INSERT INTO `cms_template` VALUES (2,1,'page',1,'arti','2','栏目页模板','2008-10-16 16:50:03','2008-10-16 17:15:33',2,NULL);
INSERT INTO `cms_template` VALUES (3,1,'page',2,'arti','3','内容页模板','2008-10-16 16:51:09','2008-10-16 16:51:09',1,NULL);
INSERT INTO `cms_template` VALUES (4,1,'incl',3,'arti','foot','页脚','2008-10-16 16:51:59','2008-10-16 16:53:32',2,NULL);
INSERT INTO `cms_template` VALUES (5,1,'incl',3,'arti','head','页头','2008-10-16 16:52:35','2008-10-16 17:10:21',6,NULL);
INSERT INTO `cms_template` VALUES (6,1,'incl',3,'arti','right','右列','2008-10-16 16:53:28','2008-10-16 17:28:22',10,NULL);

INSERT INTO `cms_channel` VALUES (1,1,3,NULL,1,'chnl','arti','main','首页','JEECMS演示站','JEECMS演示站','JEECMS演示站',NULL,NULL,21,21,'2008-10-16','',100,-1,1,'','','','','');
INSERT INTO `cms_channel` VALUES (2,1,3,1,2,'ctgr','arti','gnxw','国内新闻','','','',NULL,NULL,7,7,'2008-10-16','',100,1000,1,'','','','','');
INSERT INTO `cms_channel` VALUES (3,1,3,1,2,'ctgr','arti','gwxw','国外新闻','国外新闻','国外新闻','国外新闻',NULL,NULL,6,6,'2008-10-16',NULL,100,1000,1,'','','','','');

INSERT INTO `arti_article` VALUES (1,1,NULL,1,NULL,1,NULL,NULL,2,'','中国队勇夺世界杯',NULL,'','<P>中国对在公元3000年，取得了第一个世界杯冠军。</P>',NULL,'jeecms','原创','2008-10-16 17:12:43','2008-10-16 17:12:43','2008-10-16 17:12:43',NULL,0,0,'2008-10-16','','http://localhost:8080/CmsSys/res_base/nc138/arti/upload',0,NULL,0,0,1,0,0,'','','');
INSERT INTO `arti_article` VALUES (2,1,NULL,1,NULL,1,NULL,NULL,2,'','奥运会在中国开幕',NULL,'','<P>2008年8月8号，第28界夏季奥运会在在中国北京开幕。</P>',NULL,'jeecms','原创','2008-10-16 17:14:16','2008-10-16 17:14:16','2008-10-16 17:14:16',NULL,1,1,'2008-10-16','','http://localhost:8080/CmsSys/res_base/nc138/arti/upload',0,NULL,0,0,1,0,0,'','','');
INSERT INTO `arti_article` VALUES (3,1,NULL,1,NULL,1,NULL,NULL,3,'','美国爆发金融海啸',NULL,'','美国由于次贷危机，爆发了一次百年一遇的金融海啸',NULL,'评论员','人们网','2008-10-16 17:17:04','2008-10-16 17:17:04','2008-10-16 17:17:04',NULL,0,0,'2008-10-16','','http://localhost:8080/CmsSys/res_base/nc138/arti/upload',0,NULL,0,0,1,0,0,'','','');