--
-- Host: localhost    Database: winjohn
-- ------------------------------------------------------


--
-- Table structure for table `arti_article`
--

CREATE TABLE `arti_article` (
  `ARTICLE_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `WEBSITE_ID` bigint(20) NOT NULL,
  `CONFIG_ID` bigint(20) NOT NULL,
  `CTTCTG_ID` bigint(20) NOT NULL,
  `NEXT_ID` bigint(20) DEFAULT NULL COMMENT '下一篇',
  `PRE_ID` bigint(20) DEFAULT NULL COMMENT '上一篇',
  `GROUP_ID` bigint(20) DEFAULT NULL COMMENT '允许浏览会员组',
  `CHANNEL_ID` bigint(20) NOT NULL COMMENT '栏目ID',
  `MEMBER_ID` bigint(20) DEFAULT NULL COMMENT '录入会员',
  `ADMIN_CHECK` bigint(20) DEFAULT NULL COMMENT '审核管理员',
  `ADMIN_DISABLE` bigint(20) DEFAULT NULL COMMENT '禁用管理员',
  `ADMIN_INPUT` bigint(20) DEFAULT NULL COMMENT '录入管理员',
  `TITLE` varchar(255) DEFAULT NULL COMMENT '文章标题',
  `SHORT_TITLE` varchar(255) DEFAULT NULL COMMENT '简短标题（用于栏目或首页索引）',
  `TITLE_COLOR` varchar(10) DEFAULT NULL COMMENT '标题颜色',
  `TITLE_IMG` varchar(100) DEFAULT NULL COMMENT '文章标题缩略图',
  `CONTENT_IMG` varchar(100) DEFAULT NULL COMMENT '文章内容图',
  `DESCRIPTION` varchar(255) DEFAULT NULL COMMENT '文章描述',
  `TAGS` varchar(255) DEFAULT NULL COMMENT '标记，类似关键字',
  `AUTHOR` varchar(100) DEFAULT NULL COMMENT '作者',
  `ORIGIN` varchar(100) DEFAULT NULL COMMENT '来源',
  `SORT_DATE` datetime NOT NULL COMMENT '排序日期（通过置顶时间调整）',
  `RELEASE_DATE` datetime NOT NULL COMMENT '发表日期（可人为设置）',
  `RELEASE_SYS_DATE` datetime NOT NULL COMMENT '发布日期（系统日期）',
  `CHECK_TIME` datetime DEFAULT NULL COMMENT '终审通过时间',
  `DISABLE_TIME` datetime DEFAULT NULL COMMENT '禁用时间',
  `VISIT_TOTAL` bigint(20) NOT NULL DEFAULT '0' COMMENT '总共访问次数',
  `VISIT_TODAY` bigint(20) NOT NULL DEFAULT '0' COMMENT '当天访问次数',
  `VISIT_WEEK` bigint(20) NOT NULL DEFAULT '0' COMMENT '本周下载次数',
  `VISIT_MONTH` bigint(20) NOT NULL DEFAULT '0' COMMENT '本月下载次数',
  `VISIT_QUARTER` bigint(20) NOT NULL DEFAULT '0' COMMENT '本季下载次数',
  `VISIT_YEAR` bigint(20) NOT NULL DEFAULT '0' COMMENT '本年下载次数',
  `STAT_DATE` date DEFAULT NULL COMMENT '统计时间',
  `OUTER_URL` varchar(255) DEFAULT NULL COMMENT '外部链接',
  `CONTENT_RES_PATH` varchar(200) DEFAULT NULL COMMENT '文章内容的资源路径',
  `PAGE_COUNT` int(11) DEFAULT NULL COMMENT '文章总页数',
  `TPL_CONTENT` varchar(100) DEFAULT NULL COMMENT '指定模板',
  `CHECK_STEP` int(11) NOT NULL DEFAULT '0' COMMENT '审核级数',
  `TOP_LEVEL` int(11) NOT NULL DEFAULT '0' COMMENT '置顶级别',
  `COMMENT_COUNT` int(11) NOT NULL DEFAULT '0' COMMENT '评论数量',
  `CHECK_OPINION` varchar(255) DEFAULT NULL COMMENT '审核意见',
  `RELATED_IDS` varchar(255) DEFAULT NULL COMMENT '相关文章ID',
  `HAS_TITLEIMG` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否有标题图片',
  `ALLOW_COMMENT` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否允许评论',
  `IS_BOLD` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否加粗',
  `IS_DRAFT` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否草稿',
  `IS_RECOMMEND` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否推荐',
  `IS_CHECK` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否审核',
  `IS_DISABLED` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否禁用',
  `IS_REJECT` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否驳回',
  `PARAM1` varchar(255) DEFAULT NULL COMMENT '文章相关数据1',
  `PARAM2` varchar(255) DEFAULT NULL COMMENT '文章相关数据2',
  `PARAM3` varchar(255) DEFAULT NULL COMMENT '文章相关数据3',
  `DEF_STRING_1` varchar(255) DEFAULT NULL COMMENT '自定义字符串1',
  `DEF_STRING_2` varchar(255) DEFAULT NULL COMMENT '自定义字符串2',
  `DEF_STRING_3` varchar(255) DEFAULT NULL COMMENT '自定义字符串3',
  `DEF_STRING_4` varchar(255) DEFAULT NULL COMMENT '自定义字符串4',
  `DEF_STRING_5` varchar(255) DEFAULT NULL COMMENT '自定义字符串5',
  `DEF_STRING_6` varchar(255) DEFAULT NULL COMMENT '自定义字符串6',
  `DEF_STRING_7` varchar(255) DEFAULT NULL COMMENT '自定义字符串7',
  `DEF_STRING_8` varchar(255) DEFAULT NULL COMMENT '自定义字符串8',
  `DEF_STRING_9` varchar(255) DEFAULT NULL COMMENT '自定义字符串9',
  `DEF_LONG_1` bigint(20) DEFAULT NULL COMMENT '自定义长整数1',
  `DEF_LONG_2` bigint(20) DEFAULT NULL COMMENT '自定义长整数1',
  `DEF_LONG_3` bigint(20) DEFAULT NULL COMMENT '自定义长整数1',
  `DEF_LONG_4` bigint(20) DEFAULT NULL COMMENT '自定义长整数1',
  `DEF_LONG_5` bigint(20) DEFAULT NULL COMMENT '自定义长整数1',
  `DEF_MONEY1` decimal(12,2) DEFAULT NULL COMMENT '自定义金额1',
  `DEF_MONEY2` decimal(12,2) DEFAULT NULL COMMENT '自定义金额2',
  `DEF_MONEY3` decimal(12,2) DEFAULT NULL COMMENT '自定义金额3',
  `DEF_DATE1` datetime DEFAULT NULL COMMENT '自定义日期1',
  `DEF_DATE2` datetime DEFAULT NULL COMMENT '自定义日期2',
  `DEF_DATE3` datetime DEFAULT NULL COMMENT '自定义日期3',
  `DEF_BOOL1` tinyint(1) DEFAULT NULL COMMENT '自定义布尔1',
  `DEF_BOOL2` tinyint(1) DEFAULT NULL COMMENT '自定义布尔2',
  `DEF_BOOL3` tinyint(1) DEFAULT NULL COMMENT '自定义布尔3',
  PRIMARY KEY (`ARTICLE_ID`),
  KEY `ARTICLE_TOPLEVEL` (`TOP_LEVEL`),
  KEY `ARTICLE_SOTE_DATE` (`SORT_DATE`),
  KEY `ARTICLE_RELEASE_DATE` (`RELEASE_DATE`),
  KEY `ARTICLE_DISABLED` (`IS_DISABLED`),
  KEY `ARTICLE_CHECK` (`IS_CHECK`),
  KEY `ARTICLE_RECOMMENT` (`IS_RECOMMEND`),
  KEY `FK_ARTICLE_CHANNEL` (`CHANNEL_ID`),
  KEY `FK_ARTICLE_CHECK_CADMIN` (`ADMIN_CHECK`),
  KEY `FK_ARTICLE_CMEMBER` (`MEMBER_ID`),
  KEY `FK_ARTICLE_CMSCONFIG` (`CONFIG_ID`),
  KEY `FK_ARTICLE_CTTCTG` (`CTTCTG_ID`),
  KEY `FK_ARTICLE_DISABLE_CADMIN` (`ADMIN_DISABLE`),
  KEY `FK_ARTICLE_INPUT_CADMIN` (`ADMIN_INPUT`),
  KEY `FK_ARTICLE_MGROUP` (`GROUP_ID`),
  KEY `FK_ARTICLE_WEBSITE` (`WEBSITE_ID`),
  KEY `FK_NEXT_ARTICLE` (`NEXT_ID`),
  KEY `FK_RPE_ARTICLE` (`PRE_ID`),
  CONSTRAINT `FK_ARTICLE_CHANNEL` FOREIGN KEY (`CHANNEL_ID`) REFERENCES `cms_channel` (`CHANNEL_ID`),
  CONSTRAINT `FK_ARTICLE_CHECK_CADMIN` FOREIGN KEY (`ADMIN_CHECK`) REFERENCES `cms_admin` (`ADMIN_ID`),
  CONSTRAINT `FK_ARTICLE_CMEMBER` FOREIGN KEY (`MEMBER_ID`) REFERENCES `cms_member` (`MEMBER_ID`),
  CONSTRAINT `FK_ARTICLE_CMSCONFIG` FOREIGN KEY (`CONFIG_ID`) REFERENCES `cms_config` (`CONFIG_ID`),
  CONSTRAINT `FK_ARTICLE_CTTCTG` FOREIGN KEY (`CTTCTG_ID`) REFERENCES `cms_content_ctg` (`CTTCTG_ID`),
  CONSTRAINT `FK_ARTICLE_DISABLE_CADMIN` FOREIGN KEY (`ADMIN_DISABLE`) REFERENCES `cms_admin` (`ADMIN_ID`),
  CONSTRAINT `FK_ARTICLE_INPUT_CADMIN` FOREIGN KEY (`ADMIN_INPUT`) REFERENCES `cms_admin` (`ADMIN_ID`),
  CONSTRAINT `FK_ARTICLE_MGROUP` FOREIGN KEY (`GROUP_ID`) REFERENCES `cms_member_group` (`GROUP_ID`),
  CONSTRAINT `FK_ARTICLE_WEBSITE` FOREIGN KEY (`WEBSITE_ID`) REFERENCES `core_website` (`WEBSITE_ID`),
  CONSTRAINT `FK_NEXT_ARTICLE` FOREIGN KEY (`NEXT_ID`) REFERENCES `arti_article` (`ARTICLE_ID`),
  CONSTRAINT `FK_RPE_ARTICLE` FOREIGN KEY (`PRE_ID`) REFERENCES `arti_article` (`ARTICLE_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=gbk;

--
-- Dumping data for table `arti_article`
--

INSERT INTO `arti_article` VALUES (1,1,1,5,2,NULL,NULL,11,NULL,1,NULL,1,'解放军飞行员年均收入8万元与民航相差6倍','解放军飞行员年均收入8万元与民航相差6倍','','','','3月8日，由来自空军、海军等单位30多名人大代表联名签署的关于制定《中华人民共和国军事飞行人员法》的议案提交大会。目前，中国军队飞行员年均收入8万元，较之民航飞行员的50万元，相差6倍，军队面临飞行员流失的危险。','','网易','','2009-03-10 18:34:31','2009-03-10 18:34:31','2009-03-10 18:34:31','2009-03-10 18:34:31',NULL,1,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,1,1,5,35,1,NULL,11,NULL,1,NULL,1,'俄罗斯怕技术外流拒售中国苏33舰载机','俄罗斯怕技术外流拒售中国苏33舰载机','','','','据《汉和防务周刊》报道，中国希望购买俄罗斯50架苏33舰载战斗机配备航母，但想先买两架样品。而俄罗斯方面因担心中国会仿制苏33技术，拒绝此交易。','','网易','','2009-03-10 18:35:29','2009-03-10 18:35:29','2009-03-10 18:35:29','2009-03-10 18:35:29',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,1,1,1,4,NULL,NULL,12,NULL,1,NULL,1,'食品代言，明星成了靶子','食品代言，明星成了靶子','','','','食品不符合标准，明星得负连带责任，请问，销售商要不要负责任呢？零售商要不要负责任呢？电视台、电台播出了明星代言的广告片，电视台、电台要不要负责任呢？给问题产品颁发免检证书的相关部门要不要负责任呢？','','刘仪伟','','2009-03-10 18:36:29','2009-03-10 18:36:29','2009-03-10 18:36:29','2009-03-10 18:36:29',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,1,1,5,NULL,3,NULL,12,NULL,1,NULL,1,'吴向宏：“两会”热点调查不应回避人口问题','吴向宏：“两会”热点调查不应回避人口问题','','','','我绝不否定我国的计划生育政策的功绩。事实上，计划生育是中国在过去20年里发展超过印度的重要原因。但计划生育导致的人口老化，使得中国的经济内需严重不足。抚养和教育下一代是人类最重要的经济活动之一，晚育、少育的家庭会趋向过度储蓄；倒金字塔的人口结构大大加剧人们对养老等社会保障体系的担忧，从而增加储蓄倾向。','','网易','','2009-03-10 18:37:21','2009-03-10 18:37:21','2009-03-10 18:37:21','2009-03-10 18:37:21',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,1,1,5,6,NULL,NULL,14,NULL,1,NULL,1,'《二十四城记》三天破百万 国内“赚外快”','《二十四城记》三天破百万 国内“赚外快”','','','','贾樟柯执导的《二十四城记》已经向30多个国家和地区售出了发行权，国内票房只是“赚外快”，但是该片上映后三天依然取得了突破百万的不俗票房，创下贾樟柯电影国内票房的纪录。','','网易','','2009-03-10 18:38:04','2009-03-10 18:38:04','2009-03-10 18:38:04','2009-03-10 18:38:04',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,1,1,1,37,5,NULL,14,NULL,1,NULL,1,'《团长》“豆饼”表情超萌 被称“小王宝强”','《团长》“豆饼”表情超萌 被称“小王宝强”','','','','随着《团长》目前热播，在网易曝光的独家剧照中，有一个扛着枪筒、满脸黑灰、哭丧着脸的小男孩引起了网友关注，他一系列超“萌”的表情让他一夜蹿红。','','网易','','2009-03-10 18:39:02','2009-03-10 18:39:02','2009-03-10 18:39:02','2009-03-10 18:39:02',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,1,1,1,8,NULL,NULL,15,NULL,1,NULL,1,'孙楠《你对我的好》讲述伟大的母爱感动人心','孙楠《你对我的好》','','','','内地流行歌坛“一哥”孙楠，推出2009年感恩贺岁EP《节日礼物》。其中包括新专辑一首主打歌曲《你对我的好》，该歌曲在中央电视台2009年春节元宵联欢晚会播出后受到广大观众的一致热评。','','网易','','2009-03-10 18:39:47','2009-03-10 18:39:47','2009-03-10 18:39:47','2009-03-10 18:39:47',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,1,1,1,NULL,7,NULL,15,NULL,1,NULL,1,'金钟国《幸福病》MV中可能加入舞蹈元素','金钟国《幸福病》MV中可能加入舞蹈元素','','','','5日，金钟国在大型音乐网站上公开了自己的最新单曲《幸福病》。这首表现温馨浪漫爱情的新歌，一经推出就在各大音乐电台成为了热门话题。','','网易','','2009-03-10 18:40:18','2009-03-10 18:40:18','2009-03-10 18:40:18','2009-03-10 18:40:18',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,1,1,1,10,NULL,NULL,16,NULL,1,NULL,1,'三大角度谨慎把握短线波段机会','三大角度谨慎把握短线波段机会','','','','大盘在60-120日均线附近，也就是2011-2053点附近仍有较强的支撑。如果大盘运行到这一区域，投资者则可考虑逢低吸纳。','','中国证券报','','2009-03-10 18:40:52','2009-03-10 18:40:52','2009-03-10 18:40:52','2009-03-10 18:40:52',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',2,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,1,1,1,NULL,9,NULL,16,NULL,1,NULL,1,'证监会：发行改革强化买方约束力 重视小股民','证监会：发行改革强化买方约束力 重视小股民','','','','朱从玖说，此次发行体制改革将在风险明晰的情况下兼顾各方利益，尤其是小投资人的利益。','','新华网','','2009-03-10 18:41:29','2009-03-10 18:41:29','2009-03-10 18:41:29','2009-03-10 18:41:29',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,1,1,1,12,NULL,NULL,17,NULL,1,NULL,1,'首只可分离交易型基金获批 瑞福进取添兄弟','首只可分离交易型基金获批 瑞福进取添兄弟','','','','该创新基金最大的特点在于，投资者认购的基金在基金合同生效后将自动分成两类份额，两类份额分别在深圳证券交易所采用不同交易代码上市交易，一类份额在三年封闭期间具有相对稳定的收益，另一类份额在三年封闭期间享有杠杆收益，并同时承担相应风险。','','新华网','','2009-03-10 18:42:03','2009-03-10 18:42:03','2009-03-10 18:42:03','2009-03-10 18:42:03',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,1,1,1,NULL,11,NULL,17,NULL,1,NULL,1,'偏股型基金规模比四季度增长四五倍','偏股型基金规模比四季度增长四五倍','','','','业内人士表示，基金的首发规模历来与A股市场的冷暖密切相关。','','上海证券报','','2009-03-10 18:42:40','2009-03-10 18:42:40','2009-03-10 18:42:40','2009-03-10 18:42:40',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,1,1,1,14,NULL,NULL,18,NULL,1,NULL,1,'家居卖场提前打响3·15促销大战','家居卖场提前打响3·15促销大战','','','','阳春三月，春潮涌动。山城家居卖场在一片“回暖”声中，频频掀起促销狂潮。日前，记者在采访中发现，各家居卖场、装饰公司和建材商纷纷拿出自己的让利促销“杀手锏”，给持币观望的业主们不断带来意外惊喜。','','上海证券报','','2009-03-10 18:43:16','2009-03-10 18:43:16','2009-03-10 18:43:16','2009-03-10 18:43:16',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,1,1,1,NULL,13,NULL,18,NULL,1,NULL,1,'花小钱为家换新装之500-1000元换装方案','花小钱为家换新装之500-1000元换装方案','','','','“花钱如炒菜,要恰到好处。盐少了,菜就会淡而无味;盐多了,苦咸难咽。”这是比尔·盖茨的名言,世界首富居然也会像个家庭主妇一般精打细算,而像你我一样平凡的老百姓,又有什么理由大手大脚?尤其在金融危机全球性蔓延、在全民都提倡做“省钱达人”的时代?','','南方都市报','','2009-03-10 18:43:52','2009-03-10 18:43:52','2009-03-10 18:43:52','2009-03-10 18:43:52',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',2,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,1,1,1,16,NULL,NULL,19,NULL,1,NULL,1,'双眼皮手术失败拯救计划','双眼皮手术失败拯救计划','','','','“巧笑倩兮，美目盼兮”，眼睛一向被人们描绘为“心灵的窗户”，每个人都希望拥有一双美丽迷人的“心灵窗户”，双眼皮手术也因此成为最常见的美容外科手术之一。但是，任何手术都不可能做到万无一失，这时候，我们该怎么办呢？请听听专家的意见。','','39健康网社区　','','2009-03-10 18:44:30','2009-03-10 18:44:30','2009-03-10 18:44:30','2009-03-10 18:44:30',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,1,1,1,NULL,15,NULL,19,NULL,1,NULL,1,'代表柏广新：建议禁止饮用水添加食品添加剂','代表柏广新：建议禁止饮用水添加食品添加剂','','','','水只为解渴的心理状态，安全健康饮用水已成为亟待解决的国民饮水安全问题。我们强烈建议国家通过立法或行政规范的形式，禁止在饮用水中添加食品添加剂。','','39健康网社区　','','2009-03-10 18:45:03','2009-03-10 18:45:03','2009-03-10 18:45:03','2009-03-10 18:45:03',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,1,1,1,18,NULL,NULL,20,NULL,1,NULL,1,'SLAM名人堂预测：姚明科比铁定入选 麦蒂或出局','SLAM名人堂预测：姚明科比铁定入选 麦蒂或出局','','','','美国著名篮球杂志《SLAM》近日进行了一个名人堂球员预测，火箭队的姚明和巴蒂尔被归在铁定入选的行列，而麦蒂则被归入可能出局的名单','','网易体育','','2009-03-10 18:45:56','2009-03-10 18:45:56','2009-03-10 18:45:56','2009-03-10 18:45:56',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,1,1,1,NULL,17,NULL,20,NULL,1,NULL,1,'姚明两拒火箭1亿美元合同 2010年何处将是家园?','姚明拒亿元合同想离开？','','','','近期，有消息称姚明已经两次拒绝了火箭队提出的超过1亿美元的合同。2010年夏天，姚明究竟去向何处，成为球迷们关注的热点。','','大众网(济南)','','2009-03-10 18:46:51','2009-03-10 18:46:51','2009-03-10 18:46:51','2009-03-10 18:46:51',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,1,1,1,20,NULL,NULL,21,NULL,1,NULL,1,'CBA最惨烈比赛堪比奥本宫 辽宁最后仅剩5名后卫','CBA最惨烈比赛堪比奥本宫 辽宁最后仅剩5名后卫','','','','正如中国篮球前任掌门人李元伟所说，CBA联赛已渐渐成为中国体育的第一联赛。不仅是因为比赛精彩，更因为新闻不断。8日晚，CBA第45轮山西对阵辽宁的比赛中，双方在比赛中竟然有79次犯规，共计罚球98次，7名球员先后被罚出场，创下CBA的又一个新纪录。 ','','大众网(济南)','','2009-03-10 18:47:49','2009-03-10 18:47:49','2009-03-10 18:47:49','2009-03-10 18:47:49',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,1,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,1,1,1,NULL,19,NULL,21,NULL,1,NULL,1,'中国基里连科强势冲击NBA','中国基里连科强势冲击NBA','','','','在昨晚进行的广东对阵山西中，一名纽约时报的记者现身广东主场，对于广东的每一位球员他几乎如数家珍，在看比赛的过程中，他惊叹广东拥有太多有潜力的球员了','','大众网(济南)','','2009-03-10 18:48:26','2009-03-10 18:48:26','2009-03-10 18:48:26','2009-03-10 18:48:26',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,1,1,1,22,NULL,NULL,22,NULL,1,NULL,1,'产业链已具规模 山寨本将席卷全球','产业链已具规模 山寨本将席卷全球','','','','山寨笔记本市场已经呈现出惊人的成熟规模。不但国内市场大受欢迎，还大有席卷全球之势。山寨笔记本不但已经进入了越南等东南亚市场，而且成功杀入了欧洲市场。我们完全有理由相信，09年，中国山寨笔记本将风靡全球。','','网易数码','','2009-03-10 18:49:11','2009-03-10 18:49:11','2009-03-10 18:49:11','2009-03-10 18:49:11',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,1,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,1,1,1,NULL,21,NULL,22,NULL,1,NULL,1,'史无前例大降价 华帝油烟机爆降千元','史无前例大降价 华帝油烟机爆降千元','','','','近日在大中卖场了解到华帝旗下一款欧式脱排油烟机价格有之前4380元的价格降至降至现在的3397元，性价比提升了不少，这款产品你采用了全金属材质，对于油污清洁问题来说比较方便。','','网易数码','','2009-03-10 18:49:46','2009-03-10 18:49:46','2009-03-10 18:49:46','2009-03-10 18:49:46',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,1,1,1,24,NULL,NULL,23,NULL,1,NULL,1,'Intel新45nm奔腾双核E3000系列曝光','Intel新45nm奔腾双核E3000系列曝光','','','','日前在Intel官方网站的处理器Spec编码查询系统中，出现了一款从未谋面的新桌面处理器，型号为奔腾双核E3200。从经验来看，新型号在这里出现往往代表它即将发布上市。','','驱动之家','','2009-03-10 18:50:31','2009-03-10 18:50:31','2009-03-10 18:50:31','2009-03-10 18:50:31',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,1,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,1,1,1,NULL,23,NULL,23,NULL,1,NULL,1,'三低环保特色 三星1.5TB硬盘正式出货','三低环保特色 三星1.5TB硬盘正式出货','','','','日前，韩国三星电子宣布单碟500GB的三碟装1.5TB容量硬盘正式开始出货。','','中关村在线','','2009-03-10 18:51:11','2009-03-10 18:51:11','2009-03-10 18:51:11','2009-03-10 18:51:11',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,1,1,1,26,NULL,NULL,8,NULL,1,NULL,1,'挑战诺基亚 山寨手机拿下市场半壁江山','挑战诺基亚 山寨手机拿下市场半壁江山','','','','“早上爬起来,用山寨的牙膏、喝山寨的牛奶,出门坐山寨的车……”上海代表团第二小组审议会场,郑杰代表摘自手机短信的一串顺口溜,引来众多关注. 在“山寨现象”蔓延的今天,究竟怎么分析、判断?郑杰代表认为,在加强行业政策监管的同时,还应积极引导,吸引这些“山寨产品”的中小企业、家庭作坊通过自主创新,到台面上来竞争.据不完全统计,2007年,国内山寨手机销量1.51亿部,这个数量和所有品牌手机销售数量相当,可谓是打下手机市场的“半壁江山 ”.山寨手机的兴起,对于国产手机品牌的冲击极大,国产品牌波导预计亏损6亿元.','','南昌手机报价网','','2009-03-10 18:51:55','2009-03-10 18:51:55','2009-03-10 18:51:55','2009-03-10 18:51:55',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,1,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,1,1,1,NULL,25,NULL,8,NULL,1,NULL,1,'联通制3G快速起跑战略 三领先策略出炉','联通制3G快速起跑战略 三领先策略出炉','','','','聚精会神搞建设，一心一意抓发展。2009年中国联通的主题既不是调整，也不是改革，而是全心全意埋头苦干。','','南昌手机报价网','','2009-03-10 18:52:37','2009-03-10 18:52:37','2009-03-10 18:52:37','2009-03-10 18:52:37',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,1,1,1,28,NULL,NULL,9,NULL,1,NULL,1,'应需而生 长安铃木全新天语SX4突破升级','应需而生 长安铃木全新天语SX4突破升级','','','','应需而生 长安铃木全新天语SX4突破升级','','网易汽车频道','','2009-03-10 18:53:33','2009-03-10 18:53:33','2009-03-10 18:53:33','2009-03-10 18:53:33',NULL,2,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',2,'',0,0,0,'','',0,1,0,0,1,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,1,1,1,NULL,27,NULL,9,NULL,1,NULL,1,'节能环保乐享高效 长安铃木力推绿色驾驶','节能环保乐享高效 长安铃木力推绿色驾驶','','','','随着成品油价税费改革征求意见稿的正式发布，有关燃油税近期即将实行一事最终有了定论，历经多年悬而未决的燃油税征收问题自此画上句点。在明年正式开征燃油税的情况下，国内汽车消费结构将逐步得到改变，那些节能环保型汽车产品，尤其是小排量汽车将在燃油税政策的影响下获得更多市场青睐','','网易汽车频道','','2009-03-10 18:54:11','2009-03-10 18:54:11','2009-03-10 18:54:11','2009-03-10 18:54:11',NULL,3,1,1,1,1,1,'2010-12-08','','http://localhost:8080',1,'',0,0,0,'','',0,1,0,0,1,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,1,1,2,30,NULL,NULL,13,NULL,1,NULL,1,'两会上靓丽的礼仪小姐','两会上靓丽的礼仪小姐','','/article/image/2009_1/3_10/bbuhfs4h1jff.jpg','','服务两会的礼仪小姐在自己的岗位上尽职尽责，她们靓丽的衣服和灿烂的笑容，成为大会堂前和天安门广场上一道道靓丽的风景线。','','新华网','','2009-03-10 19:01:05','2009-03-10 19:01:05','2009-03-10 19:01:05','2009-03-10 19:01:05',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',1,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,1,1,2,31,29,NULL,13,NULL,1,NULL,1,'施瓦辛格为09健美大赛冠军颁奖','阿诺为健美小姐颁奖','','/article/image/2009_1/3_10/y2rvfs4h3bt4.jpg','','近日，国际健美小姐大赛在美国俄亥俄州哥伦布市举行。加州州长施瓦辛格为冠军Iris Kyle亲自颁奖。3月7日，Arnold Classic 2009健美先生大赛在该市决出冠军，施瓦辛格为冠军格林奇亲自颁奖。该比赛就是以施瓦辛格名字命名的。','','中新网','','2009-03-10 19:02:24','2009-03-10 19:02:24','2009-03-10 19:02:24','2009-03-10 19:02:24',NULL,1,1,1,1,1,1,'2010-12-03','','http://localhost:8080',1,'',0,0,0,'','',1,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,1,1,3,32,30,NULL,13,NULL,1,NULL,1,'1千奥运缶拍出5千万 身价大增46倍','千只奥运缶拍出5244.7万天','','/article/image/2009_1/3_10/urmmfs4h4kcv.jpg','','20分钟，上百次出价，昨日举行的奥运缶拍卖中，第一个打包了10面缶的标的，最终以70.6万元成交，是起拍价（1.3万元）的54倍多。昨天，53个标的共1000面缶，以总价5244.7万元被52个买家竞得。','','京华时报','','2009-03-10 19:03:21','2009-03-10 19:03:21','2009-03-10 19:03:21','2009-03-10 19:03:21',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',1,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,1,1,3,33,31,NULL,13,NULL,1,NULL,1,'美丽在工作中绽放','美丽在工作中绽放','','/article/image/2009_1/3_10/fwozfs4h5t1t.jpg','','美丽在工作中绽放','','新华网','','2009-03-10 19:04:20','2009-03-10 19:04:20','2009-03-10 19:04:20','2009-03-10 19:04:20',NULL,2,1,1,2,2,2,'2010-12-08','','http://localhost:8080',1,'',0,0,0,'','',1,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,1,1,2,34,32,NULL,13,NULL,1,NULL,1,'厦门：石头打造摩托车','石头打造摩托车','','/article/image/2009_1/3_10/l27tfs4h7g12.jpg','','3月8日，厦门国际会展中心举行的国际石材展上，一辆用花岗岩雕刻成的“摩托车”，引来许多观展外商的惊叹。该“摩托车”为花岗岩雕刻而成，重达数千斤，车身和轮胎都是按摩托车的比例打造。','','CFP','','2009-03-10 19:05:35','2009-03-10 19:05:35','2009-03-10 19:05:35','2009-03-10 19:05:35',NULL,1,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',1,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,1,1,2,NULL,33,NULL,13,NULL,1,NULL,1,'汶川人拍摄的震后影像','汶川人拍摄的震后影像','','/article/image/2009_1/3_10/5kb8fs4h8pnf.jpg','','在奥运到来的时刻，中国人真正的让世人看到了我们的团结，我们的力量，我们的强大！','','余志芳','','2009-03-10 19:06:35','2009-03-10 19:06:35','2009-03-10 19:06:35','2009-03-10 19:06:35',NULL,2,2,2,2,2,2,'2010-12-02','','http://localhost:8080',1,'',0,0,0,'','',1,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,1,1,3,36,2,NULL,11,NULL,1,NULL,1,'“和平-09”联合军演进入实兵演练阶段','“和平-09”联合军演进入实兵演练阶段','','/article/image/2009_1/3_10/xahpfs4hai3b.jpg','','“和平-09”海上多国联合军事演习9日进入海上实兵演练阶段。在今后4天里，包括中国海军“广州”号驱逐舰在内的约20艘军舰，将在巴南部卡拉奇港附近的阿拉伯海举行多个课目的联合演练。其中，海上联合搜救演练由中方指挥。','','新华网','','2009-03-10 19:07:57','2009-03-10 19:07:57','2009-03-10 19:07:57','2009-03-10 19:07:57',NULL,2,2,2,2,2,2,'2010-12-08','','http://localhost:8080',1,'',0,0,0,'','',1,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,1,1,3,NULL,35,NULL,11,NULL,1,NULL,1,'非洲百名打工者挤车顶返乡 场面令人瞠目','非洲百人挤车顶返乡','','/article/image/2009_1/3_10/yawhfs4hckfy.jpg','','约百名左右的非洲外出打工者挤在堆满行李的货车顶部，冒着撒哈拉沙漠的高温，开始了返乡的旅途。','','中新网','','2009-03-10 19:09:34','2009-03-10 19:09:34','2009-03-10 19:09:34','2009-03-10 19:09:34',NULL,2,2,2,2,2,2,'2010-12-08','','http://localhost:8080',1,'',0,0,0,'','',1,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,1,1,1,38,6,NULL,14,NULL,1,NULL,1,'毛阿敏自荐演孔子母亲 濮存昕舌战死磕胡玫','毛阿敏自荐演孔子母亲 濮存昕舌战死磕胡玫','','','','据了解，自《孔子》筹备以来，自荐出演该片当绿叶的演员不少，毛阿敏曾演孔子母亲。','','华商网','','2009-03-10 19:10:46','2009-03-10 19:10:46','2009-03-10 19:10:46','2009-03-10 19:10:46',NULL,0,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,1,1,1,NULL,37,NULL,14,NULL,1,NULL,1,'“三德子”赵亮本月27日迎娶模特新娘','“三德子”赵亮本月27日迎娶模特新娘','','','','昨晚（9日晚），川台《幸福火巴耳朵》剧组的马先生透露笑星赵亮将于3月27日在成都某酒店与模特媳妇举行婚庆大典。得知赵亮终于要成婚，张国立、邓婕等明星几天前便通过DV道贺。','','四川在线','','2009-03-10 19:11:30','2009-03-10 19:11:30','2009-03-10 19:11:30','2009-03-10 19:11:30',NULL,1,0,0,0,0,0,'2009-03-10','','http://www.ponyjava.com:8080/jeecms',1,'',0,0,0,'','',0,1,0,0,0,1,0,0,'','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,1,1,2,40,NULL,NULL,28,NULL,1,NULL,1,'模板-36','','','/article/image/2010_4/12_8/q6p3ghf01qel.jpg','','','','','','2010-12-07 20:44:31','2010-12-07 00:00:00','2010-12-07 20:44:31','2010-12-08 00:23:20',NULL,60,10,60,60,60,60,'2010-12-10','','http://localhost:8080',1,'',0,0,0,'','',1,1,0,0,0,1,0,0,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,1,1,2,41,39,NULL,28,NULL,1,NULL,1,'模板-35','','','/article/image/2010_4/12_8/pqo6ghf00m42.jpg','','','','','','2010-12-07 20:48:05','2010-12-07 00:00:00','2010-12-07 20:48:05','2010-12-08 00:22:30',NULL,4,1,4,4,4,4,'2010-12-10','','http://localhost:8080',1,'',0,0,0,'','',1,1,0,0,0,1,0,0,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,1,1,2,42,40,NULL,28,NULL,1,NULL,1,'模板-34','','','/article/image/2010_4/12_8/q5xfghezyb17.jpg','','','','','','2010-12-08 00:20:46','2010-12-08 00:00:00','2010-12-08 00:20:46','2010-12-08 00:20:57',NULL,5,5,5,5,5,5,'2010-12-08','','http://localhost:8080',1,'',0,0,0,'','',1,1,0,0,0,1,0,0,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,1,1,2,NULL,41,NULL,28,NULL,1,NULL,1,'模板-39','','','/article/image/2010_4/12_8/0ak4ghf1bw79.jpg','','','','','','2010-12-08 00:59:16','2010-12-08 00:00:00','2010-12-08 00:59:16','2010-12-08 15:26:32',NULL,8,8,8,8,8,8,'2010-12-08','','http://localhost:8080',1,'',0,0,0,'','',1,1,0,0,0,1,0,0,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,1,1,3,44,42,NULL,29,NULL,1,1,1,'Red PU and PVC Casters','','','/article/image/2010_4/12_8/gv06ghfzokha.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-08 16:55:50','2010-12-08 00:00:00','2010-12-08 16:55:50','2010-12-08 17:49:32','2010-12-08 17:40:27',10,10,10,10,10,10,'2010-12-08','','http://localhost:8080',1,NULL,0,0,0,'',NULL,1,1,0,0,0,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,1,1,3,NULL,43,NULL,29,NULL,1,NULL,1,'PU and PVC Casters swivel with brake','','','/article/image/2010_4/12_8/xf4wghg1m564.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-08 17:55:06','2010-12-08 00:00:00','2010-12-08 17:55:06','2010-12-08 17:55:48',NULL,1,1,1,1,1,1,'2010-12-08','','http://localhost:8080',1,NULL,0,0,0,'',NULL,1,1,0,0,0,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `arti_article_attachment`
--

CREATE TABLE `arti_article_attachment` (
  `ARTICLE_ID` bigint(20) NOT NULL,
  `ATTACHMENT_ID` bigint(20) NOT NULL,
  PRIMARY KEY (`ARTICLE_ID`,`ATTACHMENT_ID`),
  KEY `FK_ARTI_ARTICLE_ATTACHMENT2` (`ATTACHMENT_ID`),
  CONSTRAINT `FK_ARTI_ARTICLE_ATTACHMENT` FOREIGN KEY (`ARTICLE_ID`) REFERENCES `arti_article` (`ARTICLE_ID`),
  CONSTRAINT `FK_ARTI_ARTICLE_ATTACHMENT2` FOREIGN KEY (`ATTACHMENT_ID`) REFERENCES `core_attachment` (`ATTACHMENT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `arti_article_attachment`
--

INSERT INTO `arti_article_attachment` VALUES (29,1),(30,2),(31,3),(32,4),(33,5),(34,6),(35,7),(36,8),(41,17),(41,18),(40,19),(40,20),(39,21),(39,22),(42,23),(42,24),(43,26),(44,27);

--
-- Table structure for table `auxi_config`
--

CREATE TABLE `auxi_config` (
  `CONFIG_ID` bigint(20) NOT NULL,
  `MSG_NEED_CHECK` tinyint(1) DEFAULT '0' COMMENT '留言板是否需要审核',
  `MSG_IS_OPEN` tinyint(1) DEFAULT '1' COMMENT '留言板是否开放',
  `MSG_ANONYMITY` varchar(20) DEFAULT '匿名网友' COMMENT '留言板匿名网友名称',
  `MSG_MAX_SIZE` int(11) DEFAULT '16384' COMMENT '留言板留言大小(字节)',
  PRIMARY KEY (`CONFIG_ID`),
  CONSTRAINT `FK_AUXICONFIG_WEBSITE` FOREIGN KEY (`CONFIG_ID`) REFERENCES `core_website` (`WEBSITE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COMMENT='辅助系统配置表';

--
-- Dumping data for table `auxi_config`
--

INSERT INTO `auxi_config` VALUES (1,0,1,'匿名网友',16384);

--
-- Table structure for table `auxi_msg`
--

CREATE TABLE `auxi_msg` (
  `MSG_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `ADMIN_ID` bigint(20) DEFAULT NULL,
  `MSGCTG_ID` bigint(20) NOT NULL,
  `WEBSITE_ID` bigint(20) NOT NULL,
  `MEMBER_ID` bigint(20) DEFAULT NULL,
  `CONFIG_ID` bigint(20) NOT NULL,
  `TITLE` varchar(200) DEFAULT NULL COMMENT '留言标题',
  `CONTENT_MEMBER` longtext COMMENT '留言内容',
  `CONTENT_ADMIN` longtext COMMENT '回复内容',
  `EMAIL` varchar(100) DEFAULT NULL COMMENT '电子邮箱',
  `PHONE` varchar(100) DEFAULT NULL COMMENT '联系电话',
  `QQ` varchar(50) DEFAULT NULL COMMENT 'QQ',
  `IP` varchar(20) DEFAULT NULL COMMENT '留言IP',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '留言时间',
  `REPLY_TIME` datetime DEFAULT NULL COMMENT '回复时间',
  `IS_CHECK` tinyint(1) NOT NULL COMMENT '是否审核',
  `IS_RECOMMEND` tinyint(1) NOT NULL COMMENT '是否推荐',
  `IS_DISABLED` tinyint(1) NOT NULL COMMENT '是否禁用',
  PRIMARY KEY (`MSG_ID`),
  KEY `FK_AMSG_ADMIN` (`ADMIN_ID`),
  KEY `FK_AMSG_MEMBER` (`MEMBER_ID`),
  KEY `FK_AMSG_MSGCTG` (`MSGCTG_ID`),
  KEY `FK_AMSG_WEBSITE` (`WEBSITE_ID`),
  KEY `FK_AUXIMSG_CONFIG` (`CONFIG_ID`),
  CONSTRAINT `FK_AMSG_ADMIN` FOREIGN KEY (`ADMIN_ID`) REFERENCES `core_admin` (`ADMIN_ID`),
  CONSTRAINT `FK_AMSG_MEMBER` FOREIGN KEY (`MEMBER_ID`) REFERENCES `core_member` (`MEMBER_ID`),
  CONSTRAINT `FK_AMSG_MSGCTG` FOREIGN KEY (`MSGCTG_ID`) REFERENCES `auxi_msg_ctg` (`MSGCTG_ID`),
  CONSTRAINT `FK_AMSG_WEBSITE` FOREIGN KEY (`WEBSITE_ID`) REFERENCES `core_website` (`WEBSITE_ID`),
  CONSTRAINT `FK_AUXIMSG_CONFIG` FOREIGN KEY (`CONFIG_ID`) REFERENCES `auxi_config` (`CONFIG_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gbk COMMENT='留言板留言';

--
-- Dumping data for table `auxi_msg`
--

INSERT INTO `auxi_msg` VALUES (1,1,1,1,1,1,'JEECMS v2.4&#29256;&#20160;&#20040;&#26102;&#20505;&#21457;&#24067;&#65311;','请问JEECMS&nbsp;v2.4版什么时候发布？','JEECMS&nbsp;v2.4版定于2010年1月15日上午10点发布，敬请关注！','','','','127.0.0.1','2010-01-15 10:57:44','2010-01-15 10:58:14',0,0,0),(2,1,1,1,1,1,'JEECMS v2.4&#29256;&#26032;&#22686;&#20102;&#20160;&#20040;&#21151;&#33021;&#21602;?','请问JEECMS&nbsp;v2.4版新增了什么功能?','JEECMS&nbsp;v2.4版新增了以下功能：\r<br/>1、专题&nbsp;(应网友要求开发)&nbsp;\r<br/>2、全文检索&nbsp;(应网友要求开发)&nbsp;\r<br/>3、强化自定义标签功能(应网友要求开发)&nbsp;\r<br/>4、下载频道&nbsp;\r<br/>5、自动生成子站点、模板、栏目&nbsp;\r<br/>6、删除子站点&nbsp;\r<br/>7、整站（主站与子站点）搜索&nbsp;','','','','127.0.0.1','2010-01-15 10:59:05','2010-01-15 11:00:15',0,0,0),(3,NULL,1,1,1,1,'dddddd','dddddd',NULL,NULL,NULL,NULL,'127.0.0.1','2010-12-09 02:02:40',NULL,0,0,0),(4,NULL,1,1,1,1,'ddddd','ddddd',NULL,NULL,NULL,NULL,'127.0.0.1','2010-12-09 02:16:26',NULL,0,0,0),(5,NULL,1,1,1,1,'where can i get to you','as&nbsp;the&nbsp;title',NULL,NULL,NULL,NULL,'127.0.0.1','2010-12-09 15:10:20',NULL,0,0,0);

--
-- Table structure for table `auxi_msg_ctg`
--

CREATE TABLE `auxi_msg_ctg` (
  `MSGCTG_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `WEBSITE_ID` bigint(20) NOT NULL,
  `NAME` varchar(50) DEFAULT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`MSGCTG_ID`),
  KEY `FK_AMSGCTG_WEBSITE` (`WEBSITE_ID`),
  CONSTRAINT `FK_AMSGCTG_WEBSITE` FOREIGN KEY (`WEBSITE_ID`) REFERENCES `core_website` (`WEBSITE_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gbk COMMENT='留言类别';

--
-- Dumping data for table `auxi_msg_ctg`
--

INSERT INTO `auxi_msg_ctg` VALUES (1,1,'nomal message','');

--
-- Table structure for table `cms_admin`
--

CREATE TABLE `cms_admin` (
  `ADMIN_ID` bigint(20) NOT NULL,
  `WEBSITE_ID` bigint(20) NOT NULL,
  `CHECK_RIGHT` int(11) NOT NULL DEFAULT '0' COMMENT '审核级别（第几审）',
  `IS_SELF_ONLY` tinyint(1) NOT NULL DEFAULT '0' COMMENT '只允许修改自己的数据',
  PRIMARY KEY (`ADMIN_ID`),
  KEY `FK_CADMIN_WEBSITE` (`WEBSITE_ID`),
  CONSTRAINT `FK_CADMIN_ADMIN` FOREIGN KEY (`ADMIN_ID`) REFERENCES `core_admin` (`ADMIN_ID`),
  CONSTRAINT `FK_CADMIN_WEBSITE` FOREIGN KEY (`WEBSITE_ID`) REFERENCES `core_website` (`WEBSITE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COMMENT='jeecms管理员';

--
-- Dumping data for table `cms_admin`
--

INSERT INTO `cms_admin` VALUES (1,1,0,0),(2,1,0,0);

--
-- Table structure for table `cms_admin_channel`
--

CREATE TABLE `cms_admin_channel` (
  `CHANNEL_ID` bigint(20) NOT NULL,
  `ADMIN_ID` bigint(20) NOT NULL,
  PRIMARY KEY (`CHANNEL_ID`,`ADMIN_ID`),
  KEY `FK_CMS_ADMIN_CHANNEL` (`ADMIN_ID`),
  CONSTRAINT `FK_CMS_ADMIN_CHANNEL` FOREIGN KEY (`ADMIN_ID`) REFERENCES `cms_admin` (`ADMIN_ID`),
  CONSTRAINT `FK_CMS_ADMIN_CHANNEL2` FOREIGN KEY (`CHANNEL_ID`) REFERENCES `cms_channel` (`CHANNEL_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `cms_admin_channel`
--

INSERT INTO `cms_admin_channel` VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(11,1),(12,1),(13,1),(14,1),(15,1),(16,1),(17,1),(18,1),(19,1),(20,1),(21,1),(22,1),(23,1),(24,1),(25,1),(26,1),(27,1),(28,1),(29,1),(1,2),(28,2),(29,2);

--
-- Table structure for table `cms_article_topic`
--

CREATE TABLE `cms_article_topic` (
  `TOPIC_ID` bigint(20) NOT NULL,
  `ARTICLE_ID` bigint(20) NOT NULL,
  PRIMARY KEY (`TOPIC_ID`,`ARTICLE_ID`),
  KEY `FK_CMS_TOPIC_ARTICLE` (`ARTICLE_ID`),
  CONSTRAINT `FK_CMS_ARTICLE_TOPIC` FOREIGN KEY (`TOPIC_ID`) REFERENCES `cms_topic` (`TOPIC_ID`),
  CONSTRAINT `FK_CMS_TOPIC_ARTICLE` FOREIGN KEY (`ARTICLE_ID`) REFERENCES `arti_article` (`ARTICLE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `cms_article_topic`
--

INSERT INTO `cms_article_topic` VALUES (1,30),(1,31),(1,32),(1,33),(1,34),(1,35),(1,36),(1,37),(1,38);

--
-- Table structure for table `cms_channel`
--

CREATE TABLE `cms_channel` (
  `CHANNEL_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `WEBSITE_ID` bigint(20) NOT NULL,
  `CONFIG_ID` bigint(20) NOT NULL,
  `GROUP_CONTRI_ID` bigint(20) DEFAULT NULL COMMENT '投稿会员组',
  `GROUP_VISIT_ID` bigint(20) DEFAULT NULL COMMENT '访问会员组',
  `PARENT` bigint(20) DEFAULT NULL COMMENT '父栏目',
  `MODEL_ID` bigint(20) NOT NULL COMMENT '模型',
  `SYS_TYPE` varchar(20) NOT NULL COMMENT '系统类型',
  `PATH` varchar(100) DEFAULT NULL COMMENT '栏目路径',
  `LFT` int(11) NOT NULL DEFAULT '1' COMMENT '树左边',
  `RGT` int(11) NOT NULL DEFAULT '2' COMMENT '树右边',
  `NAME` varchar(100) DEFAULT NULL COMMENT '栏目名称',
  `CONTENT` longtext COMMENT '栏目内容',
  `TITLE_IMG` varchar(100) DEFAULT NULL COMMENT '栏目缩略图',
  `CONTENT_IMG` varchar(100) DEFAULT NULL COMMENT '栏目内容图',
  `TPL_INDEX` varchar(100) DEFAULT NULL COMMENT '栏目页模板路径',
  `TPL_CONTENT` varchar(100) DEFAULT NULL COMMENT '内容页模板路径',
  `TITLE` varchar(255) DEFAULT NULL COMMENT 'TITLE',
  `KEYWORDS` varchar(255) DEFAULT NULL COMMENT 'KEYWORDS',
  `DESCRIPTION` varchar(255) DEFAULT NULL COMMENT 'DESCRIPTION',
  `DOC_COUNT` int(11) NOT NULL DEFAULT '0' COMMENT '文档数量',
  `VISIT_TOTAL` bigint(20) DEFAULT NULL COMMENT '总共访问次数',
  `VISIT_TODAY` bigint(20) DEFAULT NULL COMMENT '当天访问次数',
  `STAT_DATE` date DEFAULT NULL COMMENT '统计日期',
  `OUTER_URL` varchar(255) DEFAULT NULL COMMENT '外部链接',
  `PRIORITY` int(11) NOT NULL DEFAULT '10' COMMENT '栏目排列顺序',
  `HAS_TITLEIMG` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否有标题图片',
  `HAS_CHILD` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否可以有子节点',
  `IS_DISPLAY` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否显示',
  `PARAM1` varchar(255) DEFAULT NULL COMMENT '栏目相关数据1',
  `PARAM2` varchar(255) DEFAULT NULL COMMENT '栏目相关数据2',
  `PARAM3` varchar(255) DEFAULT NULL COMMENT '栏目相关数据3',
  `DEF_STRING_1` varchar(255) DEFAULT NULL COMMENT '自定义字符串1',
  `DEF_STRING_2` varchar(255) DEFAULT NULL COMMENT '自定义字符串2',
  `DEF_STRING_3` varchar(255) DEFAULT NULL COMMENT '自定义字符串3',
  `DEF_STRING_4` varchar(255) DEFAULT NULL COMMENT '自定义字符串4',
  `DEF_STRING_5` varchar(255) DEFAULT NULL COMMENT '自定义字符串5',
  `DEF_STRING_6` varchar(255) DEFAULT NULL COMMENT '自定义字符串6',
  `DEF_STRING_7` varchar(255) DEFAULT NULL COMMENT '自定义字符串7',
  `DEF_STRING_8` varchar(255) DEFAULT NULL COMMENT '自定义字符串8',
  `DEF_STRING_9` varchar(255) DEFAULT NULL COMMENT '自定义字符串9',
  `DEF_LONG_1` bigint(20) DEFAULT NULL COMMENT '自定义长整数1',
  `DEF_LONG_2` bigint(20) DEFAULT NULL COMMENT '自定义长整数1',
  `DEF_LONG_3` bigint(20) DEFAULT NULL COMMENT '自定义长整数1',
  `DEF_LONG_4` bigint(20) DEFAULT NULL COMMENT '自定义长整数1',
  `DEF_LONG_5` bigint(20) DEFAULT NULL COMMENT '自定义长整数1',
  `DEF_MONEY1` decimal(12,2) DEFAULT NULL COMMENT '自定义金额1',
  `DEF_MONEY2` decimal(12,2) DEFAULT NULL COMMENT '自定义金额2',
  `DEF_MONEY3` decimal(12,2) DEFAULT NULL COMMENT '自定义金额3',
  `DEF_DATE1` datetime DEFAULT NULL COMMENT '自定义日期1',
  `DEF_DATE2` datetime DEFAULT NULL COMMENT '自定义日期2',
  `DEF_DATE3` datetime DEFAULT NULL COMMENT '自定义日期3',
  `DEF_BOOL1` tinyint(1) DEFAULT NULL COMMENT '自定义布尔1',
  `DEF_BOOL2` tinyint(1) DEFAULT NULL COMMENT '自定义布尔2',
  `DEF_BOOL3` tinyint(1) DEFAULT NULL COMMENT '自定义布尔3',
  PRIMARY KEY (`CHANNEL_ID`),
  KEY `CHANNEL_LFT` (`LFT`),
  KEY `CHANNEL_RGT` (`RGT`),
  KEY `CHANNEL_SYSTYPE` (`SYS_TYPE`),
  KEY `CHANNEL_PATH` (`PATH`),
  KEY `FK_CCHANNEL_CHNLMODEL` (`MODEL_ID`),
  KEY `FK_CHANNEL_PARENT` (`PARENT`),
  KEY `FK_CHANNEL_WEBSITE` (`WEBSITE_ID`),
  KEY `FK_CMSCHANNEL_CONFIG` (`CONFIG_ID`),
  KEY `FK_CMSCHNL_CONTRI_GROUP` (`GROUP_CONTRI_ID`),
  KEY `FK_CMSCHNL_VISIT_GROUP` (`GROUP_VISIT_ID`),
  CONSTRAINT `FK_CCHANNEL_CHNLMODEL` FOREIGN KEY (`MODEL_ID`) REFERENCES `cms_chnl_model` (`MODEL_ID`),
  CONSTRAINT `FK_CHANNEL_PARENT` FOREIGN KEY (`PARENT`) REFERENCES `cms_channel` (`CHANNEL_ID`),
  CONSTRAINT `FK_CHANNEL_WEBSITE` FOREIGN KEY (`WEBSITE_ID`) REFERENCES `core_website` (`WEBSITE_ID`),
  CONSTRAINT `FK_CMSCHANNEL_CONFIG` FOREIGN KEY (`CONFIG_ID`) REFERENCES `cms_config` (`CONFIG_ID`),
  CONSTRAINT `FK_CMSCHNL_CONTRI_GROUP` FOREIGN KEY (`GROUP_CONTRI_ID`) REFERENCES `cms_member_group` (`GROUP_ID`),
  CONSTRAINT `FK_CMSCHNL_VISIT_GROUP` FOREIGN KEY (`GROUP_VISIT_ID`) REFERENCES `cms_member_group` (`GROUP_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=gbk;

--
-- Dumping data for table `cms_channel`
--

INSERT INTO `cms_channel` VALUES (1,1,1,1,NULL,NULL,1,'article','main',1,50,'Home',NULL,'',NULL,'','','Home','Home','Home',0,0,0,'2009-03-10',NULL,10,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,1,1,1,NULL,1,2,'article','news',42,49,'新闻',NULL,'',NULL,'/article/default/channel_level2.html','','新闻','新闻','新闻',0,4,0,'2009-03-10',NULL,1,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,1,1,1,NULL,1,2,'article','ent',36,41,'娱乐',NULL,'',NULL,'/article/default/channel_level2.html','','娱乐','娱乐','娱乐',0,2,0,'2009-03-10','',2,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,1,1,1,NULL,1,2,'article','money',30,35,'财经',NULL,'',NULL,'/article/default/channel_level2.html','','财经','财经','财经',0,2,0,'2009-03-10','',3,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,1,1,1,NULL,1,2,'article','house',24,29,'房产',NULL,'',NULL,'/article/default/channel_level2.html','','房产','房产','房产',0,1,0,'2009-03-10','',4,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,1,1,1,NULL,1,2,'article','sports',18,23,'体育',NULL,'',NULL,'/article/default/channel_level2.html','','体育','体育','体育',0,2,0,'2009-03-10','',5,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,1,1,1,NULL,1,2,'article','tech',12,17,'科技',NULL,'',NULL,'/article/default/channel_level2.html','','科技','科技','科技',0,2,0,'2009-03-10','',6,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,1,1,1,NULL,1,2,'article','mobile',10,11,'手机',NULL,'',NULL,'','','手机','手机','手机',2,2,0,'2009-03-10','',7,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,1,1,1,NULL,1,2,'article','car',8,9,'汽车',NULL,'',NULL,'','','汽车','汽车','汽车',2,2,0,'2009-03-10','',8,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,1,1,NULL,NULL,1,3,'article','AboutUs',6,7,'About Us','','',NULL,'/article/default/alone_about.html','','About Us','About Us','About Us',0,0,0,'2009-03-10',NULL,9,0,0,1,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,1,1,1,NULL,2,2,'article','war',47,48,'军事',NULL,'',NULL,'','','军事','军事','军事',4,0,0,'2009-03-10',NULL,10,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,1,1,1,NULL,2,2,'article','review',45,46,'评论',NULL,'',NULL,'','','评论','评论','评论',2,0,0,'2009-03-10',NULL,10,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,1,1,1,NULL,2,2,'article','pic',43,44,'图片',NULL,'',NULL,'','','图片','图片','图片',6,0,0,'2009-03-10',NULL,10,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,1,1,1,NULL,3,2,'article','movie',39,40,'影视',NULL,'',NULL,'','','影视','影视','影视',4,0,0,'2009-03-10',NULL,10,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,1,1,1,NULL,3,2,'article','music',37,38,'音乐',NULL,'',NULL,'','','音乐','音乐','音乐',2,0,0,'2009-03-10',NULL,10,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,1,1,1,NULL,4,2,'article','stock',33,34,'股票',NULL,'',NULL,'','','股票','股票','股票',2,1,0,'2009-03-10',NULL,10,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,1,1,1,NULL,4,2,'article','fund',31,32,'基金',NULL,'',NULL,'','','基金','基金','基金',2,0,0,'2009-03-10',NULL,10,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,1,1,1,NULL,5,2,'article','home',27,28,'家居',NULL,'',NULL,'','','家居','家居','家居',2,0,0,'2009-03-10',NULL,10,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,1,1,1,NULL,5,2,'article','health',25,26,'健康',NULL,'',NULL,'','','健康','健康','健康',2,0,0,'2009-03-10',NULL,10,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,1,1,1,NULL,6,2,'article','nba',21,22,'NBA',NULL,'',NULL,'','','NBA','NBA','NBA',2,0,0,'2009-03-10',NULL,10,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,1,1,1,NULL,6,2,'article','cba',19,20,'CBA',NULL,'',NULL,'','','CBA','CBA','CBA',2,0,0,'2009-03-10',NULL,10,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,1,1,1,NULL,7,2,'article','digi',15,16,'数码',NULL,'',NULL,'','','数码','数码','数码',2,0,0,'2009-03-10',NULL,10,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,1,1,1,NULL,7,2,'article','computer',13,14,'电脑',NULL,'',NULL,'','','电脑','电脑','电脑',2,0,0,'2009-03-10',NULL,10,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,1,1,1,NULL,NULL,5,'download','down',1,8,'下载中心',NULL,'',NULL,'/download/default/channel_level2.html','','下载中心','下载中心','下载中心',0,0,0,'2010-01-15',NULL,10,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,1,1,1,NULL,24,5,'download','system',6,7,'系统软件',NULL,'',NULL,'','','系统软件','系统软件','系统软件',1,0,0,'2010-01-15',NULL,10,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,1,1,1,NULL,24,5,'download','netsoft',4,5,'网络工具',NULL,'',NULL,'','','网络工具','网络工具','网络工具',1,0,0,'2010-01-15',NULL,10,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,1,1,1,NULL,24,5,'download','media',2,3,'媒体工具',NULL,'',NULL,'','','媒体工具','媒体工具','媒体工具',1,0,0,'2010-01-15',NULL,10,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,1,1,1,NULL,1,2,'article','Products',4,5,'Products',NULL,'',NULL,'/article/default/channel_pic.html','','Products','Products','Products',4,0,0,'2010-12-07',NULL,10,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,1,1,NULL,NULL,1,2,'article','NewProducts',2,3,'New Products',NULL,'',NULL,'','','','','',2,0,0,'2010-12-08','',10,0,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `cms_channel_attchment`
--

CREATE TABLE `cms_channel_attchment` (
  `ATTACHMENT_ID` bigint(20) NOT NULL,
  `CHANNEL_ID` bigint(20) NOT NULL,
  PRIMARY KEY (`ATTACHMENT_ID`,`CHANNEL_ID`),
  KEY `FK_CMS_CHANNEL_ATTCHMENT2` (`CHANNEL_ID`),
  CONSTRAINT `FK_CMS_CHANNEL_ATTCHMENT` FOREIGN KEY (`ATTACHMENT_ID`) REFERENCES `core_attachment` (`ATTACHMENT_ID`),
  CONSTRAINT `FK_CMS_CHANNEL_ATTCHMENT2` FOREIGN KEY (`CHANNEL_ID`) REFERENCES `cms_channel` (`CHANNEL_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `cms_channel_attchment`
--


--
-- Table structure for table `cms_chnl_model`
--

CREATE TABLE `cms_chnl_model` (
  `MODEL_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `WEBSITE_ID` bigint(20) NOT NULL,
  `SYS_TYPE` varchar(20) DEFAULT NULL COMMENT '系统类型',
  `NAME` varchar(100) DEFAULT NULL COMMENT '模型名称',
  `SHORT_NAME` varchar(20) DEFAULT NULL COMMENT '简称',
  `TPL_PREFIX_CHANNEL` varchar(20) DEFAULT NULL COMMENT '栏目模板前缀',
  `TPL_PREFIX_CONTENT` varchar(20) DEFAULT NULL COMMENT '内容模板前缀',
  `PRIORITY` int(11) NOT NULL DEFAULT '10' COMMENT '排列顺序',
  `IS_DISPLAY` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否显示',
  `HAS_CHILD` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否可以有子栏目',
  PRIMARY KEY (`MODEL_ID`),
  KEY `FK_CHNLMODEL_WEBSITE` (`WEBSITE_ID`),
  CONSTRAINT `FK_CHNLMODEL_WEBSITE` FOREIGN KEY (`WEBSITE_ID`) REFERENCES `core_website` (`WEBSITE_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gbk COMMENT='栏目模型';

--
-- Dumping data for table `cms_chnl_model`
--

INSERT INTO `cms_chnl_model` VALUES (1,1,'','首页模型','首页','index','content',4,1,1),(2,1,'article','文章模型','文章','channel','content',1,1,1),(3,1,'','单页模型','单页','alone','',2,1,0),(4,1,'','跳转模型','跳转','','',3,1,0),(5,1,'download','下载模型','下载','channel','content',10,1,1);

--
-- Table structure for table `cms_chnl_model_item`
--

CREATE TABLE `cms_chnl_model_item` (
  `MITEM_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `MODEL_ID` bigint(20) NOT NULL,
  `MITEM_TYPE` int(11) NOT NULL DEFAULT '1' COMMENT '模型项类型',
  `NAME` varchar(100) NOT NULL COMMENT '表单名称',
  `LABEL` varchar(100) DEFAULT NULL COMMENT 'LABEL名称',
  `HELP` varchar(255) DEFAULT NULL COMMENT '帮助信息',
  `DATA_TYPE` int(11) DEFAULT NULL COMMENT '数据类型',
  `INPUT_TYPE` int(11) DEFAULT NULL COMMENT '表单类型',
  `INPUT_SIZE` int(11) DEFAULT NULL COMMENT '输入框size',
  `INPUT_WIDTH` int(11) DEFAULT NULL COMMENT 'select宽度',
  `TEXTAREA_COLS` int(11) DEFAULT NULL COMMENT '文本区列数',
  `TEXTAREA_ROWS` int(11) DEFAULT NULL COMMENT '文本区行数',
  `DEF_VALUE` varchar(255) DEFAULT NULL COMMENT '默认值',
  `OPTION_VALUE` varchar(255) DEFAULT NULL COMMENT '可选项',
  `PRIORITY` int(11) NOT NULL COMMENT '排列顺序',
  `IS_PREDEFINE` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否预定义',
  `IS_CHECKED` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否选中',
  PRIMARY KEY (`MITEM_ID`),
  KEY `FK_CHNLMODELITEM_MODEL` (`MODEL_ID`),
  CONSTRAINT `FK_CHNLMODELITEM_MODEL` FOREIGN KEY (`MODEL_ID`) REFERENCES `cms_chnl_model` (`MODEL_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=510 DEFAULT CHARSET=gbk COMMENT='栏目模型定义';

--
-- Dumping data for table `cms_chnl_model_item`
--

INSERT INTO `cms_chnl_model_item` VALUES (1,2,1,'title','title','',1,1,60,NULL,NULL,NULL,'','',4,1,1),(2,2,1,'priority','排列顺序','',1,1,12,NULL,NULL,NULL,'10','',10,1,1),(3,2,1,'keywords','keywords','',1,1,60,NULL,NULL,NULL,'','',5,1,1),(4,2,1,'description','description','',1,1,60,NULL,NULL,NULL,'','',6,1,1),(15,2,1,'tplIndex','栏目页模板','',1,1,NULL,NULL,NULL,NULL,'','',2,1,1),(16,2,1,'tplContent','内容页模板','',1,1,NULL,NULL,NULL,NULL,'','',3,1,1),(18,2,1,'paramData','自定义数据','多个栏目共享同一模板时，可以通过自定义数据实现栏目页个性化',1,1,NULL,NULL,NULL,NULL,'','',15,1,0),(43,2,1,'display','是否显示','',1,1,NULL,NULL,NULL,NULL,'','',11,1,1),(75,2,1,'path','访问路径','栏目的访问路径',1,1,NULL,NULL,NULL,NULL,'','',0,1,1),(77,2,1,'outerUrl','外部链接','',1,1,50,NULL,NULL,NULL,'','',1,1,1),(110,2,2,'origin','来源','',1,1,NULL,NULL,NULL,NULL,'','',2,1,0),(111,2,2,'shortTitle','简短标题','',1,1,NULL,NULL,NULL,NULL,'','',1,1,1),(112,2,2,'description','摘要','',1,1,NULL,NULL,NULL,NULL,'','',4,1,0),(113,2,1,'content','内容','',1,1,NULL,NULL,NULL,NULL,'','',12,1,0),(114,2,1,'titleImg','缩略图','',1,1,NULL,NULL,NULL,NULL,'','',13,1,0),(115,2,1,'contentImg','内容图','',1,1,NULL,NULL,NULL,NULL,'','',14,1,0),(116,2,1,'groupContribute','投稿控制','',1,1,NULL,NULL,NULL,NULL,'','',8,1,0),(117,2,1,'groupVisit','访问控制','',1,1,NULL,NULL,NULL,NULL,'','',7,1,0),(118,2,1,'admins','管理权限','',1,1,NULL,NULL,NULL,NULL,'','',9,1,1),(157,2,1,'defStr1','自定义字符串1','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(158,2,1,'defStr2','自定义字符串2','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(159,2,1,'defStr3','自定义字符串3','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(160,2,1,'defStr4','自定义字符串4','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(161,2,1,'defStr5','自定义字符串5','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(162,2,1,'defStr6','自定义字符串6','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(163,2,1,'defStr7','自定义字符串7','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(164,2,1,'defStr8','自定义字符串8','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(165,2,1,'defStr9','自定义字符串9','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(166,2,1,'defLong1','自定义整数1','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(167,2,1,'defLong2','自定义整数2','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(168,2,1,'defLong3','自定义整数3','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(169,2,1,'defLong4','自定义整数4','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(170,2,1,'defLong5','自定义整数5','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(171,2,1,'defMoney1','自定义金额1','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(172,2,1,'defMoney2','自定义金额2','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(173,2,1,'defMoney3','自定义金额3','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(174,2,1,'defDate1','自定义日期1','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(175,2,1,'defDate2','自定义日期2','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(176,2,1,'defDate3','自定义日期3','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(177,2,1,'defBool1','自定义布尔1','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(178,2,1,'defBool2','自定义布尔2','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(179,2,1,'defBool3','自定义布尔3','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(180,2,2,'tags','Tag标签','',1,1,NULL,NULL,NULL,NULL,'','',5,1,0),(181,2,2,'relatedIds','相关文章','',1,1,NULL,NULL,NULL,NULL,'','',6,1,0),(182,2,2,'topLevel','固顶级别','',1,1,NULL,NULL,NULL,NULL,'','',7,1,0),(183,2,2,'draft','是否草稿','',1,1,NULL,NULL,NULL,NULL,'','',8,1,0),(184,2,2,'content','内容','',1,1,NULL,NULL,NULL,NULL,'','',9,1,1),(185,2,2,'titleImg','缩略图','',1,1,NULL,NULL,NULL,NULL,'','',10,1,1),(186,2,2,'contentImg','内容图','',1,1,NULL,NULL,NULL,NULL,'','',11,1,0),(187,2,2,'releaseDate','发布时间','',1,1,NULL,NULL,NULL,NULL,'','',12,1,1),(188,2,2,'paramData','自定义数据','多篇文章共享同一模板时，可以通过自定义数据实现内容页个性化',1,1,NULL,NULL,NULL,NULL,'','',13,1,0),(189,2,2,'defStr1','自定义字符串1','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(190,2,2,'defStr2','自定义字符串2','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(191,2,2,'defStr3','自定义字符串3','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(192,2,2,'defStr4','自定义字符串4','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(193,2,2,'defStr5','自定义字符串5','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(194,2,2,'defStr6','自定义字符串6','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(195,2,2,'defStr7','自定义字符串7','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(196,2,2,'defStr8','自定义字符串8','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(197,2,2,'defStr9','自定义字符串9','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(198,2,2,'defLong1','自定义整数1','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(199,2,2,'defLong2','自定义整数2','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(200,2,2,'defLong3','自定义整数3','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(201,2,2,'defLong4','自定义整数4','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(202,2,2,'defLong5','自定义整数5','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(203,2,2,'defMoney1','自定义金额1','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(204,2,2,'defMoney2','自定义金额2','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(205,2,2,'defMoney3','自定义金额3','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(206,2,2,'defDate1','自定义日期1','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(207,2,2,'defDate2','自定义日期2','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(208,2,2,'defDate3','自定义日期3','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(209,2,2,'defBool1','自定义布尔1','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(210,2,2,'defBool2','自定义布尔2','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(211,2,2,'defBool3','自定义布尔3','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(212,3,1,'path','访问路径','栏目的访问路径',1,1,NULL,NULL,NULL,NULL,'','',0,1,1),(213,3,1,'outerUrl','外部链接','',1,1,50,NULL,NULL,NULL,'','',1,1,0),(214,3,2,'origin','来源','',1,1,NULL,NULL,NULL,NULL,'','',2,1,1),(215,3,1,'tplIndex','栏目页模板','',1,1,NULL,NULL,NULL,NULL,'','',2,1,1),(216,3,2,'shortTitle','简短标题','',1,1,NULL,NULL,NULL,NULL,'','',1,1,1),(217,3,1,'tplContent','内容页模板','',1,1,NULL,NULL,NULL,NULL,'','',3,1,1),(218,3,2,'description','摘要','',1,1,NULL,NULL,NULL,NULL,'','',3,1,1),(219,3,1,'title','title','',1,1,60,NULL,NULL,NULL,'','',4,1,1),(220,3,2,'tags','Tag标签','',1,1,NULL,NULL,NULL,NULL,'','',4,1,1),(221,3,1,'keywords','keywords','',1,1,60,NULL,NULL,NULL,'','',5,1,1),(222,3,2,'relatedIds','相关文章','',1,1,NULL,NULL,NULL,NULL,'','',5,1,1),(223,3,1,'description','description','',1,1,60,NULL,NULL,NULL,'','',6,1,1),(224,3,2,'topLevel','固顶级别','',1,1,NULL,NULL,NULL,NULL,'','',6,1,1),(225,3,1,'groupVisit','访问控制','',1,1,NULL,NULL,NULL,NULL,'','',7,1,0),(226,3,2,'draft','是否草稿','',1,1,NULL,NULL,NULL,NULL,'','',7,1,1),(227,3,1,'groupContribute','投稿控制','',1,1,NULL,NULL,NULL,NULL,'','',8,1,0),(228,3,2,'content','内容','',1,1,NULL,NULL,NULL,NULL,'','',8,1,1),(229,3,1,'admins','管理权限','',1,1,NULL,NULL,NULL,NULL,'','',9,1,0),(230,3,2,'titleImg','缩略图','',1,1,NULL,NULL,NULL,NULL,'','',9,1,1),(231,3,1,'priority','排列顺序','',1,1,12,NULL,NULL,NULL,'10','',10,1,1),(232,3,2,'contentImg','内容图','',1,1,NULL,NULL,NULL,NULL,'','',10,1,1),(233,3,1,'display','是否显示','',1,1,NULL,NULL,NULL,NULL,'','',11,1,1),(234,3,2,'releaseDate','发布时间','',1,1,NULL,NULL,NULL,NULL,'','',11,1,1),(235,3,1,'content','内容','',1,1,NULL,NULL,NULL,NULL,'','',12,1,1),(236,3,2,'paramData','栏目数据','',1,1,NULL,NULL,NULL,NULL,'','',12,1,1),(237,3,1,'titleImg','缩略图','',1,1,NULL,NULL,NULL,NULL,'','',13,1,0),(238,3,1,'contentImg','内容图','',1,1,NULL,NULL,NULL,NULL,'','',14,1,0),(239,3,1,'paramData','自定义数据','多个栏目共享同一模板时，可以通过自定义数据实现栏目页个性化',1,1,NULL,NULL,NULL,NULL,'','',15,1,1),(240,3,1,'defStr1','自定义字符串1','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(241,3,1,'defStr2','自定义字符串2','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(242,3,1,'defStr3','自定义字符串3','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(243,3,1,'defStr4','自定义字符串4','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(244,3,1,'defStr5','自定义字符串5','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(245,3,1,'defStr6','自定义字符串6','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(246,3,1,'defStr7','自定义字符串7','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(247,3,1,'defStr8','自定义字符串8','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(248,3,1,'defStr9','自定义字符串9','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(249,3,1,'defLong1','自定义整数1','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(250,3,1,'defLong2','自定义整数2','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(251,3,1,'defLong3','自定义整数3','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(252,3,1,'defLong4','自定义整数4','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(253,3,1,'defLong5','自定义整数5','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(254,3,1,'defMoney1','自定义金额1','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(255,3,1,'defMoney2','自定义金额2','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(256,3,1,'defMoney3','自定义金额3','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(257,3,1,'defDate1','自定义日期1','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(258,3,1,'defDate2','自定义日期2','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(259,3,1,'defDate3','自定义日期3','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(260,3,1,'defBool1','自定义布尔1','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(261,3,1,'defBool2','自定义布尔2','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(262,3,1,'defBool3','自定义布尔3','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(263,3,2,'defStr1','自定义字符串1','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(264,3,2,'defStr2','自定义字符串2','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(265,3,2,'defStr3','自定义字符串3','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(266,3,2,'defStr4','自定义字符串4','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(267,3,2,'defStr5','自定义字符串5','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(268,3,2,'defStr6','自定义字符串6','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(269,3,2,'defStr7','自定义字符串7','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(270,3,2,'defStr8','自定义字符串8','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(271,3,2,'defStr9','自定义字符串9','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(272,3,2,'defLong1','自定义整数1','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(273,3,2,'defLong2','自定义整数2','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(274,3,2,'defLong3','自定义整数3','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(275,3,2,'defLong4','自定义整数4','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(276,3,2,'defLong5','自定义整数5','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(277,3,2,'defMoney1','自定义金额1','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(278,3,2,'defMoney2','自定义金额2','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(279,3,2,'defMoney3','自定义金额3','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(280,3,2,'defDate1','自定义日期1','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(281,3,2,'defDate2','自定义日期2','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(282,3,2,'defDate3','自定义日期3','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(283,3,2,'defBool1','自定义布尔1','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(284,3,2,'defBool2','自定义布尔2','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(285,3,2,'defBool3','自定义布尔3','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(286,1,1,'path','访问路径','栏目的访问路径',1,1,NULL,NULL,NULL,NULL,'','',0,1,1),(287,1,1,'outerUrl','外部链接','',1,1,50,NULL,NULL,NULL,'','',1,1,0),(288,1,2,'origin','来源','',1,1,NULL,NULL,NULL,NULL,'','',2,1,1),(289,1,1,'tplIndex','栏目页模板','',1,1,NULL,NULL,NULL,NULL,'','',2,1,1),(290,1,2,'shortTitle','简短标题','',1,1,NULL,NULL,NULL,NULL,'','',1,1,1),(291,1,1,'tplContent','内容页模板','',1,1,NULL,NULL,NULL,NULL,'','',3,1,1),(292,1,2,'description','摘要','',1,1,NULL,NULL,NULL,NULL,'','',3,1,1),(293,1,1,'title','title','',1,1,60,NULL,NULL,NULL,'','',4,1,1),(294,1,2,'tags','Tag标签','',1,1,NULL,NULL,NULL,NULL,'','',4,1,1),(295,1,1,'keywords','keywords','',1,1,60,NULL,NULL,NULL,'','',5,1,1),(296,1,2,'relatedIds','相关文章','',1,1,NULL,NULL,NULL,NULL,'','',5,1,1),(297,1,1,'description','description','',1,1,60,NULL,NULL,NULL,'','',6,1,1),(298,1,2,'topLevel','固顶级别','',1,1,NULL,NULL,NULL,NULL,'','',6,1,1),(299,1,1,'groupVisit','访问控制','',1,1,NULL,NULL,NULL,NULL,'','',7,1,1),(300,1,2,'draft','是否草稿','',1,1,NULL,NULL,NULL,NULL,'','',7,1,1),(301,1,1,'groupContribute','投稿控制','',1,1,NULL,NULL,NULL,NULL,'','',8,1,1),(302,1,2,'content','内容','',1,1,NULL,NULL,NULL,NULL,'','',8,1,1),(303,1,1,'admins','管理权限','',1,1,NULL,NULL,NULL,NULL,'','',9,1,1),(304,1,2,'titleImg','缩略图','',1,1,NULL,NULL,NULL,NULL,'','',9,1,1),(305,1,1,'priority','排列顺序','',1,1,12,NULL,NULL,NULL,'10','',10,1,0),(306,1,2,'contentImg','内容图','',1,1,NULL,NULL,NULL,NULL,'','',10,1,1),(307,1,1,'display','是否显示','',1,1,NULL,NULL,NULL,NULL,'','',11,1,0),(308,1,2,'releaseDate','发布时间','',1,1,NULL,NULL,NULL,NULL,'','',11,1,1),(309,1,1,'content','内容','',1,1,NULL,NULL,NULL,NULL,'','',12,1,0),(310,1,2,'paramData','栏目数据','',1,1,NULL,NULL,NULL,NULL,'','',12,1,1),(311,1,1,'titleImg','缩略图','',1,1,NULL,NULL,NULL,NULL,'','',13,1,0),(312,1,1,'contentImg','内容图','',1,1,NULL,NULL,NULL,NULL,'','',14,1,0),(313,1,1,'paramData','自定义数据','多个栏目共享同一模板时，可以通过自定义数据实现栏目页个性化',1,1,NULL,NULL,NULL,NULL,'','',15,1,0),(314,1,1,'defStr1','自定义字符串1','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(315,1,1,'defStr2','自定义字符串2','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(316,1,1,'defStr3','自定义字符串3','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(317,1,1,'defStr4','自定义字符串4','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(318,1,1,'defStr5','自定义字符串5','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(319,1,1,'defStr6','自定义字符串6','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(320,1,1,'defStr7','自定义字符串7','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(321,1,1,'defStr8','自定义字符串8','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(322,1,1,'defStr9','自定义字符串9','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(323,1,1,'defLong1','自定义整数1','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(324,1,1,'defLong2','自定义整数2','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(325,1,1,'defLong3','自定义整数3','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(326,1,1,'defLong4','自定义整数4','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(327,1,1,'defLong5','自定义整数5','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(328,1,1,'defMoney1','自定义金额1','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(329,1,1,'defMoney2','自定义金额2','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(330,1,1,'defMoney3','自定义金额3','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(331,1,1,'defDate1','自定义日期1','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(332,1,1,'defDate2','自定义日期2','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(333,1,1,'defDate3','自定义日期3','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(334,1,1,'defBool1','自定义布尔1','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(335,1,1,'defBool2','自定义布尔2','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(336,1,1,'defBool3','自定义布尔3','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(337,1,2,'defStr1','自定义字符串1','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(338,1,2,'defStr2','自定义字符串2','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(339,1,2,'defStr3','自定义字符串3','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(340,1,2,'defStr4','自定义字符串4','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(341,1,2,'defStr5','自定义字符串5','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(342,1,2,'defStr6','自定义字符串6','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(343,1,2,'defStr7','自定义字符串7','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(344,1,2,'defStr8','自定义字符串8','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(345,1,2,'defStr9','自定义字符串9','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(346,1,2,'defLong1','自定义整数1','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(347,1,2,'defLong2','自定义整数2','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(348,1,2,'defLong3','自定义整数3','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(349,1,2,'defLong4','自定义整数4','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(350,1,2,'defLong5','自定义整数5','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(351,1,2,'defMoney1','自定义金额1','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(352,1,2,'defMoney2','自定义金额2','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(353,1,2,'defMoney3','自定义金额3','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(354,1,2,'defDate1','自定义日期1','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(355,1,2,'defDate2','自定义日期2','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(356,1,2,'defDate3','自定义日期3','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(357,1,2,'defBool1','自定义布尔1','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(358,1,2,'defBool2','自定义布尔2','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(359,1,2,'defBool3','自定义布尔3','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(360,4,1,'path','访问路径','栏目的访问路径',1,1,NULL,NULL,NULL,NULL,'','',0,1,1),(361,4,1,'outerUrl','外部链接','',1,1,50,NULL,NULL,NULL,'','',1,1,1),(362,4,2,'origin','来源','',1,1,NULL,NULL,NULL,NULL,'','',2,1,1),(363,4,1,'tplIndex','栏目页模板','',1,1,NULL,NULL,NULL,NULL,'','',2,1,0),(364,4,2,'shortTitle','简短标题','',1,1,NULL,NULL,NULL,NULL,'','',1,1,1),(365,4,1,'tplContent','内容页模板','',1,1,NULL,NULL,NULL,NULL,'','',3,1,0),(366,4,2,'description','摘要','',1,1,NULL,NULL,NULL,NULL,'','',3,1,1),(367,4,1,'title','title','',1,1,60,NULL,NULL,NULL,'','',4,1,0),(368,4,2,'tags','Tag标签','',1,1,NULL,NULL,NULL,NULL,'','',4,1,1),(369,4,1,'keywords','keywords','',1,1,60,NULL,NULL,NULL,'','',5,1,0),(370,4,2,'relatedIds','相关文章','',1,1,NULL,NULL,NULL,NULL,'','',5,1,1),(371,4,1,'description','description','',1,1,60,NULL,NULL,NULL,'','',6,1,0),(372,4,2,'topLevel','固顶级别','',1,1,NULL,NULL,NULL,NULL,'','',6,1,1),(373,4,1,'groupVisit','访问控制','',1,1,NULL,NULL,NULL,NULL,'','',7,1,0),(374,4,2,'draft','是否草稿','',1,1,NULL,NULL,NULL,NULL,'','',7,1,1),(375,4,1,'groupContribute','投稿控制','',1,1,NULL,NULL,NULL,NULL,'','',8,1,0),(376,4,2,'content','内容','',1,1,NULL,NULL,NULL,NULL,'','',8,1,1),(377,4,1,'admins','管理权限','',1,1,NULL,NULL,NULL,NULL,'','',9,1,0),(378,4,2,'titleImg','缩略图','',1,1,NULL,NULL,NULL,NULL,'','',9,1,1),(379,4,1,'priority','排列顺序','',1,1,12,NULL,NULL,NULL,'10','',10,1,1),(380,4,2,'contentImg','内容图','',1,1,NULL,NULL,NULL,NULL,'','',10,1,1),(381,4,1,'display','是否显示','',1,1,NULL,NULL,NULL,NULL,'','',11,1,1),(382,4,2,'releaseDate','发布时间','',1,1,NULL,NULL,NULL,NULL,'','',11,1,1),(383,4,1,'content','内容','',1,1,NULL,NULL,NULL,NULL,'','',12,1,0),(384,4,2,'paramData','栏目数据','',1,1,NULL,NULL,NULL,NULL,'','',12,1,1),(385,4,1,'titleImg','缩略图','',1,1,NULL,NULL,NULL,NULL,'','',13,1,0),(386,4,1,'contentImg','内容图','',1,1,NULL,NULL,NULL,NULL,'','',14,1,0),(387,4,1,'paramData','栏目数据','多个栏目共享同一模板时，可以通过栏目数据实现栏目页个性化',1,1,NULL,NULL,NULL,NULL,'','',15,1,0),(388,4,1,'defStr1','自定义字符串1','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(389,4,1,'defStr2','自定义字符串2','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(390,4,1,'defStr3','自定义字符串3','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(391,4,1,'defStr4','自定义字符串4','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(392,4,1,'defStr5','自定义字符串5','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(393,4,1,'defStr6','自定义字符串6','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(394,4,1,'defStr7','自定义字符串7','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(395,4,1,'defStr8','自定义字符串8','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(396,4,1,'defStr9','自定义字符串9','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(397,4,1,'defLong1','自定义整数1','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(398,4,1,'defLong2','自定义整数2','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(399,4,1,'defLong3','自定义整数3','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(400,4,1,'defLong4','自定义整数4','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(401,4,1,'defLong5','自定义整数5','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(402,4,1,'defMoney1','自定义金额1','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(403,4,1,'defMoney2','自定义金额2','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(404,4,1,'defMoney3','自定义金额3','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(405,4,1,'defDate1','自定义日期1','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(406,4,1,'defDate2','自定义日期2','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(407,4,1,'defDate3','自定义日期3','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(408,4,1,'defBool1','自定义布尔1','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(409,4,1,'defBool2','自定义布尔2','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(410,4,1,'defBool3','自定义布尔3','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(411,4,2,'defStr1','自定义字符串1','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(412,4,2,'defStr2','自定义字符串2','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(413,4,2,'defStr3','自定义字符串3','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(414,4,2,'defStr4','自定义字符串4','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(415,4,2,'defStr5','自定义字符串5','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(416,4,2,'defStr6','自定义字符串6','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(417,4,2,'defStr7','自定义字符串7','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(418,4,2,'defStr8','自定义字符串8','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(419,4,2,'defStr9','自定义字符串9','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(420,4,2,'defLong1','自定义整数1','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(421,4,2,'defLong2','自定义整数2','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(422,4,2,'defLong3','自定义整数3','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(423,4,2,'defLong4','自定义整数4','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(424,4,2,'defLong5','自定义整数5','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(425,4,2,'defMoney1','自定义金额1','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(426,4,2,'defMoney2','自定义金额2','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(427,4,2,'defMoney3','自定义金额3','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(428,4,2,'defDate1','自定义日期1','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(429,4,2,'defDate2','自定义日期2','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(430,4,2,'defDate3','自定义日期3','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(431,4,2,'defBool1','自定义布尔1','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(432,4,2,'defBool2','自定义布尔2','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(433,4,2,'defBool3','自定义布尔3','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(434,2,2,'author','作者','',1,1,NULL,NULL,NULL,NULL,'','',3,1,0),(435,5,1,'path','访问路径','栏目的访问路径',1,1,NULL,NULL,NULL,NULL,'','',0,1,1),(436,5,1,'outerUrl','外部链接','',1,1,50,NULL,NULL,NULL,'','',1,1,0),(437,5,2,'shortTitle','简短标题','',1,1,NULL,NULL,NULL,NULL,'','',1,1,1),(438,5,1,'tplIndex','栏目页模板','',1,1,NULL,NULL,NULL,NULL,'','',2,1,1),(439,5,2,'origin','来源','',1,1,NULL,NULL,NULL,NULL,'','',2,1,1),(440,5,1,'tplContent','内容页模板','',1,1,NULL,NULL,NULL,NULL,'','',3,1,1),(441,5,2,'author','作者','',1,1,NULL,NULL,NULL,NULL,'','',3,1,1),(442,5,1,'title','title','',1,1,60,NULL,NULL,NULL,'','',4,1,1),(443,5,2,'description','摘要','',1,1,NULL,NULL,NULL,NULL,'','',4,1,1),(444,5,1,'keywords','keywords','',1,1,60,NULL,NULL,NULL,'','',5,1,1),(445,5,2,'tags','Tag标签','',1,1,NULL,NULL,NULL,NULL,'','',5,1,1),(446,5,1,'description','description','',1,1,60,NULL,NULL,NULL,'','',6,1,1),(447,5,2,'relatedIds','相关文章','',1,1,NULL,NULL,NULL,NULL,'','',6,1,1),(449,5,2,'topLevel','固顶级别','',1,1,NULL,NULL,NULL,NULL,'','',7,1,1),(451,5,2,'draft','是否草稿','',1,1,NULL,NULL,NULL,NULL,'','',8,1,1),(452,5,1,'admins','管理权限','',1,1,NULL,NULL,NULL,NULL,'','',9,1,1),(453,5,2,'content','内容','',1,1,NULL,NULL,NULL,NULL,'','',9,1,1),(454,5,1,'priority','排列顺序','',1,1,12,NULL,NULL,NULL,'10','',10,1,1),(455,5,2,'titleImg','缩略图','',1,1,NULL,NULL,NULL,NULL,'','',10,1,1),(456,5,1,'display','是否显示','',1,1,NULL,NULL,NULL,NULL,'','',11,1,1),(457,5,2,'contentImg','内容图','',1,1,NULL,NULL,NULL,NULL,'','',11,1,1),(458,5,1,'content','内容','',1,1,NULL,NULL,NULL,NULL,'','',12,1,0),(459,5,2,'releaseDate','发布时间','',1,1,NULL,NULL,NULL,NULL,'','',12,1,1),(460,5,1,'titleImg','缩略图','',1,1,NULL,NULL,NULL,NULL,'','',13,1,0),(461,5,2,'paramData','自定义数据','多篇文章共享同一模板时，可以通过自定义数据实现内容页个性化',1,1,NULL,NULL,NULL,NULL,'','',13,1,1),(462,5,1,'contentImg','内容图','',1,1,NULL,NULL,NULL,NULL,'','',14,1,0),(463,5,1,'paramData','自定义数据','多个栏目共享同一模板时，可以通过自定义数据实现栏目页个性化',1,1,NULL,NULL,NULL,NULL,'','',15,1,0),(464,5,1,'defStr1','自定义字符串1','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(465,5,1,'defStr2','自定义字符串2','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(466,5,1,'defStr3','自定义字符串3','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(467,5,1,'defStr4','自定义字符串4','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(468,5,1,'defStr5','自定义字符串5','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(469,5,1,'defStr6','自定义字符串6','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(470,5,1,'defStr7','自定义字符串7','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(471,5,1,'defStr8','自定义字符串8','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(472,5,1,'defStr9','自定义字符串9','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(473,5,1,'defLong1','自定义整数1','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(474,5,1,'defLong2','自定义整数2','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(475,5,1,'defLong3','自定义整数3','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(476,5,1,'defLong4','自定义整数4','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(477,5,1,'defLong5','自定义整数5','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(478,5,1,'defMoney1','自定义金额1','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(479,5,1,'defMoney2','自定义金额2','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(480,5,1,'defMoney3','自定义金额3','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(481,5,1,'defDate1','自定义日期1','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(482,5,1,'defDate2','自定义日期2','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(483,5,1,'defDate3','自定义日期3','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(484,5,1,'defBool1','自定义布尔1','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(485,5,1,'defBool2','自定义布尔2','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(486,5,1,'defBool3','自定义布尔3','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(487,5,2,'defStr1','自定义字符串1','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(488,5,2,'defStr2','自定义字符串2','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(489,5,2,'defStr3','自定义字符串3','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(490,5,2,'defStr4','自定义字符串4','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(491,5,2,'defStr5','自定义字符串5','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(492,5,2,'defStr6','自定义字符串6','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(493,5,2,'defStr7','自定义字符串7','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(494,5,2,'defStr8','自定义字符串8','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(495,5,2,'defStr9','自定义字符串9','',1,1,NULL,NULL,NULL,NULL,'','',100,0,0),(496,5,2,'defLong1','自定义整数1','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(497,5,2,'defLong2','自定义整数2','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(498,5,2,'defLong3','自定义整数3','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(499,5,2,'defLong4','自定义整数4','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(500,5,2,'defLong5','自定义整数5','',2,1,NULL,NULL,NULL,NULL,'','',100,0,0),(501,5,2,'defMoney1','自定义金额1','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(502,5,2,'defMoney2','自定义金额2','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(503,5,2,'defMoney3','自定义金额3','',3,1,NULL,NULL,NULL,NULL,'','',100,0,0),(504,5,2,'defDate1','自定义日期1','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(505,5,2,'defDate2','自定义日期2','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(506,5,2,'defDate3','自定义日期3','',4,1,NULL,NULL,NULL,NULL,'','',100,0,0),(507,5,2,'defBool1','自定义布尔1','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(508,5,2,'defBool2','自定义布尔2','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0),(509,5,2,'defBool3','自定义布尔3','',5,4,NULL,NULL,NULL,NULL,'','',100,0,0);

--
-- Table structure for table `cms_comment`
--

CREATE TABLE `cms_comment` (
  `COMMENT_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `WEBSITE_ID` bigint(20) NOT NULL,
  `MEMBER_ID` bigint(20) DEFAULT NULL,
  `REF_DOC_ID` bigint(20) NOT NULL COMMENT '文档引用ID',
  `REF_DOC_TYPE` char(4) NOT NULL COMMENT '文档类型',
  `ADMIN_ID` bigint(20) DEFAULT NULL,
  `TITLE` varchar(200) DEFAULT NULL COMMENT '标题',
  `CONTENT_MEMBER` longtext COMMENT '会员评论内容',
  `CONTENT_ADMIN` longtext COMMENT '管理员回复内容',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间',
  `REPLAY_TIME` datetime DEFAULT NULL COMMENT '回复时间',
  `IP` varchar(50) DEFAULT NULL COMMENT '评论者IP',
  `IS_CHECK` tinyint(1) NOT NULL COMMENT '是否审核',
  `IS_RECOMMEND` tinyint(1) NOT NULL COMMENT '是否推荐',
  `IS_DISABLED` tinyint(1) NOT NULL COMMENT '是否禁用',
  PRIMARY KEY (`COMMENT_ID`),
  KEY `COMMENT_DOC_ID` (`REF_DOC_ID`),
  KEY `COMMENT_DOC_TYPE` (`REF_DOC_TYPE`),
  KEY `FK_CCOMMENT_ADMIN` (`ADMIN_ID`),
  KEY `FK_CCOMMENT_MEMBER` (`MEMBER_ID`),
  KEY `FK_CCOMMENT_WEBSITE` (`WEBSITE_ID`),
  CONSTRAINT `FK_CCOMMENT_ADMIN` FOREIGN KEY (`ADMIN_ID`) REFERENCES `cms_admin` (`ADMIN_ID`),
  CONSTRAINT `FK_CCOMMENT_MEMBER` FOREIGN KEY (`MEMBER_ID`) REFERENCES `core_member` (`MEMBER_ID`),
  CONSTRAINT `FK_CCOMMENT_WEBSITE` FOREIGN KEY (`WEBSITE_ID`) REFERENCES `core_website` (`WEBSITE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COMMENT='jeecms评论表';

--
-- Dumping data for table `cms_comment`
--


--
-- Table structure for table `cms_config`
--

CREATE TABLE `cms_config` (
  `CONFIG_ID` bigint(20) NOT NULL,
  `CHECK_COUNT` int(11) NOT NULL DEFAULT '0' COMMENT '内容需要审核的次数',
  `DEFAULT_SYSTEM` varchar(20) NOT NULL DEFAULT 'article' COMMENT '默认系统',
  `COMMENT_NEED_CHECK` tinyint(1) NOT NULL DEFAULT '0' COMMENT '评论是否需要审核',
  `COMMENT_NEED_LOGIN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '评论是否需要登录',
  `COMMENT_SORT` tinyint(1) NOT NULL DEFAULT '1' COMMENT '评论排序方式(0:升序,1:降序)',
  `COMMENT_MAX_LENGTH` int(11) NOT NULL DEFAULT '16384' COMMENT '评论最大字节',
  `REGISTER_STATUS` int(11) DEFAULT '1' COMMENT '注册方式(0：关闭注册；1：开放注册；2：邀请注册)',
  `REGISTER_GROUP` bigint(20) DEFAULT NULL COMMENT '默认会员组ID',
  `REGISTER_RULE` longtext COMMENT '网络服务使用协议',
  `AUTO_REGISTER` tinyint(1) DEFAULT '1' COMMENT '是否自动注册（其他系统注册后，在本系统注册）',
  `DEF_ARTICLE_MODEL` bigint(20) DEFAULT NULL COMMENT '默认文章模型',
  `DEF_DOWNLOAD_MODEL` bigint(20) DEFAULT NULL COMMENT '默认下载模型',
  `IS_CACHE_HOMEPAGE` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否缓存首页',
  `IS_CACHE_CHANNEL` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否缓存栏目页',
  PRIMARY KEY (`CONFIG_ID`),
  CONSTRAINT `FK_CMSCONFIG_WEBSITE` FOREIGN KEY (`CONFIG_ID`) REFERENCES `core_website` (`WEBSITE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COMMENT='jeecms配置表';

--
-- Dumping data for table `cms_config`
--

INSERT INTO `cms_config` VALUES (1,0,'article',0,0,1,16384,1,1,'请遵守我们的协议',1,2,NULL,0,0);

--
-- Table structure for table `cms_content_ctg`
--

CREATE TABLE `cms_content_ctg` (
  `CTTCTG_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `WEBSITE_ID` bigint(20) NOT NULL,
  `LABEL` varchar(20) NOT NULL COMMENT '标识ID',
  `NAME` varchar(50) DEFAULT NULL COMMENT '名称',
  `IMG_WIDTH` int(11) DEFAULT '139' COMMENT '标题图片宽度',
  `IMG_HEIGHT` int(11) DEFAULT '139' COMMENT '标题图片高度',
  `HAS_TITLEIMG` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否有标题图片',
  `IS_DISABLED` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否继续使用',
  PRIMARY KEY (`CTTCTG_ID`),
  KEY `FK_CTTCTG_WEBSITE` (`WEBSITE_ID`),
  CONSTRAINT `FK_CTTCTG_WEBSITE` FOREIGN KEY (`WEBSITE_ID`) REFERENCES `core_website` (`WEBSITE_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gbk COMMENT='JEECMS内容属性';

--
-- Dumping data for table `cms_content_ctg`
--

INSERT INTO `cms_content_ctg` VALUES (1,1,'1','不显示在主页',216,300,1,1),(2,1,'2','主页下方滚动',216,300,1,0),(3,1,'3','主页左侧滚动',216,300,1,0),(4,1,'4','头条',100,68,1,1),(5,1,'5','滚动',139,94,1,1);

--
-- Table structure for table `cms_member`
--

CREATE TABLE `cms_member` (
  `MEMBER_ID` bigint(20) NOT NULL,
  `WEBSITE_ID` bigint(20) NOT NULL,
  `GROUP_ID` bigint(20) NOT NULL,
  `SCORE` int(11) NOT NULL DEFAULT '0' COMMENT '积分',
  `COUPON` int(11) NOT NULL DEFAULT '0' COMMENT '点劵',
  `UPLOAD_STAT_DATE` date NOT NULL COMMENT '上传统计日期',
  `UPLOAD_SIZE` int(11) NOT NULL DEFAULT '0' COMMENT '当日上传大小',
  `UPLOAD_TOTAL_SIZE` bigint(20) NOT NULL DEFAULT '0' COMMENT '总共上传大小',
  `IS_DISABLED` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否禁用',
  PRIMARY KEY (`MEMBER_ID`),
  KEY `FK_CMEMBER_MGROUP` (`GROUP_ID`),
  KEY `FK_CMEMBER_WEBSITE` (`WEBSITE_ID`),
  CONSTRAINT `FK_CMEMBER_MEMBER` FOREIGN KEY (`MEMBER_ID`) REFERENCES `core_member` (`MEMBER_ID`),
  CONSTRAINT `FK_CMEMBER_MGROUP` FOREIGN KEY (`GROUP_ID`) REFERENCES `cms_member_group` (`GROUP_ID`),
  CONSTRAINT `FK_CMEMBER_WEBSITE` FOREIGN KEY (`WEBSITE_ID`) REFERENCES `core_website` (`WEBSITE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COMMENT='jeecms会员';

--
-- Dumping data for table `cms_member`
--

INSERT INTO `cms_member` VALUES (1,1,1,0,0,'2010-12-02',0,0,0);

--
-- Table structure for table `cms_member_group`
--

CREATE TABLE `cms_member_group` (
  `GROUP_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `WEBSITE_ID` bigint(20) NOT NULL,
  `NAME` varchar(100) DEFAULT NULL COMMENT '组名',
  `GROUP_LEVEL` int(11) NOT NULL DEFAULT '10' COMMENT '组等级（越大越高）',
  `DESCRIPTION` varchar(255) DEFAULT NULL COMMENT '描述',
  `UPLOAD_SIZE` int(11) NOT NULL DEFAULT '0' COMMENT '每天允许上传的总大小',
  PRIMARY KEY (`GROUP_ID`),
  KEY `CMSGROUP_LEVEL` (`GROUP_LEVEL`),
  KEY `FK_CMSGROUP_WEBSITE` (`WEBSITE_ID`),
  CONSTRAINT `FK_CMSGROUP_WEBSITE` FOREIGN KEY (`WEBSITE_ID`) REFERENCES `core_website` (`WEBSITE_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gbk COMMENT='jeecms用户组';

--
-- Dumping data for table `cms_member_group`
--

INSERT INTO `cms_member_group` VALUES (1,1,'普通会员',10,NULL,0);

--
-- Table structure for table `cms_recommend_group`
--

CREATE TABLE `cms_recommend_group` (
  `RGROUP_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `CHANNEL_ID` bigint(20) NOT NULL,
  `WEBSITE_ID` bigint(20) NOT NULL,
  `SYS_TYPE` char(4) NOT NULL COMMENT '系统类型',
  `NAME` varchar(50) DEFAULT NULL COMMENT '推荐组名',
  `DESCRIPTION` varchar(250) DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`RGROUP_ID`),
  KEY `FK_RGROUP_CHANNEL` (`CHANNEL_ID`),
  KEY `FK_RGROUP_WEBSITE` (`WEBSITE_ID`),
  CONSTRAINT `FK_RGROUP_CHANNEL` FOREIGN KEY (`CHANNEL_ID`) REFERENCES `cms_channel` (`CHANNEL_ID`),
  CONSTRAINT `FK_RGROUP_WEBSITE` FOREIGN KEY (`WEBSITE_ID`) REFERENCES `core_website` (`WEBSITE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `cms_recommend_group`
--


--
-- Table structure for table `cms_recommend_item`
--

CREATE TABLE `cms_recommend_item` (
  `RITEM_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `WEBSITE_ID` bigint(20) NOT NULL,
  `RGROUP_ID` bigint(20) NOT NULL,
  `SYS_TYPE` char(4) NOT NULL COMMENT '系统类型',
  `TITLE` varchar(250) DEFAULT NULL COMMENT '推荐的标题',
  `DESCRIPTION` varchar(255) DEFAULT NULL COMMENT '推荐的描述',
  `PIC_PATH` varchar(250) DEFAULT NULL COMMENT '图片地址，完整url',
  `URL` varchar(250) DEFAULT NULL COMMENT '推荐链接，完整url',
  `COLOR` varchar(20) DEFAULT NULL COMMENT '标题的颜色',
  `PRIORITY` int(11) NOT NULL COMMENT '优先级（显示的先后顺序）',
  `IS_CHECK` tinyint(1) NOT NULL COMMENT '是否审核',
  PRIMARY KEY (`RITEM_ID`),
  KEY `FK_RITEM_RGOUP` (`RGROUP_ID`),
  KEY `FK_RITEM_WEBSITE` (`WEBSITE_ID`),
  CONSTRAINT `FK_RITEM_RGOUP` FOREIGN KEY (`RGROUP_ID`) REFERENCES `cms_recommend_group` (`RGROUP_ID`),
  CONSTRAINT `FK_RITEM_WEBSITE` FOREIGN KEY (`WEBSITE_ID`) REFERENCES `core_website` (`WEBSITE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `cms_recommend_item`
--


--
-- Table structure for table `cms_topic`
--

CREATE TABLE `cms_topic` (
  `TOPIC_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `WEBSITE_ID` bigint(20) NOT NULL,
  `NAME` varchar(150) NOT NULL COMMENT '名称',
  `KEYWORDS` varchar(255) DEFAULT NULL COMMENT '关键字',
  `DESCRIPTION` varchar(255) DEFAULT NULL COMMENT '描述',
  `TITLE_IMG` varchar(100) DEFAULT NULL COMMENT '标题图',
  `TPL_CHANNEL` varchar(100) DEFAULT NULL COMMENT '模板',
  `PRIORITY` int(11) NOT NULL COMMENT '排列顺序',
  PRIMARY KEY (`TOPIC_ID`),
  KEY `FK_TOPIC_WEBSITE` (`WEBSITE_ID`),
  CONSTRAINT `FK_TOPIC_WEBSITE` FOREIGN KEY (`WEBSITE_ID`) REFERENCES `core_website` (`WEBSITE_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gbk COMMENT='专题表';

--
-- Dumping data for table `cms_topic`
--

INSERT INTO `cms_topic` VALUES (1,1,'虎虎生威-JEECMS与您一起展望2010年','专题,2010，虎年','过去的2009年里，JEECMS在广大网友的关心和支持下取得了很大的进步，JEECMS全体开发人员在此感谢大家的厚爱，祝大家虎年大吉，虎虎生威。在新的一年将里，我们继续努力，打造国内java开源cms品牌，JEECMS与您一起展望2010年！','/article/image/2010_1/1_15/cswag4gd04xx.jpg',NULL,10);

--
-- Table structure for table `core_admin`
--

CREATE TABLE `core_admin` (
  `ADMIN_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `WEBSITE_ID` bigint(20) NOT NULL,
  `USER_ID` bigint(20) NOT NULL,
  `CREATE_TIME` datetime NOT NULL COMMENT '创建时间',
  `IS_DISABLED` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否禁用',
  PRIMARY KEY (`ADMIN_ID`),
  KEY `FK_ADMIN_USER` (`USER_ID`),
  KEY `FK_ADMIN_WEBSITE` (`WEBSITE_ID`),
  CONSTRAINT `FK_ADMIN_USER` FOREIGN KEY (`USER_ID`) REFERENCES `core_user` (`USER_ID`),
  CONSTRAINT `FK_ADMIN_WEBSITE` FOREIGN KEY (`WEBSITE_ID`) REFERENCES `core_website` (`WEBSITE_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gbk COMMENT='核心管理员';

--
-- Dumping data for table `core_admin`
--

INSERT INTO `core_admin` VALUES (1,1,1,'2010-12-02 00:00:00',0),(2,1,2,'2010-12-10 01:07:33',0);

--
-- Table structure for table `core_admin_function`
--

CREATE TABLE `core_admin_function` (
  `ADMIN_ID` bigint(20) NOT NULL,
  `FUNCTION_ID` bigint(20) NOT NULL,
  PRIMARY KEY (`ADMIN_ID`,`FUNCTION_ID`),
  KEY `FK_CORE_ADMIN_FUNCTION` (`FUNCTION_ID`),
  CONSTRAINT `FK_CORE_ADMIN_FUNCTION` FOREIGN KEY (`FUNCTION_ID`) REFERENCES `core_function` (`FUNCTION_ID`),
  CONSTRAINT `FK_CORE_FUNCTION_ADMIN` FOREIGN KEY (`ADMIN_ID`) REFERENCES `core_admin` (`ADMIN_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `core_admin_function`
--


--
-- Table structure for table `core_admin_role`
--

CREATE TABLE `core_admin_role` (
  `ROLE_ID` bigint(20) NOT NULL,
  `ADMIN_ID` bigint(20) NOT NULL,
  PRIMARY KEY (`ROLE_ID`,`ADMIN_ID`),
  KEY `FK_CORE_ROLE_ADMIN` (`ADMIN_ID`),
  CONSTRAINT `FK_CORE_ADMIN_ROLE` FOREIGN KEY (`ROLE_ID`) REFERENCES `core_role` (`ROLE_ID`),
  CONSTRAINT `FK_CORE_ROLE_ADMIN` FOREIGN KEY (`ADMIN_ID`) REFERENCES `core_admin` (`ADMIN_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `core_admin_role`
--

INSERT INTO `core_admin_role` VALUES (1,1),(2,2);

--
-- Table structure for table `core_attachment`
--

CREATE TABLE `core_attachment` (
  `ATTACHMENT_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `WEBSITE_ID` bigint(20) NOT NULL,
  `USER_ID` bigint(20) DEFAULT NULL,
  `NAME` varchar(50) DEFAULT NULL COMMENT '名称',
  `DESCRIPTION` varchar(255) DEFAULT NULL COMMENT '描述',
  `FILE_PATH` varchar(100) DEFAULT NULL COMMENT '文件路径',
  `FILE_NAME` varchar(50) DEFAULT NULL COMMENT '文件名',
  `FILE_SIZE` bigint(20) DEFAULT NULL COMMENT '文件大小（字节）',
  `DOWN_COUNT` bigint(20) DEFAULT NULL COMMENT '下载次数',
  `OWNER_NAME` varchar(100) DEFAULT NULL COMMENT '所有者名称',
  `OWNER_URL` varchar(150) DEFAULT NULL COMMENT '所有者URL',
  `OWNER_ID` bigint(20) DEFAULT NULL COMMENT '所有者记录ID',
  `OWNER_CTG` varchar(50) DEFAULT NULL COMMENT '所有者类别',
  `CREATE_TIME` datetime DEFAULT NULL COMMENT '创建时间',
  `IS_FREE` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否允许免费下载',
  `IS_LOST` tinyint(1) NOT NULL DEFAULT '0' COMMENT '附件是否丢失',
  `IS_PICTURE` tinyint(1) DEFAULT '1' COMMENT '是否图片',
  PRIMARY KEY (`ATTACHMENT_ID`),
  KEY `FK_ATTACHEMENT_USER` (`USER_ID`),
  KEY `FK_COREDOWNLOAD_WEBSITE` (`WEBSITE_ID`),
  CONSTRAINT `FK_ATTACHEMENT_USER` FOREIGN KEY (`USER_ID`) REFERENCES `core_user` (`USER_ID`),
  CONSTRAINT `FK_COREDOWNLOAD_WEBSITE` FOREIGN KEY (`WEBSITE_ID`) REFERENCES `core_website` (`WEBSITE_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=gbk COMMENT='附件表';

--
-- Dumping data for table `core_attachment`
--

INSERT INTO `core_attachment` VALUES (1,1,1,'o0z9fs41mb3k.jpg',NULL,'/article/image/2009_1/3_10/bbuhfs4h1jff.jpg','bbuhfs4h1jff.jpg',5,0,'两会上靓丽的礼仪小姐','/pic/29.htm',29,'文章','2009-03-10 19:01:05',1,0,1),(2,1,1,'6dijfs421wvi.jpg',NULL,'/article/image/2009_1/3_10/y2rvfs4h3bt4.jpg','y2rvfs4h3bt4.jpg',6,0,'施瓦辛格为09健美大赛冠军颁奖','/pic/30.htm',30,'文章','2009-03-10 19:02:24',1,0,1),(3,1,1,'32kxfs42b0xf.jpg',NULL,'/article/image/2009_1/3_10/urmmfs4h4kcv.jpg','urmmfs4h4kcv.jpg',6,0,'1千奥运缶拍出5千万 身价大增46倍','/pic/31.htm',31,'文章','2009-03-10 19:03:21',1,0,1),(4,1,1,'gtsdfs44c675.jpg',NULL,'/article/image/2009_1/3_10/fwozfs4h5t1t.jpg','fwozfs4h5t1t.jpg',12,0,'美丽在工作中绽放','/pic/32.htm',32,'文章','2009-03-10 19:04:20',1,0,1),(5,1,1,'4e5hfs468mjq.jpg',NULL,'/article/image/2009_1/3_10/l27tfs4h7g12.jpg','l27tfs4h7g12.jpg',6,0,'厦门：石头打造摩托车','/pic/33.htm',33,'文章','2009-03-10 19:05:35',1,0,1),(6,1,1,'3xtyfs46iksv.jpg',NULL,'/article/image/2009_1/3_10/5kb8fs4h8pnf.jpg','5kb8fs4h8pnf.jpg',7,0,'汶川人拍摄的震后影像','/pic/34.htm',34,'文章','2009-03-10 19:06:35',1,0,1),(7,1,1,'pm6ofs44kvku.jpg',NULL,'/article/image/2009_1/3_10/xahpfs4hai3b.jpg','xahpfs4hai3b.jpg',10,0,'“和平-09”联合军演进入实兵演练阶段','/war/35.htm',35,'文章','2009-03-10 19:07:57',1,0,1),(8,1,1,'ojf6fs44snp1.jpg',NULL,'/article/image/2009_1/3_10/yawhfs4hckfy.jpg','yawhfs4hckfy.jpg',16,0,'非洲百名打工者挤车顶返乡 场面令人瞠目','/war/36.htm',36,'文章','2009-03-10 19:09:34',1,0,1),(9,1,1,'licence.zip',NULL,'/download/image/2010_1/1_15/e4kwg4gd9suo.zip','e4kwg4gd9suo.zip',2,0,'WinRAR 汉化版 3.91','/system/1.htm',1,'下载','2010-01-15 10:45:07',1,0,NULL),(10,1,1,'rar.jpg',NULL,'/download/image/2010_1/1_15/snueg4gd9o9a.jpg','snueg4gd9o9a.jpg',7,0,'WinRAR 汉化版 3.91','/system/1.htm',1,'下载','2010-01-15 10:45:07',1,0,NULL),(11,1,1,'licence.zip',NULL,'/download/image/2010_1/1_15/476ig4gdhkeg.zip','476ig4gdhkeg.zip',2,0,'傲游浏览器2(Maxthon) 2.5.11 正式版','/netsoft/2.htm',2,'下载','2010-01-15 10:51:10',1,0,NULL),(12,1,1,'aoyou.jpg',NULL,'/download/image/2010_1/1_15/sexdg4gdhfx0.jpg','sexdg4gdhfx0.jpg',8,0,'傲游浏览器2(Maxthon) 2.5.11 正式版','/netsoft/2.htm',2,'下载','2010-01-15 10:51:10',1,0,NULL),(13,1,1,'licence.zip',NULL,'/download/image/2010_1/1_15/0mzug4gdl87p.zip','0mzug4gdl87p.zip',2,0,'酷狗音乐2010(Kugou) 5.340','/media/3.htm',3,'下载','2010-01-15 10:54:00',1,0,NULL),(14,1,1,'kugou.gif',NULL,'/download/image/2010_1/1_15/niwmg4gdl47l.gif','niwmg4gdl47l.gif',7,0,'酷狗音乐2010(Kugou) 5.340','/media/3.htm',3,'下载','2010-01-15 10:54:00',1,0,NULL),(17,1,1,'模板-34.jpg',NULL,'/article/image/2010_4/12_8/q5xfghezyb17.jpg','q5xfghezyb17.jpg',14,0,'模板-34','/Products/41.htm',41,'文章','2010-12-08 00:20:46',1,0,1),(18,1,1,'模板-34.jpg',NULL,'/article/image/2010_4/12_8/vnjzghezxo8v.jpg','vnjzghezxo8v.jpg',913,0,'模板-34','/Products/41.htm',41,'文章','2010-12-08 00:20:46',1,0,1),(19,1,1,'模板-35.jpg',NULL,'/article/image/2010_4/12_8/ppz8ghf005jq.jpg','ppz8ghf005jq.jpg',550,0,'模板-35','/Products/40.htm',40,'文章','2010-12-08 00:22:30',1,0,1),(20,1,1,'模板-35.jpg',NULL,'/article/image/2010_4/12_8/pqo6ghf00m42.jpg','pqo6ghf00m42.jpg',14,0,'模板-35','/Products/40.htm',40,'文章','2010-12-08 00:22:30',1,0,1),(21,1,1,'模板-36.jpg',NULL,'/article/image/2010_4/12_8/mdt0ghf01dmj.jpg','mdt0ghf01dmj.jpg',174,0,'模板-36','/Products/39.htm',39,'文章','2010-12-08 00:23:20',1,0,1),(22,1,1,'模板-36.jpg',NULL,'/article/image/2010_4/12_8/q6p3ghf01qel.jpg','q6p3ghf01qel.jpg',15,0,'模板-36','/Products/39.htm',39,'文章','2010-12-08 00:23:20',1,0,1),(23,1,1,'模板-39.jpg',NULL,'/article/image/2010_4/12_8/mtrighf1brmr.jpg','mtrighf1brmr.jpg',559,0,'模板-39','/Products/42.htm',42,'文章','2010-12-08 00:59:17',1,0,1),(24,1,1,'模板-39.jpg',NULL,'/article/image/2010_4/12_8/0ak4ghf1bw79.jpg','0ak4ghf1bw79.jpg',15,0,'模板-39','/Products/42.htm',42,'文章','2010-12-08 00:59:17',1,0,1),(26,1,1,'left-pic-39.jpg',NULL,'/article/image/2010_4/12_8/gv06ghfzokha.jpg','gv06ghfzokha.jpg',25,0,'39','/Products/43.htm',43,'文章','2010-12-08 17:00:54',1,0,1),(27,1,1,'left-pic-39-2.jpg',NULL,'/article/image/2010_4/12_8/xf4wghg1m564.jpg','xf4wghg1m564.jpg',24,0,'PU and PVC Casters swivel with brake','/NewProducts/44.htm',44,'文章','2010-12-08 17:55:06',1,0,1);

--
-- Table structure for table `core_function`
--

CREATE TABLE `core_function` (
  `FUNCTION_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `PARENT` bigint(20) DEFAULT NULL COMMENT '父功能',
  `NAME` varchar(100) DEFAULT NULL,
  `URL` varchar(200) DEFAULT NULL,
  `FUNCS` longtext COMMENT '功能列表集，用@分割',
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `PRIORITY` int(11) NOT NULL COMMENT '功能菜单排列顺序',
  `IS_MENU` tinyint(1) NOT NULL COMMENT '是否为菜单',
  PRIMARY KEY (`FUNCTION_ID`),
  KEY `FK_PARENT` (`PARENT`),
  CONSTRAINT `FK_PARENT` FOREIGN KEY (`PARENT`) REFERENCES `core_function` (`FUNCTION_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=469 DEFAULT CHARSET=gbk COMMENT='功能表';

--
-- Dumping data for table `core_function`
--

INSERT INTO `core_function` VALUES (1,NULL,'功能菜单','','','',100,1),(81,1,'核心功能','/admin/cms/frame/core_main','/admin/cms/frame/core_left@/admin/cms/frame/core_right','',30,1),(83,81,'用户管理','/admin/core/user/Com_list','','',20,1),(87,81,'角色管理','/admin/core/role/Com_list','','',30,1),(353,1,'辅助系统','/admin/cms/frame/auxiliary_main','/admin/cms/frame/auxiliary_left@/admin/cms/frame/auxiliary_right','',20,1),(369,1,'模板管理','/admin/core/template/Com_main','/admin/core/template/Com_left@/admin/core/template/Com_right@/admin/core/template/Com_list','',40,1),(370,81,'功能菜单','/admin/core/function/Com_main','/admin/core/function/Com_list@/admin/core/function/Com_left','',10,1),(372,81,'站点设置','','','',50,1),(373,81,'邮件设置','','','',60,1),(374,1,'资源管理','/admin/core/resource/Com_resMain','/admin/core/resource/Com_resLeft@/admin/core/resource/Com_resRight@/admin/core/resource/Com_resList','',50,1),(375,353,'留言类别','/admin/auxiliary/msg_ctg/Com_list','','',100,1),(376,353,'留言内容','/admin/auxiliary/msg/Com_list','','',100,1),(377,353,'辅助系统设置','','','',90,1),(378,1,'JEECMS','/admin/cms/Com_index','/admin/cms/Com_main@/admin/cms/Com_left@/admin/cms/Com_right','包括jeecms会员、管理员、配置等功能。',10,1),(379,378,'管理员管理','/admin/cms/admin/Com_list','','',50,1),(382,378,'文章栏目','/admin/article/channel/Com_main','/admin/article/channel/Com_left@/admin/article/channel/Com_right@/admin/article/channel/Com_list','',10,1),(383,378,'文章内容','/admin/article/article/Com_main','/admin/article/article/Com_left@/admin/article/article/Com_right@/admin/article/article/Com_list','',20,1),(384,378,'网站配置','/admin/cms/frame/config_main','/admin/cms/frame/config_left@/admin/cms/frame/config_right','',40,1),(385,378,'模型管理','/admin/cms/chnl_model/Com_list','','',80,1),(386,353,'投票管理','/admin/auxiliary/vote_topic/Com_list','','',100,1),(387,378,'内容属性','/admin/cms/content_ctg/Com_list','','',90,1),(388,1,'图片处理','/admin/core/common/UploadImg','/admin/core/common/ImgAreaSelect@/admin/core/common/ImgCut','图片上传、图片剪裁',100,1),(389,81,'站点管理','/admin/core/website/Com_list','','',5,1),(390,378,'会员组管理','/admin/cms/group/Com_list','','',60,1),(391,378,'会员管理','/admin/cms/member/Com_list','','',70,1),(392,378,'文档维护','/admin/cms/frame/document_main','/admin/cms/frame/document_left@/admin/cms/frame/document_right','',30,1),(393,392,'文章审核','/admin/article/article/Com_listUncheck','/admin/article/article/Com_checkView@/admin/article/article/Com_pass@/admin/article/article/Com_reject','',100,1),(395,81,'附件管理','/admin/core/attachment/Com_list','','',100,1),(396,392,'评论审核','/admin/cms/comment/Com_list','','',100,1),(397,392,'文章签收','/admin/article/article/Com_listSignin','','',100,1),(398,378,'缓存管理','','','',100,1),(399,378,'个人信息','','','',110,1),(400,369,'模板浏览','','/admin/core/template/Com_add@/admin/core/template/Com_edit','',100,1),(401,369,'导出浏览','/admin/core/template/Com_exportTpl','','',200,1),(402,369,'导出操作','/admin/core/template/Com_exportTplSubmit','','',200,1),(403,369,'导入浏览','/admin/core/template/Com_importTpl','','',200,1),(404,369,'导入操作','/admin/core/template/Com_importTplSubmit','','',200,1),(405,369,'模板方案浏览','/admin/core/template/Com_solutionEdit','','',200,1),(406,369,'模板方案操作','/admin/core/template/Com_solutionUpdate','','',200,1),(407,369,'模板操作','','/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','',100,1),(408,374,'资源浏览','','/admin/core/resource/Com_resAdd@/admin/core/resource/Com_resEdit','',100,1),(409,374,'资源操作','','/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','',100,1),(410,382,'文章栏目浏览','','/admin/article/channel/Com_add@/admin/article/channel/Com_edit@/admin/article/channel/Com_checkPath','',100,1),(411,382,'文章栏目操作','','/admin/article/channel/Com_save@/admin/article/channel/Com_update@/admin/article/channel/Com_delete@/admin/article/channel/Com_priorityUpdate','',100,1),(412,383,'文章内容浏览','','/admin/article/article/Com_add@/admin/article/article/Com_edit','',100,1),(413,383,'文章内容操作','','/admin/article/article/Com_save@/admin/article/article/Com_update@/admin/article/article/Com_delete@/admin/article/article/Com_disable@/admin/article/article/Com_undisable','',100,1),(414,393,'文章审核浏览','/admin/article/article/Com_checkView','','',100,1),(415,393,'文章审核操作','','/admin/article/article/Com_pass@/admin/article/article/Com_reject','',100,1),(416,396,'评论审核浏览','/admin/cms/comment/Com_edit','','',100,1),(417,396,'评论审核操作','','/admin/cms/comment/Com_update@/admin/cms/comment/Com_delete@/admin/cms/comment/Com_check','',100,1),(418,397,'文章签收浏览','/admin/article/article/Com_signinView','','',100,1),(419,397,'文章签收操作','','/admin/article/article/Com_signin@/admin/article/article/Com_reject','',100,1),(420,384,'网站配置浏览','/admin/cms/config/Com_configEdit','','',100,1),(421,384,'网站配置操作','/admin/cms/config/Com_configUpdate','','',100,1),(422,379,'管理员管理浏览','','/admin/cms/admin/Com_add@/admin/cms/admin/Com_edit','',100,1),(423,379,'管理员管理操作','','/admin/cms/admin/Com_save@/admin/cms/admin/Com_update@/admin/cms/admin/Com_delete','',100,1),(424,390,'会员组管理浏览','','/admin/cms/group/Com_add@/admin/cms/group/Com_edit','',100,1),(425,390,'会员组管理操作','','/admin/cms/group/Com_save@/admin/cms/group/Com_update@/admin/cms/group/Com_delete','',100,1),(426,391,'会员管理浏览','','/admin/cms/member/Com_add@/admin/cms/member/Com_edit','',100,1),(427,391,'会员管理操作','','/admin/cms/member/Com_save@/admin/cms/member/Com_update@/admin/cms/member/Com_delete','',100,1),(428,385,'模型管理浏览','','/admin/cms/chnl_model/Com_add@/admin/cms/chnl_model/Com_edit@/admin/cms/chnl_model/Com_copy@/admin/cms/chnl_model/Com_addItem@/admin/cms/chnl_model/Com_editItem','',100,1),(429,385,'模型管理操作','','/admin/cms/chnl_model/Com_saveItem@/admin/cms/chnl_model/Com_updateItem@/admin/cms/chnl_model/Com_save@/admin/cms/chnl_model/Com_update@/admin/cms/chnl_model/Com_delete@/admin/cms/chnl_model/Com_priorityUpdate','',100,1),(430,387,'内容属性浏览','','/admin/cms/content_ctg/Com_add@/admin/cms/content_ctg/Com_edit','',100,1),(431,387,'内容属性操作','','/admin/cms/content_ctg/Com_save@/admin/cms/content_ctg/Com_update@/admin/cms/content_ctg/Com_delete','',100,1),(432,398,'缓存浏览','/admin/cms/config/Cache_configEdit','','',100,1),(433,398,'缓存操作','','/admin/cms/config/Cache_configUpdate@/admin/cms/config/ajax/clearHomepageCache@/admin/cms/config/ajax/clearChannelCache','',100,1),(434,399,'个人信息浏览','/admin/cms/config/Self_edit','','',100,1),(435,399,'个人信息操作','','/admin/cms/config/Self_update@/admin/cms/config/Self_checkEmail','',100,1),(436,377,'辅助系统设置浏览','/admin/auxiliary/config/Com_configEdit','','',100,1),(437,377,'辅助系统设置操作','/admin/auxiliary/config/Com_configUpdate','','',100,1),(438,375,'留言类别浏览','','/admin/auxiliary/msg_ctg/Com_add@/admin/auxiliary/msg_ctg/Com_edit','',100,1),(439,375,'留言类别操作','','/admin/auxiliary/msg_ctg/Com_save@/admin/auxiliary/msg_ctg/Com_update@/admin/auxiliary/msg_ctg/Com_delete','',100,1),(440,376,'留言内容浏览','','/admin/auxiliary/msg/Com_add@/admin/auxiliary/msg/Com_edit','',100,1),(441,376,'留言类别操作','','/admin/auxiliary/msg/Com_save@/admin/auxiliary/msg/Com_update@/admin/auxiliary/msg/Com_delete','',100,1),(442,386,'投票管理浏览','','/admin/auxiliary/vote_topic/Com_add@/admin/auxiliary/vote_topic/Com_edit','',100,1),(443,386,'投票管理操作','','/admin/auxiliary/vote_topic/Com_save@/admin/auxiliary/vote_topic/Com_update@/admin/auxiliary/vote_topic/Com_delete','',100,1),(444,389,'站点管理浏览','','/admin/core/website/Com_add@/admin/core/website/Com_edit@/admin/core/website/checkDomain@/admin/core/website/checkResPath','',100,1),(445,389,'站点管理操作','','/admin/core/website/Com_save@/admin/core/website/Com_update@/admin/core/website/Com_delete','',100,1),(446,370,'功能菜单浏览','','/admin/core/function/Com_add@/admin/core/function/Com_edit','',100,1),(447,370,'功能菜单操作','','/admin/core/function/Com_save@/admin/core/function/Com_update@/admin/core/function/Com_delete@/admin/core/function/Com_priorityUpdate','',100,1),(448,83,'用户管理浏览','','/admin/core/user/Com_add@/admin/core/user/Com_edit@/admin/core/user/checkLoginName@/admin/core/user/checkEmail','',100,1),(449,83,'用户管理操作','','/admin/core/user/Com_update@/admin/core/user/Com_save@/admin/core/user/Com_delete','',100,1),(450,87,'角色管理浏览','','/admin/core/role/Com_add@/admin/core/role/Com_edit','',100,1),(451,87,'角色管理操作','','/admin/core/role/Com_save@/admin/core/role/Com_update@/admin/core/role/Com_delete','',100,1),(452,372,'站点设置浏览','/admin/core/config/Com_siteEdit','','',100,1),(453,372,'站点设置操作','/admin/core/config/Com_siteUpdate','','',100,1),(454,373,'邮件设置浏览','/admin/core/config/Com_emailEdit','','',100,1),(455,373,'邮件设置操作','/admin/core/config/Com_emailUpdate','','',100,1),(456,81,'全局设置','','','',70,1),(457,456,'全局设置浏览','/admin/core/config/Com_globalEdit','','',100,1),(458,456,'全局设置操作','/admin/core/config/Com_globalUpdate','','',100,1),(459,81,'专题管理','/admin/cms/topic/Com_list','','',75,1),(460,459,'专题管理浏览','/admin/cms/topic/Com_edit','/admin/cms/topic/Com_add','',100,1),(461,459,'专题管理操作','/admin/cms/topic/Com_save','/admin/cms/topic/Com_update@/admin/cms/topic/Com_delete','',100,1),(462,398,'全文检索','/admin/cms/config/ajax/lucene','','',100,1),(463,378,'下载栏目','/admin/download/channel/Com_main','/admin/download/channel/Com_left@/admin/download/channel/Com_right@/admin/download/channel/Com_list','',22,1),(464,378,'下载内容','/admin/download/download/Com_main','/admin/download/download/Com_left@/admin/download/download/Com_right@/admin/download/download/Com_list','',24,1),(465,463,'文章栏目浏览','','/admin/download/channel/Com_add@/admin/download/channel/Com_edit@/admin/download/channel/Com_checkPath','',100,1),(466,463,'文章栏目操作','','/admin/download/channel/Com_save@/admin/download/channel/Com_update@/admin/download/channel/Com_delete@/admin/download/channel/Com_priorityUpdate','',100,1),(467,464,'下载内容浏览','','/admin/download/download/Com_add@/admin/download/download/Com_edit@/admin/download/down_type/Com_list','',100,1),(468,464,'下载内容操作','','/admin/download/download/Com_save@/admin/download/download/Com_update@/admin/download/download/Com_delete@/admin/download/download/Com_disable@/admin/download/download/Com_undisable@/admin/download/down_type/Com_save@/admin/download/down_type/Com_update@/admin/download/down_type/Com_delete@/admin/download/down_type/Com_edit','',100,1);

--
-- Table structure for table `core_global`
--

CREATE TABLE `core_global` (
  `GLOBAL_ID` bigint(20) NOT NULL,
  `CONTEXT_PATH` varchar(20) NOT NULL DEFAULT '' COMMENT '部署路径',
  `PORT` int(11) NOT NULL DEFAULT '80' COMMENT '端口号',
  PRIMARY KEY (`GLOBAL_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `core_global`
--

INSERT INTO `core_global` VALUES (1,'',80);

--
-- Table structure for table `core_member`
--

CREATE TABLE `core_member` (
  `MEMBER_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `USER_ID` bigint(20) NOT NULL,
  `WEBSITE_ID` bigint(20) NOT NULL,
  `NICK_NAME` varchar(50) DEFAULT NULL COMMENT '昵称',
  `CREATE_TIME` datetime NOT NULL COMMENT '创建时间',
  `PERSONAL_WEBSITE` varchar(100) DEFAULT NULL COMMENT '个人网站',
  `QQ` varchar(100) DEFAULT NULL COMMENT 'QQ',
  `MSN` varchar(100) DEFAULT NULL COMMENT 'MSN',
  `IS_DISABLED` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否禁用',
  PRIMARY KEY (`MEMBER_ID`),
  KEY `FK_MEMBER_USER` (`USER_ID`),
  KEY `FK_MEMBER_WEBSITE` (`WEBSITE_ID`),
  CONSTRAINT `FK_MEMBER_USER` FOREIGN KEY (`USER_ID`) REFERENCES `core_user` (`USER_ID`),
  CONSTRAINT `FK_MEMBER_WEBSITE` FOREIGN KEY (`WEBSITE_ID`) REFERENCES `core_website` (`WEBSITE_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gbk COMMENT='会员表';

--
-- Dumping data for table `core_member`
--

INSERT INTO `core_member` VALUES (1,1,1,NULL,'2010-12-02 00:00:00',NULL,NULL,NULL,0);

--
-- Table structure for table `core_private_msg`
--

CREATE TABLE `core_private_msg` (
  `PRIVMSG_ID` bigint(20) NOT NULL,
  `TO_USER` bigint(20) NOT NULL COMMENT '收信人',
  `FROM_USER` bigint(20) NOT NULL COMMENT '发信人',
  `MSG_TYPE` smallint(6) NOT NULL DEFAULT '1' COMMENT '类型（2：已发，1：已阅，0：未阅）',
  `MSG_SUBJECT` varchar(255) DEFAULT NULL COMMENT '主题',
  `CREATE_TIME` datetime NOT NULL COMMENT '创建时间',
  `MSG_IP` varchar(20) NOT NULL DEFAULT '' COMMENT 'IP地址',
  PRIMARY KEY (`PRIVMSG_ID`),
  KEY `FK_CORE_PRIVMSG_FROM` (`FROM_USER`),
  KEY `FK_CORE_PRIVMSG_TO` (`TO_USER`),
  CONSTRAINT `FK_CORE_PRIVMSG_FROM` FOREIGN KEY (`FROM_USER`) REFERENCES `core_user` (`USER_ID`),
  CONSTRAINT `FK_CORE_PRIVMSG_TO` FOREIGN KEY (`TO_USER`) REFERENCES `core_user` (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COMMENT='个人短消息';

--
-- Dumping data for table `core_private_msg`
--


--
-- Table structure for table `core_private_msg_text`
--

CREATE TABLE `core_private_msg_text` (
  `PRIVMSG_ID` bigint(20) NOT NULL,
  `MSG_TEXT` longtext COMMENT '个人信息内容',
  PRIMARY KEY (`PRIVMSG_ID`),
  CONSTRAINT `FK_CORE_PRIVTEXT_MSG` FOREIGN KEY (`PRIVMSG_ID`) REFERENCES `core_private_msg` (`PRIVMSG_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COMMENT='个人消息内容';

--
-- Dumping data for table `core_private_msg_text`
--


--
-- Table structure for table `core_role`
--

CREATE TABLE `core_role` (
  `ROLE_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `NAME` varchar(50) DEFAULT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`ROLE_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gbk COMMENT='角色表';

--
-- Dumping data for table `core_role`
--

INSERT INTO `core_role` VALUES (1,'超级管理员','拥有系统所有权限'),(2,'公司管理员','');

--
-- Table structure for table `core_role_function`
--

CREATE TABLE `core_role_function` (
  `ROLE_ID` bigint(20) NOT NULL,
  `FUNCTION_ID` bigint(20) NOT NULL,
  PRIMARY KEY (`ROLE_ID`,`FUNCTION_ID`),
  KEY `FK_CORE_ROLE_FUNCTION` (`FUNCTION_ID`),
  CONSTRAINT `FK_CORE_FUNCTION_ROLE` FOREIGN KEY (`ROLE_ID`) REFERENCES `core_role` (`ROLE_ID`),
  CONSTRAINT `FK_CORE_ROLE_FUNCTION` FOREIGN KEY (`FUNCTION_ID`) REFERENCES `core_function` (`FUNCTION_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `core_role_function`
--

INSERT INTO `core_role_function` VALUES (1,1),(2,1),(1,81),(1,83),(1,87),(1,353),(2,353),(1,369),(1,370),(1,372),(1,373),(1,374),(1,375),(1,376),(2,376),(1,377),(1,378),(2,378),(1,379),(1,382),(1,383),(2,383),(1,384),(1,385),(1,386),(1,387),(1,388),(1,389),(1,390),(1,391),(1,392),(1,393),(1,395),(1,396),(1,397),(1,398),(1,399),(1,400),(1,401),(1,402),(1,403),(1,404),(1,405),(1,406),(1,407),(1,408),(1,409),(1,410),(1,411),(1,412),(2,412),(1,413),(2,413),(1,414),(1,415),(1,416),(1,417),(1,418),(1,419),(1,420),(1,421),(1,422),(1,423),(1,424),(1,425),(1,426),(1,427),(1,428),(1,429),(1,430),(1,431),(1,432),(1,433),(1,434),(1,435),(1,436),(1,437),(1,438),(1,439),(1,440),(2,440),(1,441),(2,441),(1,442),(1,443),(1,444),(1,445),(1,446),(1,447),(1,448),(1,449),(1,450),(1,451),(1,452),(1,453),(1,454),(1,455),(1,456),(1,457),(1,458),(1,459),(1,460),(1,461),(1,462),(1,463),(1,464),(1,465),(1,466),(1,467),(1,468);

--
-- Table structure for table `core_tpl_solution`
--

CREATE TABLE `core_tpl_solution` (
  `WEBSITE_ID` bigint(20) NOT NULL,
  `SYSTEM_NAME` varchar(20) NOT NULL,
  `SOLUTION_NAME` varchar(20) DEFAULT NULL,
  KEY `FK_TPLSOLUTION_WEBSITE` (`WEBSITE_ID`),
  CONSTRAINT `FK_TPLSOLUTION_WEBSITE` FOREIGN KEY (`WEBSITE_ID`) REFERENCES `core_website` (`WEBSITE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COMMENT='模板方案表';

--
-- Dumping data for table `core_tpl_solution`
--

INSERT INTO `core_tpl_solution` VALUES (1,'article','default'),(1,'auxiliary','default'),(1,'cms_common','default'),(1,'cms_member','default'),(1,'picture','default'),(1,'forum','default'),(1,'download','default'),(1,'shop','default');

--
-- Table structure for table `down_download`
--

CREATE TABLE `down_download` (
  `DOWNLOAD_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `CTTCTG_ID` bigint(20) NOT NULL,
  `DOWNTYPE_ID` bigint(20) NOT NULL,
  `GROUP_ID` bigint(20) DEFAULT NULL,
  `ATTACHMENT_ID` bigint(20) DEFAULT NULL,
  `MEMEBE_ID` bigint(20) DEFAULT NULL,
  `CHANNEL_ID` bigint(20) NOT NULL,
  `WEBSITE_ID` bigint(20) NOT NULL,
  `ADMIN_INPUT` bigint(20) DEFAULT NULL COMMENT '录入管理员',
  `ADMIN_CHECK` bigint(20) DEFAULT NULL COMMENT '审核管理员',
  `ADMIN_DISABLE` bigint(20) DEFAULT NULL COMMENT '禁用管理员',
  `TITLE` varchar(255) DEFAULT NULL COMMENT '标题',
  `SHORT_TITLE` varchar(255) DEFAULT NULL COMMENT '简短标题',
  `TITLE_COLOR` varchar(10) DEFAULT NULL COMMENT '标题颜色',
  `TITLE_IMG` varchar(100) DEFAULT NULL COMMENT '标题图片',
  `DESCRIPTION` varchar(255) DEFAULT NULL COMMENT '软件描述',
  `TAGS` varchar(255) DEFAULT NULL COMMENT '标记（关键字）',
  `AUTHOR` varchar(100) DEFAULT NULL COMMENT '作者',
  `RELEASE_DATE` datetime DEFAULT NULL COMMENT '发布日期（可认为设置）',
  `RELEASE_SYS_DATE` datetime DEFAULT NULL COMMENT '发布日期（系统日期）',
  `CHECK_TIME` datetime DEFAULT NULL COMMENT '终审通过时间',
  `DISABLE_TIME` datetime DEFAULT NULL COMMENT '禁用时间',
  `VIEW_TOTAL` bigint(20) NOT NULL DEFAULT '0' COMMENT '浏览次数',
  `VISIT_TOTAL` bigint(20) NOT NULL DEFAULT '0' COMMENT '总共下载次数',
  `VISIT_TODAY` bigint(20) NOT NULL DEFAULT '0' COMMENT '当天下载次数',
  `VISIT_WEEK` bigint(20) NOT NULL DEFAULT '0' COMMENT '本周下载次数',
  `VISIT_MONTH` bigint(20) NOT NULL DEFAULT '0' COMMENT '本月下载次数',
  `VISIT_QUARTER` bigint(20) NOT NULL DEFAULT '0' COMMENT '本季下载次数',
  `VISIT_YEAR` bigint(20) NOT NULL DEFAULT '0' COMMENT '本年下载次数',
  `STAT_DATE` date DEFAULT NULL COMMENT '统计时间',
  `OUTER_URL` varchar(255) DEFAULT NULL COMMENT '外部链接',
  `CONTENT_RES_PATH` varchar(200) DEFAULT NULL COMMENT '资源路径',
  `TPL_CONTENT` varchar(100) DEFAULT NULL COMMENT '指定模板',
  `CHECK_STEP` int(11) DEFAULT NULL COMMENT '审核级数',
  `CHECK_OPINION` varchar(255) DEFAULT NULL COMMENT '审核意见',
  `TOP_LEVEL` int(11) DEFAULT '0' COMMENT '置顶级别',
  `HOMEPAGE` varchar(100) DEFAULT NULL COMMENT '厂商主页',
  `DEMO_URL` varchar(100) DEFAULT NULL COMMENT '系统演示',
  `CONTACT` varchar(100) DEFAULT NULL COMMENT '联系方式',
  `ENVIRONMENT` varchar(255) DEFAULT NULL COMMENT '运行环境',
  `EVALUATION` int(11) DEFAULT NULL COMMENT '软件评价',
  `FILE_TYPE` varchar(20) DEFAULT NULL COMMENT '文件类型',
  `FILE_SIZE` bigint(20) DEFAULT NULL COMMENT '文件大小',
  `DOWN_COUNT` bigint(20) DEFAULT NULL COMMENT '下载次数',
  `COMMENT_COUNT` int(11) NOT NULL DEFAULT '0' COMMENT '评论数量',
  `CONTENT` longtext COMMENT '详细信息',
  `HAS_TITLEIMG` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否有标题图片',
  `IS_BOLD` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否加粗',
  `IS_DRAFT` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否草稿',
  `IS_RECOMMEND` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否推荐',
  `IS_CHECK` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否审核',
  `IS_REJECT` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否驳回',
  `IS_DISABLED` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否禁用',
  `PARAM1` varchar(255) DEFAULT NULL COMMENT '文章相关数据1',
  `PARAM2` varchar(255) DEFAULT NULL COMMENT '文章相关数据2',
  `PARAM3` varchar(255) DEFAULT NULL COMMENT '文章相关数据3',
  `DEF_STRING_1` varchar(255) DEFAULT NULL COMMENT '自定义字符串1',
  `DEF_STRING_2` varchar(255) DEFAULT NULL COMMENT '自定义字符串2',
  `DEF_STRING_3` varchar(255) DEFAULT NULL COMMENT '自定义字符串3',
  `DEF_STRING_4` varchar(255) DEFAULT NULL COMMENT '自定义字符串4',
  `DEF_STRING_5` varchar(255) DEFAULT NULL COMMENT '自定义字符串5',
  `DEF_STRING_6` varchar(255) DEFAULT NULL COMMENT '自定义字符串6',
  `DEF_STRING_7` varchar(255) DEFAULT NULL COMMENT '自定义字符串7',
  `DEF_STRING_8` varchar(255) DEFAULT NULL COMMENT '自定义字符串8',
  `DEF_STRING_9` varchar(255) DEFAULT NULL COMMENT '自定义字符串9',
  `DEF_LONG_1` bigint(20) DEFAULT NULL COMMENT '自定义长整数1',
  `DEF_LONG_2` bigint(20) DEFAULT NULL COMMENT '自定义长整数1',
  `DEF_LONG_3` bigint(20) DEFAULT NULL COMMENT '自定义长整数1',
  `DEF_LONG_4` bigint(20) DEFAULT NULL COMMENT '自定义长整数1',
  `DEF_LONG_5` bigint(20) DEFAULT NULL COMMENT '自定义长整数1',
  `DEF_MONEY1` decimal(12,2) DEFAULT NULL COMMENT '自定义金额1',
  `DEF_MONEY2` decimal(12,2) DEFAULT NULL COMMENT '自定义金额2',
  `DEF_MONEY3` decimal(12,2) DEFAULT NULL COMMENT '自定义金额3',
  `DEF_DATE1` datetime DEFAULT NULL COMMENT '自定义日期1',
  `DEF_DATE2` datetime DEFAULT NULL COMMENT '自定义日期2',
  `DEF_DATE3` datetime DEFAULT NULL COMMENT '自定义日期3',
  `DEF_BOOL1` tinyint(1) DEFAULT NULL COMMENT '自定义布尔1',
  `DEF_BOOL2` tinyint(1) DEFAULT NULL COMMENT '自定义布尔2',
  `DEF_BOOL3` tinyint(1) DEFAULT NULL COMMENT '自定义布尔3',
  PRIMARY KEY (`DOWNLOAD_ID`),
  KEY `FK_DOWNLOAD_ATTACHMENT` (`ATTACHMENT_ID`),
  KEY `FK_DOWNLOAD_CHANNEL` (`CHANNEL_ID`),
  KEY `FK_DOWNLOAD_CHECK_ADMIN` (`ADMIN_CHECK`),
  KEY `FK_DOWNLOAD_CTTCTG` (`CTTCTG_ID`),
  KEY `FK_DOWNLOAD_DISABLE_ADMIN` (`ADMIN_DISABLE`),
  KEY `FK_DOWNLOAD_INPUT_ADMIN` (`ADMIN_INPUT`),
  KEY `FK_DOWNLOAD_MEMBER` (`MEMEBE_ID`),
  KEY `FK_DOWNLOAD_MEMBERGROUP` (`GROUP_ID`),
  KEY `FK_DOWNLOAD_TYPE` (`DOWNTYPE_ID`),
  KEY `FK_DOWNLOAD_WEBSITE` (`WEBSITE_ID`),
  CONSTRAINT `FK_DOWNLOAD_ATTACHMENT` FOREIGN KEY (`ATTACHMENT_ID`) REFERENCES `core_attachment` (`ATTACHMENT_ID`),
  CONSTRAINT `FK_DOWNLOAD_CHANNEL` FOREIGN KEY (`CHANNEL_ID`) REFERENCES `cms_channel` (`CHANNEL_ID`),
  CONSTRAINT `FK_DOWNLOAD_CHECK_ADMIN` FOREIGN KEY (`ADMIN_CHECK`) REFERENCES `cms_admin` (`ADMIN_ID`),
  CONSTRAINT `FK_DOWNLOAD_CTTCTG` FOREIGN KEY (`CTTCTG_ID`) REFERENCES `cms_content_ctg` (`CTTCTG_ID`),
  CONSTRAINT `FK_DOWNLOAD_DISABLE_ADMIN` FOREIGN KEY (`ADMIN_DISABLE`) REFERENCES `cms_admin` (`ADMIN_ID`),
  CONSTRAINT `FK_DOWNLOAD_INPUT_ADMIN` FOREIGN KEY (`ADMIN_INPUT`) REFERENCES `cms_admin` (`ADMIN_ID`),
  CONSTRAINT `FK_DOWNLOAD_MEMBER` FOREIGN KEY (`MEMEBE_ID`) REFERENCES `cms_member` (`MEMBER_ID`),
  CONSTRAINT `FK_DOWNLOAD_MEMBERGROUP` FOREIGN KEY (`GROUP_ID`) REFERENCES `cms_member_group` (`GROUP_ID`),
  CONSTRAINT `FK_DOWNLOAD_TYPE` FOREIGN KEY (`DOWNTYPE_ID`) REFERENCES `down_type` (`DOWNTYPE_ID`),
  CONSTRAINT `FK_DOWNLOAD_WEBSITE` FOREIGN KEY (`WEBSITE_ID`) REFERENCES `core_website` (`WEBSITE_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gbk COMMENT='下载表';

--
-- Dumping data for table `down_download`
--

INSERT INTO `down_download` VALUES (1,1,1,NULL,9,NULL,25,1,NULL,NULL,NULL,'WinRAR 汉化版 3.91','WinRAR 汉化版 3.91','','/download/image/2010_1/1_15/snueg4gd9o9a.jpg','WinRAR 是强大的压缩文件管理器。它提供了 RAR 和 ZIP 文件的完整支持，能解压 ARJ、CAB、LZH、ACE、TAR、GZ、UUE、BZ2、JAR、ISO 格式文件。WinRAR 的功能包括强力压缩、分卷、加密、自解压模块、备份简易。',NULL,NULL,'2010-01-15 10:45:07','2010-01-15 10:45:07',NULL,NULL,0,0,0,0,0,0,0,'2010-01-15',NULL,'http://localhost','',-1,'',0,NULL,NULL,NULL,NULL,NULL,'zip',2,0,0,'<p>WinRAR 是强大的压缩文件管理器。它提供了 RAR 和 ZIP 文件的完整支持，能解压 ARJ、CAB、LZH、ACE、TAR、GZ、UUE、BZ2、JAR、ISO 格式文件。WinRAR 的功能包括强力压缩、分卷、加密、自解压模块、备份简易。 （本版本是WinRAR最新版下载）</p>\r\n<p>WinRAR的优点是压缩率大，速度快。当设置成最快压缩方式的时候，WinRAR的压缩包比.ZIP小，速度却与PKZIP不相上下. 更可支持非RAR压缩文件。</p>\r\n<p>WinRAR高达50％以上压缩率，使其成为压缩/解压RAR格式的首选软件。WinRAR既可以解开ZIP格式的压缩文件，又可以生成ZIP压缩格式的文件。RAR格式一般要比WinZIP的ZIP格式高出10%～30%的压缩率。针对WAV、BMP声音及图像文件，WinRAR其采用独特的多媒体压缩算法大大提高压缩率。WinRAR不但能解压多数压缩格式，且不需外挂程序支持就可直接建立ZIP格式的压缩文件，对受损压缩文件的有极强的修复能力。对于在网上下载因头部受损而导致不能打开的ZIP、RAR类文件，用WinRAR调入后，只须单击界面中的&ldquo;修复&rdquo;按钮就可轻松修复，且成功率极高。能建立多种方式的全中文界面的全功能（带口令）多卷自解包，并通过&ldquo;锁定压缩包&rdquo;来防止人为的添加、删除等操作，保持压缩包的原始状态。WinRAR还可通过命令行方式行使批处理命令。</p>\r\n<p>WinRAR完全支援市面上最通用的RAR及ZIP压缩格式，并且还可以解开ARJ、CAB、LZH、TGZ等压缩格式，对於常玩日本游戏的玩家来说，能解开LZH格式是最好不过的功能了。</p>\r\n<p>除了支援这些压缩格式的解压缩功能外，还有分片压缩、资料恢复、资料加密等功能，并且可以可以将压缩档案储存为自动解压缩档案，方便他人使用的好用功能。</p>\r\n<p>&nbsp;</p>',0,0,0,0,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,1,1,NULL,11,NULL,26,1,NULL,NULL,NULL,'傲游浏览器2(Maxthon) 2.5.11 正式版','傲游浏览器2(Maxthon) 2.5.11 正式版','','/download/image/2010_1/1_15/sexdg4gdhfx0.jpg','傲游浏览器(Maxthon Browser), 是一款功能丰富的多标签浏览器。\r\n\r\n傲游浏览器允许在同一窗口内打开任意多个页面, 减少浏览器对系统资源的占用率, 提高网上冲浪的效率. 傲游基于IE内核开发, 这意味着您可以在傲游浏览器中看到和 IE 一致的效果, 并能正常使用网银等支付手段.',NULL,NULL,'2010-01-15 10:51:10','2010-01-15 10:51:10',NULL,NULL,0,0,0,0,0,0,0,'2010-01-15',NULL,'http://localhost','',-1,'',0,NULL,NULL,NULL,NULL,NULL,'zip',2,0,0,'<p>傲游浏览器(Maxthon Browser), 是一款功能丰富的多标签浏览器。</p>\r\n<p>傲游浏览器允许在同一窗口内打开任意多个页面, 减少浏览器对系统资源的占用率, 提高网上冲浪的效率. 傲游基于IE内核开发, 这意味着您可以在傲游浏览器中看到和 IE 一致的效果, 并能正常使用网银等支付手段. 同时, 傲游浏览器还能有效防止恶意插件, 阻止弹窗和浮动广告, 加强网上浏览的安全. 傲游浏览器支持各种外挂工具及 IE 插件, 使你可以充分利用所有的网上资源. 此外, 丰富的皮肤和强大的自定义功能让你在享受上网冲浪的乐趣之余, 充分展现个性与时尚.</p>\r\n<p>傲游浏览器(Maxthon) 2.5.11正式版最新更新：<br />\r\n-----------------------------------------------------<br />\r\n更新日志：<br />\r\n[安全模块]<br />\r\n网盾升级到3.0版<br />\r\n[静音模块]<br />\r\n解决了一处导致WMP不稳定的问题<br />\r\n[Windows7新特性]<br />\r\n解决最小化时预览图有时不正确的问题<br />\r\n[界面]<br />\r\n解决了安全网址地址栏颜色刷新慢的问题<br />\r\n解决一个撤销列表的条数与设置中心可能不一致的问题<br />\r\n解决了锁定的标签弹出后不能关闭的问题<br />\r\n解决了启动时直接登陆帐号可能导致浏览器崩溃的问题<br />\r\n解决了一个覆盖安装傲游时，记不住窗口状态的问题</p>\r\n<p><br />\r\n傲游浏览器(Maxthon) 2.5.10 正式版更新日志：<br />\r\n+ 加入了金山网盾功能<br />\r\n+ 支持Win7新特性（任务栏预览、跳跃列表、多点触摸等）<br />\r\n+ 加入傲游404页面</p>\r\n<p>傲游, 多年致力于网页浏览器开发, 以开发出用户满意的浏览器为最终目标.</p>\r\n<p>傲游浏览器, 上网从傲游开始.</p>\r\n<p>&nbsp;</p>',0,0,0,0,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,1,1,NULL,13,NULL,27,1,NULL,NULL,NULL,'酷狗音乐2010(Kugou) 5.340','酷狗音乐2010(Kugou) 5.340','','/download/image/2010_1/1_15/niwmg4gdl47l.gif','酷狗音乐(KuGou/KuGoo)是国内最大也是最专业的P2P音乐共享软件，拥有超过数亿的共享文件资料，深受全球用户的喜爱，拥有上千万使用用户。最新版本的酷狗2008给予用户更多的人性化功能，实行多源下载，提升平时的下载速度，经测试，最快可以达到500K/S，更快更高效率的下载搜索的歌曲。',NULL,NULL,'2010-01-15 10:54:00','2010-01-15 10:54:00',NULL,NULL,0,0,0,0,0,0,0,'2010-01-15',NULL,'http://localhost','',-1,'',0,NULL,NULL,NULL,NULL,NULL,'zip',2,0,0,'<p>酷狗音乐(KuGou/KuGoo)是国内最大也是最专业的P2P音乐共享软件，拥有超过数亿的共享文件资料，深受全球用户的喜爱，拥有上千万使用用户。最新版本的酷狗2010给予用户更多的人性化功能，实行多源下载，提升平时的下载速度，经测试，最快可以达到500K/S，更快更高效率的下载搜索的歌曲。国内最先提供在线试听功能，方便用户进行选择性的下载，减少下载不喜欢的歌曲哦。娱乐主页每天会提供大量最新的娱乐资讯，欧美、中文和日韩的最新大碟，单曲排行下载让你轻松掌握最前卫的流行动态，充分享受KuGou和您的精彩娱乐生活。酷狗音乐还开放了音乐酷吧，让喜欢同一个歌手的歌迷们聚在一起。</p>\r\n<p>酷狗音乐(KuGou)主要提供在线文件交互传输服务和互联网通讯,采用了P2P的先进构架设计研发.为用户设计了高传输效果的文件下载功能,通过它能实现 P2P数据分享传输,还有支持用户聊天、播放器等完备的网络娱乐服务,好友间也可以实现任何文件的传输交流,通过KuGoo,用户可以方便、快捷、安全地实现音乐查找,即时通讯,文件传输,文件共享等网络应用。</p>\r\n<p>酷狗音乐2010(kugou)全球最受欢迎的免费中文播放软件，流行音乐搜索平台，为您的音乐之旅带来更美妙的视听感受。<br />\r\n1、迷你界面更精致:界面更酷、绚丽流行；保持了Vista和XP下的完美表现，让人耳目一新；&nbsp; <br />\r\n2、卡拉OK终极体验:酷狗独创&ldquo;动感歌词&rdquo;技术，轻松享受制作过程，体验卡拉OK精准时代； <br />\r\n3、搜索及高速下载:优化歌曲搜索准确度，智能化节约带宽，可关闭网络功能，8源极速下载； <br />\r\n4、完美音乐播放:支持本地播放，兼容所有音频文件，超完美音质，音乐播放更动听； <br />\r\n5、海量流行音乐资讯:酷狗榜单家族、狗友推荐、酷吧、狗窝，最新流行音乐一网打尽；&nbsp; <br />\r\n6、更多人性化设计:重视细节设计，个性化设置，操作更简单，搜听音乐更方便；</p>\r\n<p>酷狗(kugou)2010 5.337更新日志： <br />\r\n1. 增加用户歌曲分享<br />\r\n2. 分类列表改进<br />\r\n3. 其它Bug修正与功能改进</p>\r\n<p>酷狗音乐(kugou)以往更新:<br />\r\n1. 增加对手机版酷狗播放器同步的支持<br />\r\n2. 修正播放模式,加强对狗友专辑播放的支持<br />\r\n3. 修正缺省快捷键与播放列表的冲突<br />\r\n4. 其他bug的修正和细节的改善</p>\r\n<p>&nbsp;</p>',0,0,0,0,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `down_download_attachment`
--

CREATE TABLE `down_download_attachment` (
  `DOWNLOAD_ID` bigint(20) NOT NULL,
  `ATTACHMENT_ID` bigint(20) NOT NULL,
  PRIMARY KEY (`DOWNLOAD_ID`,`ATTACHMENT_ID`),
  KEY `FK_DOWN_DOWNLOAD_ATTACHMENT2` (`ATTACHMENT_ID`),
  CONSTRAINT `FK_DOWN_DOWNLOAD_ATTACHMENT` FOREIGN KEY (`DOWNLOAD_ID`) REFERENCES `down_download` (`DOWNLOAD_ID`),
  CONSTRAINT `FK_DOWN_DOWNLOAD_ATTACHMENT2` FOREIGN KEY (`ATTACHMENT_ID`) REFERENCES `core_attachment` (`ATTACHMENT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `down_download_attachment`
--


--
-- Table structure for table `down_type`
--

CREATE TABLE `down_type` (
  `DOWNTYPE_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `WEBSITE_ID` bigint(20) NOT NULL,
  `NAME` varchar(100) DEFAULT NULL COMMENT '名称',
  `DESCRIPTION` varchar(255) DEFAULT NULL COMMENT '描述',
  `PRIORITY` int(11) DEFAULT NULL COMMENT '排序顺序',
  `IS_DISABLED` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否禁用',
  PRIMARY KEY (`DOWNTYPE_ID`),
  KEY `FK_DOWNTYPE_WEBSITE` (`WEBSITE_ID`),
  CONSTRAINT `FK_DOWNTYPE_WEBSITE` FOREIGN KEY (`WEBSITE_ID`) REFERENCES `core_website` (`WEBSITE_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gbk COMMENT='软件类型（国产、汉化、国外）';

--
-- Dumping data for table `down_type`
--

INSERT INTO `down_type` VALUES (1,1,'免费软件','免费软件',10,0),(2,1,'共享软件','共享软件',10,0),(3,1,'绿色软件','绿色软件',10,0);

--
-- Table structure for table `vote_item`
--

CREATE TABLE `vote_item` (
  `VOTEITEM_ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `VTOPIC_ID` bigint(20) NOT NULL,
  `TITLE` varchar(255) DEFAULT NULL COMMENT '标题',
  `DESCRIPTION` varchar(255) DEFAULT NULL COMMENT '描述',
  `VOTE_COUNT` bigint(20) DEFAULT NULL COMMENT '投票数量',
  `PRIORITY` int(11) NOT NULL COMMENT '显示优先级',
  PRIMARY KEY (`VOTEITEM_ID`),
  KEY `FK_VITEM_TOPIC` (`VTOPIC_ID`),
  CONSTRAINT `FK_VITEM_TOPIC` FOREIGN KEY (`VTOPIC_ID`) REFERENCES `vote_topic` (`VTOPIC_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gbk COMMENT='投票项';

--
-- Dumping data for table `vote_item`
--

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


