testsql.sql

Phpcms2008 是一款基于 PHP+Mysql 架构的网站内容管理系统

INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES(11, 'phpcms', 0, 1, 0, '0', 1, '11,12,13', '新闻', '', '', '', '', 'news', 'news/index.html', '', 0, 0, 'array (\n  ''workflowid'' => ''1'',\n  ''meta_title'' => ''新闻咨询门户'',\n  ''meta_keywords'' => ''新闻,新闻中心,新闻频道,时事报道'',\n  ''meta_description'' => ''新闻,新闻中心,包含有时政新闻,国内新闻,国际新闻,社会新闻,时事评论,新闻图片,新闻专题,的专业时事报道门户网站'',\n  ''presentpoint'' => ''1'',\n  ''defaultchargepoint'' => ''0'',\n  ''repeatchargedays'' => ''1'',\n  ''template_category'' => ''category'',\n  ''template_list'' => ''list'',\n  ''template_show'' => ''show'',\n  ''template_print'' => ''print'',\n)', 11, 1);
INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES(12, 'phpcms', 0, 1, 11, '0,11', 0, '12', '国内', '', '', '', 'news/', 'domestic', 'news/domestic/index.html', '', 0, 0, 'array (\n  ''workflowid'' => ''1'',\n  ''meta_title'' => ''国内新闻'',\n  ''meta_keywords'' => ''国内新闻,政治,高层,时政,评论'',\n  ''meta_description'' => ''国内新闻,政界,实用新闻,案件事故,媒体评论,深度报道,政策解读,港澳台,时政新闻,热点新闻'',\n  ''presentpoint'' => ''1'',\n  ''defaultchargepoint'' => ''0'',\n  ''repeatchargedays'' => ''1'',\n  ''template_category'' => ''category'',\n  ''template_list'' => ''list'',\n  ''template_show'' => ''show'',\n  ''template_print'' => ''print'',\n)', 12, 1);
INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES(13, 'phpcms', 0, 1, 11, '0,11', 0, '13', '国际', '', '', '', 'news/', 'world', 'news/world/index.html', '', 0, 0, 'array (\n  ''workflowid'' => ''1'',\n  ''meta_title'' => ''国际新闻'',\n  ''meta_keywords'' => ''国际新闻,国际时事,国际政治'',\n  ''meta_description'' => ''国际新闻,国际政治,国际时事报道,事故灾难,热点追踪'',\n  ''presentpoint'' => ''1'',\n  ''defaultchargepoint'' => ''0'',\n  ''repeatchargedays'' => ''1'',\n  ''template_category'' => ''category'',\n  ''template_list'' => ''list'',\n  ''template_show'' => ''show'',\n  ''template_print'' => ''print'',\n)', 13, 1);
INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES(14, 'phpcms', 0, 2, 0, '0', 1, '14,15,16', '图片', '', '', '', '', 'photo', 'photo/index.html', '', 0, 0, 'array (\n  ''workflowid'' => ''1'',\n  ''meta_title'' => ''图片中心'',\n  ''meta_keywords'' => ''风景图片,明星图片,明星写真，桌面图片,汽车图片,时尚家居,时尚服饰'',\n  ''meta_description'' => ''汇集美女图片,美女写真,搞笑图片,卡通图片,风景图片,明星图片,明星写真，桌面图片,时尚家居,时尚服饰综合性的图片站点，每天实时更新'',\n  ''presentpoint'' => ''1'',\n  ''defaultchargepoint'' => ''0'',\n  ''repeatchargedays'' => ''1'',\n  ''template_category'' => ''category_picture'',\n  ''template_list'' => ''list_picture'',\n  ''template_show'' => ''show_picture'',\n  ''template_print'' => ''print'',\n)', 14, 1);
INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES(15, 'phpcms', 0, 2, 14, '0,14', 0, '15', '自然风光', '', '', '', 'photo/', 'tour', 'photo/tour/index.html', '', 0, 0, 'array (\n  ''workflowid'' => ''1'',\n  ''meta_title'' => ''中文图片站'',\n  ''meta_keywords'' => ''风景,动物,植物,自然,世界'',\n  ''meta_description'' => ''汇集美女图片,美女写真,搞笑图片,卡通图片,风景图片,明星图片,明星写真，桌面图片,时尚家居,时尚服饰综合性的图片站点，每天实时更新'',\n  ''presentpoint'' => ''1'',\n  ''defaultchargepoint'' => ''0'',\n  ''repeatchargedays'' => ''1'',\n  ''template_category'' => ''category_picture'',\n  ''template_list'' => ''list_picture'',\n  ''template_show'' => ''show_picture'',\n  ''template_print'' => ''print'',\n)', 15, 1);
INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES(16, 'phpcms', 0, 2, 14, '0,14', 0, '16', '美食图片', '', '', '', 'photo/', 'foodpicture', 'photo/foodpicture/index.html', '', 0, 0, 'array (\n  ''workflowid'' => ''1'',\n  ''meta_title'' => ''中文图片站'',\n  ''meta_keywords'' => ''美食图片'',\n  ''meta_description'' => ''汇集美女图片,美女写真,搞笑图片,卡通图片,风景图片,明星图片,明星写真，桌面图片,时尚家居,时尚服饰综合性的图片站点，每天实时更新'',\n  ''presentpoint'' => ''1'',\n  ''defaultchargepoint'' => ''0'',\n  ''repeatchargedays'' => ''1'',\n  ''template_category'' => ''category_picture'',\n  ''template_list'' => ''list_picture'',\n  ''template_show'' => ''show_picture'',\n  ''template_print'' => ''print'',\n)', 16, 1);
INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES(17, 'phpcms', 0, 3, 0, '0', 1, '17,18,19', '下载', '', '', '', '', 'down', 'down/index.html', '', 0, 0, 'array (\n  ''workflowid'' => ''1'',\n  ''meta_title'' => ''软件下载站'',\n  ''meta_keywords'' => ''软件下载,工具下载,杀毒软件下载,免费杀毒软件下载,源码下载,BT软件下载,压缩软件,flash播放器,QQ软件,迅雷下载,高速下载,病毒,杀毒,皮肤,音乐播放,视频播放,浏览器,免费软件'',\n  ''meta_description'' => ''下载提供最新最全的软件工具,杀毒软件,BT软件下载,软件高速下载,源码下载,工具下载,游戏下载,手机软件等丰富的内容,互联网资源共享的集中营'',\n  ''presentpoint'' => ''1'',\n  ''defaultchargepoint'' => ''0'',\n  ''repeatchargedays'' => ''1'',\n  ''template_category'' => ''category_down'',\n  ''template_list'' => ''list_down'',\n  ''template_show'' => ''show_down'',\n  ''template_print'' => ''print'',\n)', 17, 1);
INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES(18, 'phpcms', 0, 3, 17, '0,17', 0, '18', '办公软件', '', '', '', 'down/', 'office', 'down/office/index.html', '', 0, 0, 'array (\n  ''workflowid'' => ''1'',\n  ''meta_title'' => ''软件下载站'',\n  ''meta_keywords'' => ''办公软件,办公文件管理'',\n  ''meta_description'' => ''下载排行,热门下载,办公软件用户热评软件排行'',\n  ''presentpoint'' => ''1'',\n  ''defaultchargepoint'' => ''0'',\n  ''repeatchargedays'' => ''1'',\n  ''template_category'' => ''category_down'',\n  ''template_list'' => ''list_down'',\n  ''template_show'' => ''show_down'',\n  ''template_print'' => ''print'',\n)', 18, 1);
INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES(19, 'phpcms', 0, 3, 17, '0,17', 0, '19', '媒体软件', '', '', '', 'down/', 'media', 'down/media/index.html', '', 0, 0, 'array (\n  ''workflowid'' => ''1'',\n  ''meta_title'' => ''软件下载站'',\n  ''meta_keywords'' => ''媒体软件,MP3播放'',\n  ''meta_description'' => ''视频播放,转换等相关下载软件等'',\n  ''presentpoint'' => ''1'',\n  ''defaultchargepoint'' => ''0'',\n  ''repeatchargedays'' => ''1'',\n  ''template_category'' => ''category_down'',\n  ''template_list'' => ''list_down'',\n  ''template_show'' => ''show_down'',\n  ''template_print'' => ''print'',\n)', 19, 1);
INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES(20, 'phpcms', 0, 4, 0, '0', 1, '20,21,22', '信息', '', '', '', '', 'info', 'info/index.html', '', 0, 0, 'array (\n  ''workflowid'' => ''1'',\n  ''meta_title'' => ''免费信息发布'',\n  ''meta_keywords'' => ''分类广告,租房合租信息,招聘兼职,二手转让,征婚交友,家政保姆,拼车拼游,买卖转让二手家电,电脑,手机'',\n  ''meta_description'' => ''免费发布信息,查询分类广告,租房合租信息,招聘兼职,二手转让,征婚交友,家政保姆,拼车拼游,买卖转让二手家电,电脑,手机,票务等相关个人生活信息'',\n  ''presentpoint'' => ''1'',\n  ''defaultchargepoint'' => ''0'',\n  ''repeatchargedays'' => ''1'',\n  ''template_category'' => ''category_info'',\n  ''template_list'' => ''list_info'',\n  ''template_show'' => ''show_info'',\n  ''template_print'' => ''print'',\n)', 20, 1);
INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES(21, 'phpcms', 0, 4, 20, '0,20', 0, '21', '房屋信息', '', '', '', 'info/', 'house', 'info/house/index.html', '', 0, 0, 'array (\n  ''workflowid'' => ''1'',\n  ''meta_title'' => ''分类信息'',\n  ''meta_keywords'' => ''租房,出租房屋,二手房,免费发布租房信息'',\n  ''meta_description'' => ''为您提供大量免费的租房，求租，个人房屋出租，二手房买卖，商铺，公寓,别墅等租赁信息，您还可以免费发布租房信息'',\n  ''presentpoint'' => ''1'',\n  ''defaultchargepoint'' => ''0'',\n  ''repeatchargedays'' => ''1'',\n  ''template_category'' => ''category_info'',\n  ''template_list'' => ''list_info'',\n  ''template_show'' => ''show_info'',\n  ''template_print'' => ''print'',\n)', 21, 1);
INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES(22, 'phpcms', 0, 4, 20, '0,20', 0, '22', '跳蚤市场', '', '', '', 'info/', 'sale', 'info/sale/index.html', '', 0, 0, 'array (\n  ''workflowid'' => ''1'',\n  ''meta_title'' => ''分类信息'',\n  ''meta_keywords'' => ''二手市场,二手物品,二手物品交易,二手物品信息,二手市场网,二手交易平台'',\n  ''meta_description'' => ''在这里您可以找到成千上万二手物品的信息,也是您发布您需要转让的二手物品的交易平台'',\n  ''presentpoint'' => ''1'',\n  ''defaultchargepoint'' => ''0'',\n  ''repeatchargedays'' => ''1'',\n  ''template_category'' => ''category_info'',\n  ''template_list'' => ''list_info'',\n  ''template_show'' => ''show_info'',\n  ''template_print'' => ''print'',\n)', 22, 1);
INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES(23, 'phpcms', 0, 5, 0, '0', 1, '23,24,25', '产品', '', '', '', '', 'product', 'product/index.html', '', 0, 0, 'array (\n  ''workflowid'' => ''1'',\n  ''meta_title'' => ''产品展示_交易中心'',\n  ''meta_keywords'' => ''在线下单,新品展示'',\n  ''meta_description'' => ''在线下单,新品展示'',\n  ''presentpoint'' => ''1'',\n  ''defaultchargepoint'' => ''0'',\n  ''repeatchargedays'' => ''1'',\n  ''template_category'' => ''category_product'',\n  ''template_list'' => ''list_product'',\n  ''template_show'' => ''show_product'',\n  ''template_print'' => ''print'',\n)', 23, 1);
INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES(24, 'phpcms', 0, 5, 23, '0,23', 0, '24', '数码相机', '', '', '', 'product/', 'camera', 'product/camera/index.html', '', 0, 0, 'array (\n  ''workflowid'' => ''1'',\n  ''meta_title'' => ''产品中心'',\n  ''meta_keywords'' => ''佳能,索尼,三星,尼康,富士,松下'',\n  ''meta_description'' => ''这里提供了各类普通数码相机数码相机/摄像机/图形冲印商品'',\n  ''presentpoint'' => ''1'',\n  ''defaultchargepoint'' => ''0'',\n  ''repeatchargedays'' => ''1'',\n  ''template_category'' => ''category_product'',\n  ''template_list'' => ''list_product'',\n  ''template_show'' => ''show_product'',\n  ''template_print'' => ''print'',\n)', 24, 1);
INSERT INTO `phpcms_category` (`catid`, `module`, `type`, `modelid`, `parentid`, `arrparentid`, `child`, `arrchildid`, `catname`, `style`, `image`, `description`, `parentdir`, `catdir`, `url`, `content`, `items`, `hits`, `setting`, `listorder`, `ismenu`) VALUES(25, 'phpcms', 0, 5, 23, '0,23', 0, '25', '办公设备', '', '', '', 'product/', 'office', 'product/office/index.html', '', 0, 0, 'array (\n  ''workflowid'' => ''1'',\n  ''meta_title'' => ''产品中心'',\n  ''meta_keywords'' => ''打印机,复印机,计算器,考勤机,传真机'',\n  ''meta_description'' => ''打印机,复印机,计算器,考勤机,传真机,在线下单,新品展示'',\n  ''presentpoint'' => ''1'',\n  ''defaultchargepoint'' => ''0'',\n  ''repeatchargedays'' => ''1'',\n  ''template_category'' => ''category_product'',\n  ''template_list'' => ''list_product'',\n  ''template_show'' => ''show_product'',\n  ''template_print'' => ''print'',\n)', 25, 1);