--
-- 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=192 DEFAULT CHARSET=gbk;

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

INSERT INTO `arti_article` VALUES (39,1,1,2,47,NULL,NULL,28,NULL,1,1,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-10 11:54:45','2010-12-15 22:46:34',64,1,1,64,64,64,'2010-12-15','','http://winjohn.ip5.jspcn.net',1,'',0,0,0,'','',1,1,0,0,0,1,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),(40,1,1,2,47,39,NULL,28,NULL,1,1,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-10 11:54:22','2010-12-15 22:46:33',7,1,2,7,7,7,'2010-12-15','','http://winjohn.ip5.jspcn.net',1,'',0,0,0,'','',1,1,0,0,0,1,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),(41,1,1,2,47,40,NULL,28,NULL,1,1,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-10 11:53:52','2010-12-15 22:46:33',14,1,5,14,14,14,'2010-12-15','','http://winjohn.ip5.jspcn.net',1,'',0,0,0,'','',1,1,0,0,0,1,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),(42,1,1,2,47,41,NULL,28,NULL,1,1,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-10 11:53:14','2010-12-15 22:46:31',13,1,1,13,13,13,'2010-12-15','','http://www.winjohn.com',1,'',0,0,0,'','',1,1,0,0,0,1,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),(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-10 19:38:03','2010-12-08 17:40:27',106,1,1,1,1,1,'2017-02-07','','http://www.winjohn.com',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,45,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-10 19:37:54',NULL,121,1,1,1,2,2,'2017-03-29','','http://www.winjohn.com',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),(45,1,1,3,46,44,NULL,29,NULL,1,NULL,1,'Heavy duty Casters','','','/article/image/2010_4/12_10/uv7nghiznrie.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-10 19:24:08','2010-12-10 00:00:00','2010-12-10 19:24:08','2010-12-15 22:24:27',NULL,127,1,1,1,2,2,'2017-03-28','','http://www.winjohn.com',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),(46,1,1,3,NULL,45,NULL,29,NULL,1,NULL,1,'Heavy duty Casters','','','/article/image/2010_4/12_10/84e7ghizqxq0.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-10 19:26:04','2010-12-10 00:00:00','2010-12-10 19:26:04','2010-12-10 19:26:29',NULL,88,1,1,1,1,1,'2017-02-10','','http://www.winjohn.com',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),(47,1,1,2,48,NULL,NULL,28,NULL,1,NULL,1,'50 - Red PU & PVC Casters','','','/article/image/2010_4/12_14/lfxyghotre3f.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:25:04','2010-12-14 21:25:04','2010-12-14 21:25:04','2010-12-14 21:25:04',NULL,588,1,2,4,15,15,'2017-03-11','','http://www.winjohn.com',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),(48,1,1,2,49,47,NULL,28,NULL,1,NULL,1,'49 - Red PU & PVC Casters','','','/article/image/2010_4/12_14/kgveghotsf7l.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:26:13','2010-12-14 21:26:13','2010-12-14 21:26:13','2010-12-14 21:26:13',NULL,598,1,1,2,13,13,'2017-03-18','','http://www.winjohn.com',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),(49,1,1,2,50,48,NULL,28,NULL,1,NULL,1,'48 - Casters','','','/article/image/2010_4/12_14/zc3mghottnqf.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:26:58','2010-12-14 21:26:58','2010-12-14 21:26:58','2010-12-14 21:26:58',NULL,654,1,1,2,14,14,'2017-03-16','','http://www.winjohn.com',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),(50,1,1,2,51,49,NULL,28,NULL,1,NULL,1,'47 - Hand Cart','','','/article/image/2010_4/12_14/ubcaghotvfx8.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:28:22','2010-12-14 21:28:22','2010-12-14 21:28:22','2010-12-14 21:28:22',NULL,576,1,1,2,14,14,'2017-03-19','','http://www.winjohn.com',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),(51,1,1,2,52,50,NULL,28,NULL,1,NULL,1,'46 - Hand Cart','','','/article/image/2010_4/12_14/i2z6ghotwd3h.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:28:54','2010-12-14 21:28:54','2010-12-14 21:28:54','2010-12-14 21:28:54',NULL,580,1,2,6,15,15,'2017-03-30','','http://www.winjohn.com',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),(52,1,1,2,53,51,NULL,28,NULL,1,NULL,1,'45 - Nylon Casters','','','/article/image/2010_4/12_14/fhsughotwta1.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:29:25','2010-12-14 21:29:25','2010-12-14 21:29:25','2010-12-14 21:29:25',NULL,551,1,2,5,16,16,'2017-03-22','','http://www.winjohn.com',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),(53,1,1,2,54,52,NULL,28,NULL,1,NULL,1,'44 - Nylon Casters','','','/article/image/2010_4/12_14/fz3vghotykz8.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:30:38','2010-12-14 21:30:38','2010-12-14 21:30:38','2010-12-14 21:30:38',NULL,534,1,1,4,13,13,'2017-03-26','','http://www.winjohn.com',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),(54,1,1,2,55,53,NULL,28,NULL,1,NULL,1,'43 - Nylon Casters','','','/article/image/2010_4/12_14/1ng5ghotzfpj.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:31:17','2010-12-14 21:31:17','2010-12-14 21:31:17','2010-12-14 21:31:17',NULL,629,1,1,6,14,14,'2017-03-26','','http://www.winjohn.com',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),(55,1,1,2,56,54,NULL,28,NULL,1,NULL,1,'41 - Red PU & PVC Casters','','','/article/image/2010_4/12_14/vyr5ghou09ps.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:31:57','2010-12-14 21:31:57','2010-12-14 21:31:57','2010-12-14 21:31:57',NULL,562,2,3,4,13,13,'2017-03-18','','http://www.winjohn.com',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),(56,1,1,2,57,55,NULL,28,NULL,1,NULL,1,'39 - PU & PVC Casters','','','/article/image/2010_4/12_14/f9kfghou0t18.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:32:33','2010-12-14 21:32:33','2010-12-14 21:32:33','2010-12-14 21:32:33',NULL,583,1,1,3,16,16,'2017-03-27','','http://www.winjohn.com',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),(57,1,1,2,58,56,NULL,28,NULL,1,NULL,1,'37 - Tweenwheel Casters','','','/article/image/2010_4/12_14/xmvaghou1y22.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:33:15','2010-12-14 21:33:15','2010-12-14 21:33:15','2010-12-14 21:33:15',NULL,564,1,2,3,17,17,'2017-03-16','','http://www.winjohn.com',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),(58,1,1,2,59,57,NULL,28,NULL,1,NULL,1,'36 - PU & PVC Casters','','','/article/image/2010_4/12_14/2ctgghou2g9f.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:33:51','2010-12-14 21:33:51','2010-12-14 21:33:51','2010-12-14 21:33:51',NULL,659,1,1,4,22,22,'2017-03-24','','http://www.winjohn.com',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),(59,1,1,2,60,58,NULL,28,NULL,1,NULL,1,'35 - Heavy duty Casters','','','/article/image/2010_4/12_14/2hc5ghou4sw9.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:35:48','2010-12-14 21:35:48','2010-12-14 21:35:48','2010-12-14 21:35:48',NULL,612,1,1,5,16,16,'2017-03-22','','http://www.winjohn.com',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),(60,1,1,2,61,59,NULL,28,NULL,1,NULL,1,'34 - Furniture Casters','','','/article/image/2010_4/12_14/n1e0ghou5pgd.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:36:26','2010-12-14 21:36:26','2010-12-14 21:36:26','2010-12-14 21:36:26',NULL,603,1,1,4,17,17,'2017-03-30','','http://www.winjohn.com',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),(61,1,1,2,119,60,NULL,28,NULL,1,NULL,1,'33 - Black PU Casters','','','/article/image/2010_4/12_14/fprbghou6kyz.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:37:00','2010-12-14 21:37:00','2010-12-14 21:37:00','2010-12-14 21:37:00',NULL,593,1,1,3,13,13,'2017-03-19','','http://www.winjohn.com',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),(62,1,1,2,63,173,NULL,28,NULL,1,NULL,1,'31 - Scaffolding Casters','','','/article/image/2010_4/12_14/mua6ghou7c0t.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:37:38','2010-12-14 21:37:38','2010-12-14 21:37:38','2010-12-14 21:37:38',NULL,753,1,2,7,25,25,'2017-03-21','','http://www.winjohn.com',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),(63,1,1,2,118,62,NULL,28,NULL,1,NULL,1,'30 - EX. Heavy duty Casters','','','/article/image/2010_4/12_14/4i30ghou80ee.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:38:11','2010-12-14 21:38:11','2010-12-14 21:38:11','2010-12-14 21:38:11',NULL,705,1,2,7,17,17,'2017-03-24','','http://www.winjohn.com',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),(64,1,1,2,65,118,NULL,28,NULL,1,NULL,1,'28 - Red PU & PVC scaffolding Casters','','','/article/image/2010_4/12_14/jfkvghou8opc.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:38:55','2010-12-14 21:38:55','2010-12-14 21:38:55','2010-12-14 21:38:55',NULL,711,1,1,8,21,21,'2017-03-24','','http://www.winjohn.com',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),(65,1,1,2,66,64,NULL,28,NULL,1,NULL,1,'27 - Europscaffolding Casters','','','/article/image/2010_4/12_14/z9yeghou9n5p.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:39:31','2010-12-14 21:39:31','2010-12-14 21:39:31','2010-12-14 21:39:31',NULL,723,2,3,8,20,20,'2017-03-24','','http://www.winjohn.com',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),(66,1,1,2,67,65,NULL,28,NULL,1,NULL,1,'26 - Centipede Wheel','','','/article/image/2010_4/12_14/z6s6ghouaf4j.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:40:15','2010-12-14 21:40:15','2010-12-14 21:40:15','2010-12-14 21:40:15',NULL,797,1,1,7,16,16,'2017-03-31','','http://www.winjohn.com',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),(67,1,1,2,68,66,NULL,28,NULL,1,NULL,1,'25 - Elastic rubber Casters','','','/article/image/2010_4/12_14/edg8ghoubc1v.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:40:47','2010-12-14 21:40:47','2010-12-14 21:40:47','2010-12-14 21:40:47',NULL,693,1,1,5,14,14,'2017-03-20','','http://www.winjohn.com',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),(68,1,1,2,69,67,NULL,28,NULL,1,NULL,1,'24 - Red PU Casters','','','/article/image/2010_4/12_14/nhgyghouc9x1.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:41:16','2010-12-14 21:41:16','2010-12-14 21:41:16','2010-12-14 21:41:16',NULL,644,1,1,8,22,22,'2017-03-27','','http://www.winjohn.com',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),(69,1,1,2,117,68,NULL,28,NULL,1,NULL,1,'23 - Industrial Casters','','','/article/image/2010_4/12_14/38afghoud1kz.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:41:52','2010-12-14 21:41:52','2010-12-14 21:41:52','2010-12-14 21:41:52',NULL,686,1,1,7,18,18,'2017-03-28','','http://www.winjohn.com',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),(76,1,1,2,77,117,NULL,28,NULL,1,NULL,1,'15 - Blue frame Casters','','','/article/image/2010_4/12_14/bq8cghouhbyg.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:45:20','2010-12-14 21:45:20','2010-12-14 21:45:20','2010-12-14 21:45:20',NULL,682,1,2,8,21,21,'2017-03-24','','http://www.winjohn.com',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),(77,1,1,2,78,76,NULL,28,NULL,1,NULL,1,'14 - Blue frame Casters','','','/article/image/2010_4/12_14/b48yghouhys5.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:45:53','2010-12-14 21:45:53','2010-12-14 21:45:53','2010-12-14 21:45:53',NULL,657,1,1,7,19,19,'2017-03-27','','http://www.winjohn.com',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),(78,1,1,2,79,77,NULL,28,NULL,1,NULL,1,'13 - Polyurethane Casters','','','/article/image/2010_4/12_14/3gblghouir6w.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:46:28','2010-12-14 21:46:28','2010-12-14 21:46:28','2010-12-14 21:46:28',NULL,707,1,1,7,20,20,'2017-03-28','','http://www.winjohn.com',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),(79,1,1,2,80,78,NULL,28,NULL,1,NULL,1,'12 - Standard Casters','','','/article/image/2010_4/12_14/xza1ghoujdcc.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:46:58','2010-12-14 21:46:58','2010-12-14 21:46:58','2010-12-14 21:46:58',NULL,748,1,1,7,21,21,'2017-03-26','','http://www.winjohn.com',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),(80,1,1,2,81,79,NULL,28,NULL,1,NULL,1,'11 - Red pu Casters','','','/article/image/2010_4/12_14/vlkqghoujyj0.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:47:22','2010-12-14 21:47:22','2010-12-14 21:47:22','2010-12-14 21:47:22',NULL,733,1,1,6,22,22,'2017-03-27','','http://www.winjohn.com',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),(81,1,1,2,82,80,NULL,28,NULL,1,NULL,1,'10 - Polyurethane on aluminium Casters','','','/article/image/2010_4/12_14/j0idghoukopl.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:48:02','2010-12-14 21:48:02','2010-12-14 21:48:02','2010-12-14 21:48:02',NULL,842,1,1,5,20,20,'2017-03-20','','http://www.winjohn.com',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),(82,1,1,2,83,81,NULL,28,NULL,1,NULL,1,'9 - Furniture Casters','','','/article/image/2010_4/12_14/h8wpghoulcnw.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:48:27','2010-12-14 21:48:27','2010-12-14 21:48:27','2010-12-14 21:48:27',NULL,777,1,3,9,19,19,'2017-03-25','','http://www.winjohn.com',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),(83,1,1,2,84,82,NULL,28,NULL,1,NULL,1,'8 - Shock absorption Casters','','','/article/image/2010_4/12_14/amuwghoulw6l.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:49:04','2010-12-14 21:49:04','2010-12-14 21:49:04','2010-12-14 21:49:04',NULL,840,1,3,11,26,26,'2017-03-22','','http://www.winjohn.com',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),(84,1,1,2,85,83,NULL,28,NULL,1,NULL,1,'7 - Shock abSorption Casters','','','/article/image/2010_4/12_14/nzbhghoumob5.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:49:40','2010-12-14 21:49:40','2010-12-14 21:49:40','2010-12-14 21:49:40',NULL,850,1,1,9,23,23,'2017-03-29','','http://www.winjohn.com',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),(85,1,1,2,86,84,NULL,28,NULL,1,NULL,1,'6 - Polyurethane on polyolefin Casters','','','/article/image/2010_4/12_14/fs9tghounevy.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:50:17','2010-12-14 21:50:17','2010-12-14 21:50:17','2010-12-14 21:50:17',NULL,996,1,4,9,26,26,'2017-03-24','','http://www.winjohn.com',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),(86,1,1,2,87,85,NULL,28,NULL,1,NULL,1,'5 - Blue Frame Casters','','','/article/image/2010_4/12_14/wlq8ghouoamc.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:50:46','2010-12-14 21:50:46','2010-12-14 21:50:46','2010-12-14 21:50:46',NULL,1052,1,1,7,18,18,'2017-03-21','','http://www.winjohn.com',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),(87,1,1,2,88,86,NULL,28,NULL,1,NULL,1,'4 - Heavy duty Casters','','','/article/image/2010_4/12_14/fc4vghouozc7.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:51:18','2010-12-14 21:51:18','2010-12-14 21:51:18','2010-12-14 21:51:18',NULL,1506,3,4,15,38,38,'2017-03-31','','http://www.winjohn.com',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),(88,1,1,2,89,87,NULL,28,NULL,1,NULL,1,'3 - Foam rubber wheel Casters','','','/article/image/2010_4/12_14/795lghoupttw.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:52:02','2010-12-14 21:52:02','2010-12-14 21:52:02','2010-12-14 21:52:02',NULL,1076,1,3,7,24,24,'2017-03-24','','http://www.winjohn.com',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),(89,1,1,2,90,88,NULL,28,NULL,1,NULL,1,'2 - Furniture Casters','','','/article/image/2010_4/12_14/tljvghouqinu.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:52:36','2010-12-14 21:52:36','2010-12-14 21:52:36','2010-12-14 21:52:36',NULL,1044,1,1,9,19,19,'2017-03-21','','http://www.winjohn.com',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),(90,1,1,2,117,89,NULL,28,NULL,1,NULL,1,'1 - Tweenwheel casters','','','/article/image/2010_4/12_14/uch2ghour9t2.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:53:19','2010-12-14 21:53:19','2010-12-14 21:53:19','2010-12-14 21:53:19',NULL,992,1,3,10,25,25,'2017-03-24','','http://www.winjohn.com',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),(91,1,1,2,92,NULL,NULL,30,NULL,1,NULL,1,'26 - PP CASTER','','','/article/image/2010_4/12_14/7gzpghoye5pm.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:34:51','2010-12-14 23:34:51','2010-12-14 23:34:51','2010-12-14 23:34:51',NULL,642,1,1,7,17,17,'2017-03-27','','http://www.winjohn.com',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),(92,1,1,2,93,91,NULL,30,NULL,1,NULL,1,'25 - Yellow color PU Casters','','','/article/image/2010_4/12_14/npexghoyftpf.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:36:18','2010-12-14 23:36:18','2010-12-14 23:36:18','2010-12-14 23:36:18',NULL,686,1,1,5,19,19,'2017-03-19','','http://www.winjohn.com',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),(93,1,1,2,94,92,NULL,30,NULL,1,NULL,1,'24 - PVC Wheels','','','/article/image/2010_4/12_14/o51jghoygk08.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:36:42','2010-12-14 23:36:42','2010-12-14 23:36:42','2010-12-14 23:36:42',NULL,660,1,1,5,23,23,'2017-03-19','','http://www.winjohn.com',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),(94,1,1,2,95,93,NULL,30,NULL,1,NULL,1,'23 - ALUMINIUM CASTER','','','/article/image/2010_4/12_14/qox2ghoyh1b5.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:37:08','2010-12-14 23:37:08','2010-12-14 23:37:08','2010-12-14 23:37:08',NULL,680,1,1,4,19,19,'2017-03-14','','http://www.winjohn.com',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),(95,1,1,2,96,94,NULL,30,NULL,1,NULL,1,'22 - Oil protected Casters','','','/article/image/2010_4/12_14/tilcghoyhlhf.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:37:35','2010-12-14 23:37:35','2010-12-14 23:37:35','2010-12-14 23:37:35',NULL,754,1,1,7,23,23,'2017-03-24','','http://www.winjohn.com',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),(96,1,1,2,98,95,NULL,30,NULL,1,NULL,1,'21 - BLACK PP+ RUBBER WHEEL AND SCHNIDER CASTERS','','','/article/image/2010_4/12_14/jd6bghoyi6wz.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:38:17','2010-12-14 23:38:17','2010-12-14 23:38:17','2010-12-14 23:38:17',NULL,822,1,1,8,22,22,'2017-03-24','','http://www.winjohn.com',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),(97,1,1,2,98,96,NULL,30,NULL,1,1,1,'21 - Scaffolding Casters with PU wheel','','','/article/image/2010_4/12_14/ci36ghoyjt5o.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:39:32','2010-12-14 23:39:32','2010-12-14 23:39:32','2010-12-14 23:39:32','2010-12-16 00:44:23',2,1,2,2,2,2,'2010-12-16','','http://www.winjohn.com',1,NULL,0,0,0,'',NULL,1,1,0,0,0,1,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),(98,1,1,2,99,96,NULL,30,NULL,1,NULL,1,'20 - Scaffolding Casters with PU wheel','','','/article/image/2010_4/12_14/zgtughoyl8ja.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:40:15','2010-12-14 23:40:15','2010-12-14 23:40:15','2010-12-14 23:40:15',NULL,986,1,1,5,20,20,'2017-03-19','','http://www.winjohn.com',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),(99,1,1,2,100,98,NULL,30,NULL,1,NULL,1,'19 - STANDARD CASTERS','','','/article/image/2010_4/12_14/fnorghoyln2q.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:42:01','2010-12-14 23:42:01','2010-12-14 23:42:01','2010-12-14 23:42:01',NULL,881,1,4,9,20,20,'2017-03-17','','http://www.winjohn.com',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),(100,1,1,2,121,99,NULL,30,NULL,1,NULL,1,'18 - Heavy duty ball Bearing Casters','','','/article/image/2010_4/12_14/v0s2ghoynxr3.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:42:33','2010-12-14 23:42:33','2010-12-14 23:42:33','2010-12-14 23:42:33',NULL,925,1,1,7,21,21,'2017-03-20','','http://www.winjohn.com',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),(101,1,1,2,102,121,NULL,30,NULL,1,NULL,1,'16 - TWEEN WHEEL CASTERS','','','/article/image/2010_4/12_14/crgqghoyok40.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:43:00','2010-12-14 23:43:00','2010-12-14 23:43:00','2010-12-14 23:43:00',NULL,952,1,1,4,20,20,'2017-03-22','','http://www.winjohn.com',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),(102,1,1,2,103,101,NULL,30,NULL,1,NULL,1,'15 - TWEEN WHEEL CASTERS','','','/article/image/2010_4/12_14/ne6dghoyp3z9.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:43:18','2010-12-14 23:43:18','2010-12-14 23:43:18','2010-12-14 23:43:18',NULL,970,1,1,7,19,19,'2017-03-29','','http://www.winjohn.com',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),(103,1,1,2,104,102,NULL,30,NULL,1,NULL,1,'14 - Ball Casters','','','/article/image/2010_4/12_14/sh9lghoypi77.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:43:40','2010-12-14 23:43:40','2010-12-14 23:43:40','2010-12-14 23:43:40',NULL,880,1,1,5,22,22,'2017-03-24','','http://www.winjohn.com',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),(104,1,1,2,105,103,NULL,30,NULL,1,NULL,1,'13 - Ball Casters','','','/article/image/2010_4/12_14/z6phghoypydl.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:44:00','2010-12-14 23:44:00','2010-12-14 23:44:00','2010-12-14 23:44:00',NULL,955,1,1,5,18,18,'2017-03-27','','http://www.winjohn.com',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),(105,1,1,2,106,104,NULL,30,NULL,1,NULL,1,'12 - GREY RUBBER CASTER(2)','','','/article/image/2010_4/12_14/a8e7ghoyqhcd.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:44:46','2010-12-14 23:44:46','2010-12-14 23:44:46','2010-12-14 23:44:46',NULL,1006,1,1,10,23,23,'2017-03-31','','http://www.winjohn.com',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),(106,1,1,2,107,105,NULL,30,NULL,1,NULL,1,'11 - GREY RUBBER CASTERS(1)','','','/article/image/2010_4/12_14/sigqghoyrhiw.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:45:14','2010-12-14 23:45:14','2010-12-14 23:45:14','2010-12-14 23:45:14',NULL,974,1,1,6,20,20,'2017-03-20','','http://www.winjohn.com',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),(107,1,1,2,108,106,NULL,30,NULL,1,NULL,1,'10 - Single wheel','','','/article/image/2010_4/12_14/0q8bghoys1mz.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:45:37','2010-12-14 23:45:37','2010-12-14 23:45:37','2010-12-14 23:45:37',NULL,1042,1,4,14,35,35,'2017-03-25','','http://www.winjohn.com',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),(108,1,1,2,120,107,NULL,30,NULL,1,NULL,1,'9 - N.P. Casters With Rubber Wheel','','','/article/image/2010_4/12_14/zj1qghoyshqf.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:46:07','2010-12-14 23:46:07','2010-12-14 23:46:07','2010-12-14 23:46:07',NULL,990,1,2,7,17,17,'2017-03-31','','http://www.winjohn.com',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),(109,1,1,2,110,120,NULL,30,NULL,1,NULL,1,'7 - Heavy duty Casters with red PU wheel','','','/article/image/2010_4/12_14/p9v7ghoyt6pv.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:46:42','2010-12-14 23:46:42','2010-12-14 23:46:42','2010-12-14 23:46:42',NULL,1033,1,1,7,23,23,'2017-03-31','','http://www.winjohn.com',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),(110,1,1,2,111,109,NULL,30,NULL,1,NULL,1,'6 - Heavy duty Casters','','','/article/image/2010_4/12_14/smnbghoytzbo.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:47:11','2010-12-14 23:47:11','2010-12-14 23:47:11','2010-12-14 23:47:11',NULL,917,3,3,9,21,21,'2017-03-31','','http://www.winjohn.com',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),(111,1,1,2,112,110,NULL,30,NULL,1,NULL,1,'5 - Heavy duty Casters','','','/article/image/2010_4/12_14/vc0eghoyujfn.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:47:36','2010-12-14 23:47:36','2010-12-14 23:47:36','2010-12-14 23:47:36',NULL,1010,1,2,9,21,21,'2017-03-25','','http://www.winjohn.com',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),(112,1,1,2,113,111,NULL,30,NULL,1,NULL,1,'4 - Induatrial Casters with PVC wheel','','','/article/image/2010_4/12_14/wof7ghoyv3jw.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:48:07','2010-12-14 23:48:07','2010-12-14 23:48:07','2010-12-14 23:48:07',NULL,1044,2,3,8,27,27,'2017-03-20','','http://www.winjohn.com',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),(113,1,1,2,114,112,NULL,30,NULL,1,NULL,1,'3 - Industrial Casters With PP Wheel','','','/article/image/2010_4/12_14/lyctghoyvq5u.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:48:38','2010-12-14 23:48:38','2010-12-14 23:48:38','2010-12-14 23:48:38',NULL,916,1,1,14,38,38,'2017-03-31','','http://www.winjohn.com',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),(114,1,1,2,115,113,NULL,30,NULL,1,NULL,1,'2 - Industrial Casters','','','/article/image/2010_4/12_14/6viyghoywemu.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:49:05','2010-12-14 23:49:05','2010-12-14 23:49:05','2010-12-14 23:49:05',NULL,914,1,1,10,34,34,'2017-03-24','','http://www.winjohn.com',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),(115,1,1,2,NULL,114,NULL,30,NULL,1,NULL,1,'1 - Industrial Casters','','','/article/image/2010_4/12_14/4d6gghoyx1cb.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:49:28','2010-12-14 23:49:28','2010-12-14 23:49:28','2010-12-14 23:49:28',NULL,991,1,2,11,32,32,'2017-03-31','','http://www.winjohn.com',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),(117,1,1,2,76,69,NULL,28,NULL,1,NULL,1,'21 - Available wheels','','','/article/image/2010_4/12_15/1bunghqbf9r5.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:42:40','2010-12-14 21:42:40','2010-12-14 21:42:40','2010-12-15 22:40:58',NULL,727,1,1,8,21,21,'2017-03-27','','http://www.winjohn.com',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),(118,1,1,2,64,63,NULL,28,NULL,1,NULL,1,'29 - Ex. heavy duty Casters','','','/article/image/2010_4/12_15/ozu8ghqc5owk.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:38:30','2010-12-14 21:38:30','2010-12-14 21:38:30','2010-12-14 21:38:30',NULL,914,1,2,8,20,20,'2017-03-24','','http://www.winjohn.com',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),(119,1,1,2,122,61,NULL,28,NULL,1,NULL,1,'32 - Furniture Casters','','','/article/image/2010_4/12_16/8yd0ghqfzeem.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 21:37:10','2010-12-14 21:37:10','2010-12-14 21:37:10','2010-12-14 21:37:10',NULL,736,1,2,4,19,19,'2017-03-24','','http://www.winjohn.com',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),(120,1,1,2,109,108,NULL,30,NULL,1,NULL,1,'8 - Scaffolding Casters','','','/article/image/2010_4/12_16/b0hpghqgcopq.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:46:35','2010-12-14 23:46:35','2010-12-14 23:46:35','2010-12-14 23:46:35',NULL,1067,1,1,8,21,21,'2017-03-31','','http://www.winjohn.com',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),(121,1,1,2,175,100,NULL,30,NULL,1,NULL,1,'17 - Penumatic Casters','','','/article/image/2010_4/12_16/r816ghqgdk3w.jpg',NULL,NULL,NULL,NULL,NULL,'2010-12-14 23:42:50','2010-12-14 23:42:50','2010-12-14 23:42:50','2010-12-14 23:42:50',NULL,884,1,1,7,18,18,'2017-03-20','','http://www.winjohn.com',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),(122,1,1,2,123,119,NULL,28,NULL,1,NULL,1,'1new','','','/article/image/2011_4/11_3/snykgujsv9b7.jpg',NULL,NULL,NULL,NULL,NULL,'2011-11-03 20:23:03','2011-11-03 00:00:00','2011-11-03 20:23:03','2011-11-03 21:38:04',NULL,965,1,1,6,25,25,'2017-03-21','','http://www.winjohn.com',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),(123,1,1,2,124,122,NULL,28,NULL,1,NULL,1,'2new','','','/article/image/2011_4/11_3/zod5gujuroo6.jpg',NULL,NULL,NULL,NULL,NULL,'2011-11-03 22:30:46','2011-11-03 22:30:46','2011-11-03 22:30:46','2011-11-03 22:30:46',NULL,947,1,1,4,21,21,'2017-03-21','','http://www.winjohn.com',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),(124,1,1,2,126,123,NULL,28,NULL,1,NULL,1,'3new','','','/article/image/2011_4/11_3/ipvmgujvqmrr.jpg',NULL,NULL,NULL,NULL,NULL,'2011-11-03 23:00:21','2011-11-03 23:00:21','2011-11-03 23:00:21','2011-11-03 23:00:21',NULL,962,2,2,8,28,28,'2017-03-28','','http://www.winjohn.com',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),(126,1,1,2,128,124,NULL,28,NULL,1,NULL,1,'4new','','','/article/image/2012_1/2_28/b2lugz6rtfjl.jpg',NULL,NULL,NULL,NULL,NULL,'2012-02-28 18:05:32','2012-02-28 18:05:32','2012-02-28 18:05:32','2012-02-28 18:05:32',NULL,947,2,2,7,20,20,'2017-03-21','','http://www.winjohn.com',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),(128,1,1,2,152,126,NULL,28,NULL,1,NULL,1,'new','','','/article/image/2013_2/4_10/bwc9hfc22mzx.jpg',NULL,NULL,NULL,NULL,NULL,'2013-04-10 13:27:01','2013-04-10 13:27:01','2013-04-10 13:27:01','2013-04-10 13:27:01',NULL,686,1,1,7,20,20,'2017-03-21','','http://www.winjohn.com',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),(152,1,1,2,153,128,NULL,28,NULL,1,NULL,1,'New 22','','','/article/image/2013_3/9_10/5tj8hlelzbhz.jpg',NULL,NULL,NULL,NULL,NULL,'2013-09-10 12:17:55','2013-09-10 12:17:55','2013-09-10 12:17:55','2013-09-10 12:17:55',NULL,391,1,1,4,13,13,'2017-03-21','','http://www.winjohn.com',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),(153,1,1,2,154,152,NULL,28,NULL,1,NULL,1,'New 21','','','/article/image/2013_3/9_10/osv1hlem0430.jpg',NULL,NULL,NULL,NULL,NULL,'2013-09-10 12:18:26','2013-09-10 12:18:26','2013-09-10 12:18:26','2013-09-10 12:18:26',NULL,401,2,3,6,18,18,'2017-03-24','','http://www.winjohn.com',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),(154,1,1,2,155,153,NULL,28,NULL,1,NULL,1,'New 20','','','/article/image/2013_3/9_10/wt52hlem0u56.jpg',NULL,NULL,NULL,NULL,NULL,'2013-09-10 12:18:59','2013-09-10 12:18:59','2013-09-10 12:18:59','2013-09-10 12:18:59',NULL,394,1,2,5,19,19,'2017-03-24','','http://www.winjohn.com',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),(155,1,1,2,156,154,NULL,28,NULL,1,NULL,1,'New 19','','','/article/image/2013_3/9_10/gvh5hlem1f7o.jpg',NULL,NULL,NULL,NULL,NULL,'2013-09-10 12:19:26','2013-09-10 12:19:26','2013-09-10 12:19:26','2013-09-10 12:19:26',NULL,373,1,2,6,24,24,'2017-03-24','','http://www.winjohn.com',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),(156,1,1,2,157,155,NULL,28,NULL,1,NULL,1,'New 18','','','/article/image/2013_3/9_10/92p9hlem21r0.jpg',NULL,NULL,NULL,NULL,NULL,'2013-09-10 12:19:55','2013-09-10 12:19:55','2013-09-10 12:19:55','2013-09-10 12:19:55',NULL,406,1,2,5,17,17,'2017-03-24','','http://www.winjohn.com',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),(157,1,1,2,158,156,NULL,28,NULL,1,NULL,1,'New 17','','','/article/image/2013_3/9_10/tlakhlem2mw4.jpg',NULL,NULL,NULL,NULL,NULL,'2013-09-10 12:20:23','2013-09-10 12:20:23','2013-09-10 12:20:23','2013-09-10 12:20:23',NULL,421,2,3,8,26,26,'2017-03-24','','http://www.winjohn.com',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),(158,1,1,2,159,157,NULL,28,NULL,1,NULL,1,'New 16','','','/article/image/2013_3/9_10/zmc4hlemkp2w.jpg',NULL,NULL,NULL,NULL,NULL,'2013-09-10 12:34:25','2013-09-10 12:34:25','2013-09-10 12:34:25','2013-09-10 12:34:25',NULL,522,1,1,11,32,32,'2017-03-21','','http://www.winjohn.com',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),(159,1,1,2,160,158,NULL,28,NULL,1,NULL,1,'New 15','','','/article/image/2013_3/9_10/rrc6hleml99z.jpg',NULL,NULL,NULL,NULL,NULL,'2013-09-10 12:34:51','2013-09-10 12:34:51','2013-09-10 12:34:51','2013-09-10 12:34:51',NULL,561,1,1,9,38,38,'2017-03-30','','http://www.winjohn.com',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),(160,1,1,2,161,159,NULL,28,NULL,1,NULL,1,'New 14','','','/article/image/2013_3/9_10/vorkhlemlv86.jpg',NULL,NULL,NULL,NULL,NULL,'2013-09-10 12:35:20','2013-09-10 12:35:20','2013-09-10 12:35:20','2013-09-10 12:35:20',NULL,496,2,5,13,39,39,'2017-03-24','','http://www.winjohn.com',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),(161,1,1,2,162,160,NULL,28,NULL,1,NULL,1,'New 13','','','/article/image/2013_3/9_10/hei7hlemmfsf.jpg',NULL,NULL,NULL,NULL,NULL,'2013-09-10 12:35:46','2013-09-10 12:35:46','2013-09-10 12:35:46','2013-09-10 12:35:46',NULL,470,1,3,8,23,23,'2017-03-24','','http://www.winjohn.com',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),(162,1,1,2,163,161,NULL,28,NULL,1,NULL,1,'New 12','','','/article/image/2013_3/9_10/ecghhlemn13p.jpg',NULL,NULL,NULL,NULL,NULL,'2013-09-10 12:36:15','2013-09-10 12:36:15','2013-09-10 12:36:15','2013-09-10 12:36:15',NULL,498,2,2,11,33,33,'2017-03-21','','http://www.winjohn.com',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),(163,1,1,2,164,162,NULL,28,NULL,1,NULL,1,'New 11','','','/article/image/2013_3/9_10/dbbihlemnqj5.jpg',NULL,NULL,NULL,NULL,NULL,'2013-09-10 12:36:48','2013-09-10 12:36:48','2013-09-10 12:36:48','2013-09-10 12:36:48',NULL,578,2,2,8,24,24,'2017-03-28','','http://www.winjohn.com',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),(164,1,1,2,165,163,NULL,28,NULL,1,NULL,1,'New 10','','','/article/image/2013_3/9_10/grijhlemobp6.jpg',NULL,NULL,NULL,NULL,NULL,'2013-09-10 12:37:14','2013-09-10 12:37:14','2013-09-10 12:37:14','2013-09-10 12:37:14',NULL,742,1,1,13,41,41,'2017-03-31','','http://www.winjohn.com',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),(165,1,1,2,166,164,NULL,28,NULL,1,NULL,1,'New 9','','','/article/image/2013_3/9_10/b317hlemp0sw.jpg',NULL,NULL,NULL,NULL,NULL,'2013-09-10 12:37:47','2013-09-10 12:37:47','2013-09-10 12:37:47','2013-09-10 12:37:47',NULL,743,1,1,11,35,35,'2017-03-27','','http://www.winjohn.com',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),(166,1,1,2,167,165,NULL,28,NULL,1,NULL,1,'New 8','','','/article/image/2013_3/9_10/k0auhlempot3.jpg',NULL,NULL,NULL,NULL,NULL,'2013-09-10 12:38:18','2013-09-10 12:38:18','2013-09-10 12:38:18','2013-09-10 12:38:18',NULL,774,2,3,12,37,37,'2017-03-31','','http://www.winjohn.com',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),(167,1,1,2,168,166,NULL,28,NULL,1,NULL,1,'New 7','','','/article/image/2013_3/9_10/qwqzhlemq76i.jpg',NULL,NULL,NULL,NULL,NULL,'2013-09-10 12:38:42','2013-09-10 12:38:42','2013-09-10 12:38:42','2013-09-10 12:38:42',NULL,800,1,1,14,38,38,'2017-03-31','','http://www.winjohn.com',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),(168,1,1,2,169,167,NULL,28,NULL,1,NULL,1,'New 6','','','/article/image/2013_3/9_10/qy14hlemquaq.jpg',NULL,NULL,NULL,NULL,NULL,'2013-09-10 12:39:12','2013-09-10 12:39:12','2013-09-10 12:39:12','2013-09-10 12:39:12',NULL,839,1,1,6,29,29,'2017-03-31','','http://www.winjohn.com',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),(169,1,1,2,170,168,NULL,28,NULL,1,NULL,1,'New 5','','','/article/image/2013_3/9_10/ncl2hlemrktp.jpg',NULL,NULL,NULL,NULL,NULL,'2013-09-10 12:39:47','2013-09-10 12:39:47','2013-09-10 12:39:47','2013-09-10 12:39:47',NULL,857,2,3,15,40,40,'2017-03-31','','http://www.winjohn.com',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),(170,1,1,2,171,169,NULL,28,NULL,1,NULL,1,'New 4','','','/article/image/2013_3/9_10/mfp2hlems5lm.jpg',NULL,NULL,NULL,NULL,NULL,'2013-09-10 12:40:16','2013-09-10 12:40:16','2013-09-10 12:40:16','2013-09-10 12:40:16',NULL,909,1,1,12,42,42,'2017-03-28','','http://www.winjohn.com',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),(171,1,1,2,172,170,NULL,28,NULL,1,NULL,1,'New 3','','','/article/image/2013_3/9_10/3sh6hlemss1i.jpg',NULL,NULL,NULL,NULL,NULL,'2013-09-10 12:40:42','2013-09-10 12:40:42','2013-09-10 12:40:42','2013-09-10 12:40:42',NULL,907,1,2,11,38,38,'2017-03-31','','http://www.winjohn.com',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),(172,1,1,2,173,171,NULL,28,NULL,1,NULL,1,'New 2','','','/article/image/2013_3/9_10/3zwwhlemtb2m.jpg',NULL,NULL,NULL,NULL,NULL,'2013-09-10 12:41:06','2013-09-10 12:41:06','2013-09-10 12:41:06','2013-09-10 12:41:06',NULL,830,2,2,14,40,40,'2017-03-31','','http://www.winjohn.com',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),(173,1,1,2,62,172,NULL,28,NULL,1,NULL,1,'New 1','','','/article/image/2013_3/9_10/orb2hlemtu06.jpg',NULL,NULL,NULL,NULL,NULL,'2013-09-10 12:41:32','2013-09-10 12:41:32','2013-09-10 12:41:32','2013-09-10 12:41:32',NULL,853,1,2,15,49,49,'2017-03-31','','http://www.winjohn.com',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),(175,1,1,2,176,121,NULL,30,NULL,1,NULL,1,'(New)Europe-type Industrial Casters','','','/article/image/2016_2/5_25/m2qyioml0dp7.jpg',NULL,NULL,NULL,NULL,NULL,'2016-05-25 16:01:19','2016-05-25 16:01:19','2016-05-25 16:01:19','2016-05-25 16:01:19',NULL,109,1,1,10,37,37,'2017-03-20','','http://www.winjohn.com',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),(176,1,1,2,177,175,NULL,30,NULL,1,NULL,1,'(New)Europe-type Grey Rubber','','','/article/image/2016_2/5_25/p35eioml27dy.jpg',NULL,NULL,NULL,NULL,NULL,'2016-05-25 16:02:45','2016-05-25 16:02:45','2016-05-25 16:02:45','2016-05-25 16:02:45',NULL,119,1,1,19,43,43,'2017-03-31','','http://www.winjohn.com',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),(177,1,1,2,178,176,NULL,30,NULL,1,NULL,1,'(New)Scaffolding Casters','','','/article/image/2016_2/5_25/k6whioml3xj4.jpg',NULL,NULL,NULL,NULL,NULL,'2016-05-25 16:04:05','2016-05-25 16:04:05','2016-05-25 16:04:05','2016-05-25 16:04:05',NULL,99,1,1,10,35,35,'2017-03-21','','http://www.winjohn.com',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),(178,1,1,2,179,177,NULL,30,NULL,1,NULL,1,'(New)Green PU 2','','','/article/image/2016_2/5_31/iunxiouvui3f.jpg',NULL,NULL,NULL,NULL,NULL,'2016-05-31 11:26:51','2016-05-31 11:26:51','2016-05-31 11:26:51','2016-05-31 11:26:51',NULL,85,1,2,10,28,28,'2017-03-22','','http://www.winjohn.com',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),(179,1,1,2,180,178,NULL,30,NULL,1,NULL,1,'(New)Green PU 1','','','/article/image/2016_2/5_31/2fzyiouvvhv4.jpg',NULL,NULL,NULL,NULL,NULL,'2016-05-31 11:27:38','2016-05-31 11:27:38','2016-05-31 11:27:38','2016-05-31 11:27:38',NULL,94,2,2,12,37,37,'2017-03-21','','http://www.winjohn.com',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),(180,1,1,2,182,179,NULL,30,NULL,1,NULL,1,'(New)Korean Type PU','','','/article/image/2016_2/5_31/fehbiouvxj63.jpg',NULL,NULL,NULL,NULL,NULL,'2016-05-31 11:29:12','2016-05-31 11:29:12','2016-05-31 11:29:12','2016-05-31 11:29:12',NULL,111,1,1,14,39,39,'2017-03-20','','http://www.winjohn.com',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),(182,1,1,2,183,180,NULL,30,NULL,1,NULL,1,'(New)PP Pattern Casters','','','/article/image/2016_2/5_31/mm0viouw1cl5.jpg',NULL,NULL,NULL,NULL,NULL,'2016-05-31 11:32:09','2016-05-31 11:32:09','2016-05-31 11:32:09','2016-05-31 11:32:09',NULL,105,2,4,12,37,37,'2017-03-24','','http://www.winjohn.com',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),(183,1,1,2,187,182,NULL,30,NULL,1,NULL,1,'(New)Elastic Rubber Wheel','','','/article/image/2016_2/5_31/imapiouw6858.jpg',NULL,NULL,NULL,NULL,NULL,'2016-05-31 11:35:57','2016-05-31 11:35:57','2016-05-31 11:35:57','2016-05-31 11:35:57',NULL,120,1,1,13,45,45,'2017-03-21','','http://www.winjohn.com',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),(187,1,1,2,188,183,NULL,30,NULL,1,NULL,1,'(New)A-type Casters','','','/article/image/2016_2/6_13/7g5uipdmzbtp.jpg',NULL,NULL,NULL,NULL,NULL,'2016-06-13 14:26:15','2016-06-13 14:26:15','2016-06-13 14:26:15','2016-06-13 14:26:15',NULL,120,2,2,10,44,44,'2017-03-21','','http://www.winjohn.com',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),(188,1,1,2,189,187,NULL,30,NULL,1,NULL,1,'(New)Extra Heavy Duty Casters 4','','','/article/image/2016_2/6_13/1a7aipdn01a0.jpg',NULL,NULL,NULL,NULL,NULL,'2016-06-13 14:26:48','2016-06-13 14:26:48','2016-06-13 14:26:48','2016-06-13 14:26:48',NULL,91,2,5,7,36,36,'2017-03-18','','http://www.winjohn.com',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),(189,1,1,2,190,188,NULL,30,NULL,1,NULL,1,'(New)Extra Heavy Duty Casters 3','','','/article/image/2016_2/6_13/5r45ipdn0rze.jpg',NULL,NULL,NULL,NULL,NULL,'2016-06-13 14:27:22','2016-06-13 14:27:22','2016-06-13 14:27:22','2016-06-13 14:27:22',NULL,97,1,5,7,41,41,'2017-03-18','','http://www.winjohn.com',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),(190,1,1,2,191,189,NULL,30,NULL,1,NULL,1,'(New)Extra Heavy Duty Casters 2','','','/article/image/2016_2/6_13/9ipkipdn1dlw.jpg',NULL,NULL,NULL,NULL,NULL,'2016-06-13 14:27:50','2016-06-13 14:27:50','2016-06-13 14:27:50','2016-06-13 14:27:50',NULL,117,2,5,12,44,44,'2017-03-24','','http://www.winjohn.com',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),(191,1,1,2,101,190,NULL,30,NULL,1,NULL,1,'(New)Extra Heavy Duty Casters 1','','','/article/image/2016_2/6_13/icu9ipdn2181.jpg',NULL,NULL,NULL,NULL,NULL,'2016-06-13 14:28:21','2016-06-13 14:28:21','2016-06-13 14:28:21','2016-06-13 14:28:21',NULL,129,1,1,8,39,39,'2017-03-19','','http://www.winjohn.com',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 (41,17),(40,20),(39,22),(42,24),(43,26),(44,27),(42,28),(41,29),(40,30),(39,31),(45,32),(45,33),(46,34),(47,35),(47,36),(48,37),(48,38),(49,39),(49,40),(50,41),(50,42),(51,43),(51,44),(52,45),(52,46),(53,47),(53,48),(54,49),(54,50),(55,51),(55,52),(56,53),(56,54),(57,55),(57,56),(58,57),(58,58),(59,59),(59,60),(60,61),(60,62),(61,63),(61,64),(62,65),(62,66),(63,67),(63,68),(64,69),(64,70),(65,71),(65,72),(66,73),(66,74),(67,75),(67,76),(68,77),(68,78),(69,79),(69,80),(76,93),(76,94),(77,95),(77,96),(78,97),(78,98),(79,99),(79,100),(80,101),(80,102),(81,103),(81,104),(82,105),(82,106),(83,107),(83,108),(84,109),(84,110),(85,111),(85,112),(86,113),(86,114),(87,115),(87,116),(88,117),(88,118),(89,119),(89,120),(90,121),(90,122),(91,123),(91,124),(92,125),(92,126),(93,127),(93,128),(94,129),(94,130),(95,131),(95,132),(96,133),(96,134),(97,135),(97,136),(98,137),(98,138),(99,139),(99,140),(100,141),(100,142),(101,143),(101,144),(102,145),(102,146),(103,147),(103,148),(104,149),(104,150),(105,151),(105,152),(106,153),(106,154),(107,155),(107,156),(108,157),(108,158),(109,159),(109,160),(110,161),(110,162),(111,163),(111,164),(112,165),(112,166),(113,167),(113,168),(114,169),(114,170),(115,171),(115,172),(117,175),(117,176),(118,177),(118,178),(119,179),(119,180),(120,181),(120,182),(121,183),(121,184),(122,187),(122,188),(123,189),(123,190),(124,191),(124,192),(126,195),(126,196),(128,197),(128,198),(152,244),(152,245),(153,246),(153,247),(154,248),(154,249),(155,250),(155,251),(156,252),(156,253),(157,254),(157,255),(158,256),(158,257),(159,258),(159,259),(160,260),(160,261),(161,262),(161,263),(162,264),(162,265),(163,266),(163,267),(164,268),(164,269),(165,270),(165,271),(166,272),(166,273),(167,274),(167,275),(168,276),(168,277),(169,278),(169,279),(170,280),(170,281),(171,282),(171,283),(172,284),(172,285),(173,286),(173,287),(175,290),(175,291),(176,292),(176,293),(177,294),(177,295),(178,296),(178,297),(179,298),(179,299),(180,300),(180,301),(182,304),(182,305),(183,306),(183,307),(187,314),(187,315),(188,316),(188,317),(189,318),(189,319),(190,320),(190,321),(191,322),(191,323);

--
-- 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=10 DEFAULT CHARSET=gbk COMMENT='留言板留言';

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

INSERT INTO `auxi_msg` VALUES (3,1,1,1,1,1,'How can I get contact with you?','How&nbsp;can&nbsp;I&nbsp;get&nbsp;contact&nbsp;with&nbsp;you?','You&nbsp;can&nbsp;contact&nbsp;us&nbsp;by&nbsp;the&nbsp;following&nbsp;ways:\r<br/>Tel：008620-87398921,&nbsp;87385850,&nbsp;87396986,&nbsp;87396987&nbsp;&nbsp;&nbsp;&nbsp;\r<br/>Mobil:0086-13802950725\r<br/>Fax：008620-87396986,&nbsp;87396987&nbsp;&nbsp;&nbsp;&nbsp;\r<br/>E-mail:winjohnli@163.net&nbsp;&nbsp;&nbsp;&nbsp;\r<br/>Msn:winjohnliyfather@hotmail.com\r<br/>\r<br/>Thank&nbsp;you!\r<br/>\r<br/>','','','','127.0.0.1','2010-12-09 02:02:40','2010-12-15 00:08:48',0,0,0),(4,1,1,1,1,1,'Is there any other hardwares?','Is&nbsp;there&nbsp;any&nbsp;other&nbsp;hardwares?','Thank&nbsp;you&nbsp;for&nbsp;your&nbsp;question.\r<br/>For&nbsp;more&nbsp;information&nbsp;of&nbsp;other&nbsp;hardwares&nbsp;and&nbsp;tools&nbsp;except&nbsp;casters,&nbsp;you&nbsp;may&nbsp;visit&nbsp;our&nbsp;website:&nbsp;www.winjohn.net&nbsp;\r<br/>','','','','127.0.0.1','2010-12-09 02:16:26','2010-12-15 00:11:03',0,0,0),(6,NULL,1,1,1,1,'Hi John','i&nbsp;want&nbsp;some&nbsp;products',NULL,NULL,NULL,NULL,'211.66.116.201','2010-12-10 19:28:31',NULL,0,0,0),(8,NULL,1,1,NULL,1,'caster','hi,i&nbsp;want&nbsp;some&nbsp;casters',NULL,NULL,NULL,NULL,'58.248.7.142','2010-12-17 10:49:07',NULL,0,0,0),(9,NULL,1,1,NULL,1,'castor wheel','Dear&nbsp;sir<br/>How&nbsp;are&nbsp;you.&nbsp;I&nbsp;am&nbsp;amit&nbsp;from&nbsp;india.&nbsp;I&nbsp;meet&nbsp;you&nbsp;in&nbsp;cantoon&nbsp;fair.&nbsp;We&nbsp;have&nbsp;an&nbsp;requirements&nbsp;of&nbsp;wheels&nbsp;now.&nbsp;My&nbsp;we&nbsp;chat&nbsp;number&nbsp;is&nbsp;00918427355099.&nbsp;Pls&nbsp;talk&nbsp;with&nbsp;me.&nbsp;Waiting&nbsp;for&nbsp;yours&nbsp;prompt&nbsp;reply.&nbsp;<br/>Thanks<br/>AMIT',NULL,NULL,NULL,NULL,'127.0.0.1','2015-04-28 10:54:50',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),(24,1),(25,1),(26,1),(27,1),(28,1),(29,1),(30,1),(1,2),(28,2),(29,2),(30,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`
--


--
-- 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=31 DEFAULT CHARSET=gbk;

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

INSERT INTO `cms_channel` VALUES (1,1,1,1,NULL,NULL,1,'article','main',1,10,'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),(10,1,1,NULL,NULL,1,3,'article','AboutUs',8,9,'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),(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','Products1',6,7,'Products1',NULL,'',NULL,'/article/default/channel_pic.html','','Products','Products','Products',72,0,0,'2010-12-07','',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',4,5,'New Products',NULL,'',NULL,'','','','','',4,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),(30,1,1,NULL,NULL,1,2,'article','Products2',2,3,'Products2',NULL,'',NULL,'/article/default/channel_pic.html','','Products','Products','Products',40,0,0,'2010-12-13','',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);

--
-- 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','主页左侧滚动',410,228,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=324 DEFAULT CHARSET=gbk COMMENT='附件表';

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

INSERT INTO `core_attachment` VALUES (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),(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),(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),(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),(28,1,1,'模板-39.jpg',NULL,'/article/image/2010_4/12_10/w43qghijkbij.jpg','w43qghijkbij.jpg',559,0,'模板-39','/Products/42.htm',42,'文章','2010-12-10 11:53:14',1,0,1),(29,1,1,'模板-34.jpg',NULL,'/article/image/2010_4/12_10/129oghijl8n0.jpg','129oghijl8n0.jpg',913,0,'模板-34','/Products/41.htm',41,'文章','2010-12-10 11:53:52',1,0,1),(30,1,1,'模板-35.jpg',NULL,'/article/image/2010_4/12_10/f9beghijlwjm.jpg','f9beghijlwjm.jpg',550,0,'模板-35','/Products/40.htm',40,'文章','2010-12-10 11:54:22',1,0,1),(31,1,1,'模板-36.jpg',NULL,'/article/image/2010_4/12_10/hggwghijmhmi.jpg','hggwghijmhmi.jpg',174,0,'模板-36','/Products/39.htm',39,'文章','2010-12-10 11:54:45',1,0,1),(32,1,1,'模板-35.jpg',NULL,'/article/image/2010_4/12_10/6fldghizoakh.jpg','6fldghizoakh.jpg',550,0,'Heavy duty Casters','/NewProducts/45.htm',45,'文章','2010-12-10 19:24:08',1,0,1),(33,1,1,'left-pic-35.jpg',NULL,'/article/image/2010_4/12_10/uv7nghiznrie.jpg','uv7nghiznrie.jpg',24,0,'Heavy duty Casters','/NewProducts/45.htm',45,'文章','2010-12-10 19:24:08',1,0,1),(34,1,1,'left-pic-35-2.jpg',NULL,'/article/image/2010_4/12_10/84e7ghizqxq0.jpg','84e7ghizqxq0.jpg',26,0,'Heavy duty Casters','/NewProducts/46.htm',46,'文章','2010-12-10 19:26:04',1,0,1),(35,1,1,'妯℃澘-50.jpg',NULL,'/article/image/2010_4/12_14/5vioghotqaw2.jpg','5vioghotqaw2.jpg',318,0,'50 - Red PU & PVC Casters','/Products/47.htm',47,'文章','2010-12-14 21:25:04',1,0,1),(36,1,1,'妯℃澘-50.jpg',NULL,'/article/image/2010_4/12_14/lfxyghotre3f.jpg','lfxyghotre3f.jpg',15,0,'50 - Red PU & PVC Casters','/Products/47.htm',47,'文章','2010-12-14 21:25:04',1,0,1),(37,1,1,'妯℃澘-49.jpg',NULL,'/article/image/2010_4/12_14/kgveghotsf7l.jpg','kgveghotsf7l.jpg',14,0,'49 - Red PU & PVC Casters','/Products/48.htm',48,'文章','2010-12-14 21:26:13',1,0,1),(38,1,1,'妯℃澘-49.jpg',NULL,'/article/image/2010_4/12_14/kfv7ghots8aj.jpg','kfv7ghots8aj.jpg',260,0,'49 - Red PU & PVC Casters','/Products/48.htm',48,'文章','2010-12-14 21:26:13',1,0,1),(39,1,1,'妯℃澘-48.jpg',NULL,'/article/image/2010_4/12_14/zc3mghottnqf.jpg','zc3mghottnqf.jpg',16,0,'48 - Casters','/Products/49.htm',49,'文章','2010-12-14 21:26:58',1,0,1),(40,1,1,'妯℃澘-48.jpg',NULL,'/article/image/2010_4/12_14/vs7hghott6kj.jpg','vs7hghott6kj.jpg',325,0,'48 - Casters','/Products/49.htm',49,'文章','2010-12-14 21:26:58',1,0,1),(41,1,1,'模板-47.jpg',NULL,'/article/image/2010_4/12_14/n9r3ghotv7up.jpg','n9r3ghotv7up.jpg',277,0,'47 - Hand Cart','/Products/50.htm',50,'文章','2010-12-14 21:28:22',1,0,1),(42,1,1,'模板-47.jpg',NULL,'/article/image/2010_4/12_14/ubcaghotvfx8.jpg','ubcaghotvfx8.jpg',15,0,'47 - Hand Cart','/Products/50.htm',50,'文章','2010-12-14 21:28:22',1,0,1),(43,1,1,'模板-46.jpg',NULL,'/article/image/2010_4/12_14/i2z6ghotwd3h.jpg','i2z6ghotwd3h.jpg',14,0,'46 - Hand Cart','/Products/51.htm',51,'文章','2010-12-14 21:28:54',1,0,1),(44,1,1,'模板-46.jpg',NULL,'/article/image/2010_4/12_14/z28zghotvzuk.jpg','z28zghotvzuk.jpg',216,0,'46 - Hand Cart','/Products/51.htm',51,'文章','2010-12-14 21:28:54',1,0,1),(45,1,1,'模板-45.jpg',NULL,'/article/image/2010_4/12_14/tyzcghotwo1r.jpg','tyzcghotwo1r.jpg',198,0,'45 - Nylon Casters','/Products/52.htm',52,'文章','2010-12-14 21:29:25',1,0,1),(46,1,1,'模板-45.jpg',NULL,'/article/image/2010_4/12_14/fhsughotwta1.jpg','fhsughotwta1.jpg',12,0,'45 - Nylon Casters','/Products/52.htm',52,'文章','2010-12-14 21:29:25',1,0,1),(47,1,1,'模板-44.jpg',NULL,'/article/image/2010_4/12_14/fz3vghotykz8.jpg','fz3vghotykz8.jpg',12,0,'44 - Nylon Casters','/Products/53.htm',53,'文章','2010-12-14 21:30:38',1,0,1),(48,1,1,'模板-44.jpg',NULL,'/article/image/2010_4/12_14/c2x2ghotxper.jpg','c2x2ghotxper.jpg',175,0,'44 - Nylon Casters','/Products/53.htm',53,'文章','2010-12-14 21:30:38',1,0,1),(49,1,1,'模板-43.jpg',NULL,'/article/image/2010_4/12_14/cl70ghotyv1n.jpg','cl70ghotyv1n.jpg',195,0,'43 - Nylon Casters','/Products/54.htm',54,'文章','2010-12-14 21:31:17',1,0,1),(50,1,1,'模板-43.jpg',NULL,'/article/image/2010_4/12_14/1ng5ghotzfpj.jpg','1ng5ghotzfpj.jpg',13,0,'43 - Nylon Casters','/Products/54.htm',54,'文章','2010-12-14 21:31:17',1,0,1),(51,1,1,'模板-41.jpg',NULL,'/article/image/2010_4/12_14/7kzvghotzp70.jpg','7kzvghotzp70.jpg',358,0,'41 - Red PU & PVC Casters','/Products/55.htm',55,'文章','2010-12-14 21:31:58',1,0,1),(52,1,1,'模板-41.jpg',NULL,'/article/image/2010_4/12_14/vyr5ghou09ps.jpg','vyr5ghou09ps.jpg',15,0,'41 - Red PU & PVC Casters','/Products/55.htm',55,'文章','2010-12-14 21:31:58',1,0,1),(53,1,1,'模板-39.jpg',NULL,'/article/image/2010_4/12_14/3hp7ghou0kqn.jpg','3hp7ghou0kqn.jpg',313,0,'39 - PU & PVC Casters','/Products/56.htm',56,'文章','2010-12-14 21:32:33',1,0,1),(54,1,1,'模板-39.jpg',NULL,'/article/image/2010_4/12_14/f9kfghou0t18.jpg','f9kfghou0t18.jpg',15,0,'39 - PU & PVC Casters','/Products/56.htm',56,'文章','2010-12-14 21:32:33',1,0,1),(55,1,1,'模板-37.jpg',NULL,'/article/image/2010_4/12_14/xmvaghou1y22.jpg','xmvaghou1y22.jpg',14,0,'37 - Tweenwheel Casters','/Products/57.htm',57,'文章','2010-12-14 21:33:15',1,0,1),(56,1,1,'模板-37.jpg',NULL,'/article/image/2010_4/12_14/4umughou1gmg.jpg','4umughou1gmg.jpg',251,0,'37 - Tweenwheel Casters','/Products/57.htm',57,'文章','2010-12-14 21:33:15',1,0,1),(57,1,1,'模板-36.jpg',NULL,'/article/image/2010_4/12_14/itgeghou27q5.jpg','itgeghou27q5.jpg',266,0,'36 - PU & PVC Casters','/Products/58.htm',58,'文章','2010-12-14 21:33:51',1,0,1),(58,1,1,'模板-36.jpg',NULL,'/article/image/2010_4/12_14/2ctgghou2g9f.jpg','2ctgghou2g9f.jpg',14,0,'36 - PU & PVC Casters','/Products/58.htm',58,'文章','2010-12-14 21:33:51',1,0,1),(59,1,1,'模板-35.jpg',NULL,'/article/image/2010_4/12_14/1a30ghou4m8k.jpg','1a30ghou4m8k.jpg',312,0,'35 - Heavy duty Casters','/Products/59.htm',59,'文章','2010-12-14 21:35:48',1,0,1),(60,1,1,'模板-35.jpg',NULL,'/article/image/2010_4/12_14/2hc5ghou4sw9.jpg','2hc5ghou4sw9.jpg',15,0,'35 - Heavy duty Casters','/Products/59.htm',59,'文章','2010-12-14 21:35:48',1,0,1),(61,1,1,'模板-34.jpg',NULL,'/article/image/2010_4/12_14/n1e0ghou5pgd.jpg','n1e0ghou5pgd.jpg',15,0,'34 - Furniture Casters','/Products/60.htm',60,'文章','2010-12-14 21:36:26',1,0,1),(62,1,1,'模板-34.jpg',NULL,'/article/image/2010_4/12_14/kqdhghou5jsn.jpg','kqdhghou5jsn.jpg',281,0,'34 - Furniture Casters','/Products/60.htm',60,'文章','2010-12-14 21:36:26',1,0,1),(63,1,1,'模板-33.jpg',NULL,'/article/image/2010_4/12_14/fprbghou6kyz.jpg','fprbghou6kyz.jpg',14,0,'33 - Black PU Casters','/Products/61.htm',61,'文章','2010-12-14 21:37:00',1,0,1),(64,1,1,'模板-33.jpg',NULL,'/article/image/2010_4/12_14/qnn6ghou6dnn.jpg','qnn6ghou6dnn.jpg',255,0,'33 - Black PU Casters','/Products/61.htm',61,'文章','2010-12-14 21:37:00',1,0,1),(65,1,1,'模板-31.jpg',NULL,'/article/image/2010_4/12_14/mua6ghou7c0t.jpg','mua6ghou7c0t.jpg',15,0,'31 - Scaffolding Casters','/Products/62.htm',62,'文章','2010-12-14 21:37:38',1,0,1),(66,1,1,'模板-31.jpg',NULL,'/article/image/2010_4/12_14/rvx1ghou71wn.jpg','rvx1ghou71wn.jpg',280,0,'31 - Scaffolding Casters','/Products/62.htm',62,'文章','2010-12-14 21:37:38',1,0,1),(67,1,1,'模板-30.jpg',NULL,'/article/image/2010_4/12_14/4i30ghou80ee.jpg','4i30ghou80ee.jpg',15,0,'30 - EX. Heavy duty Casters','/Products/63.htm',63,'文章','2010-12-14 21:38:11',1,0,1),(68,1,1,'模板-30.jpg',NULL,'/article/image/2010_4/12_14/uod7ghou7uom.jpg','uod7ghou7uom.jpg',289,0,'30 - EX. Heavy duty Casters','/Products/63.htm',63,'文章','2010-12-14 21:38:11',1,0,1),(69,1,1,'模板-28.jpg',NULL,'/article/image/2010_4/12_14/4ykdghou8k5n.jpg','4ykdghou8k5n.jpg',231,0,'28 - Red PU & PVC scaffolding Casters','/Products/64.htm',64,'文章','2010-12-14 21:38:55',1,0,1),(70,1,1,'模板-28.jpg',NULL,'/article/image/2010_4/12_14/jfkvghou8opc.jpg','jfkvghou8opc.jpg',14,0,'28 - Red PU & PVC scaffolding Casters','/Products/64.htm',64,'文章','2010-12-14 21:38:55',1,0,1),(71,1,1,'模板-27.jpg',NULL,'/article/image/2010_4/12_14/ovjxghou9hml.jpg','ovjxghou9hml.jpg',224,0,'27 - Europscaffolding Casters','/Products/65.htm',65,'文章','2010-12-14 21:39:31',1,0,1),(72,1,1,'模板-27.jpg',NULL,'/article/image/2010_4/12_14/z9yeghou9n5p.jpg','z9yeghou9n5p.jpg',14,0,'27 - Europscaffolding Casters','/Products/65.htm',65,'文章','2010-12-14 21:39:31',1,0,1),(73,1,1,'模板-26.jpg',NULL,'/article/image/2010_4/12_14/z6s6ghouaf4j.jpg','z6s6ghouaf4j.jpg',15,0,'26 - Centipede Wheel','/Products/66.htm',66,'文章','2010-12-14 21:40:15',1,0,1),(74,1,1,'模板-26.jpg',NULL,'/article/image/2010_4/12_14/8zmgghoua93o.jpg','8zmgghoua93o.jpg',276,0,'26 - Centipede Wheel','/Products/66.htm',66,'文章','2010-12-14 21:40:15',1,0,1),(75,1,1,'模板-25.jpg',NULL,'/article/image/2010_4/12_14/edg8ghoubc1v.jpg','edg8ghoubc1v.jpg',14,0,'25 - Elastic rubber Casters','/Products/67.htm',67,'文章','2010-12-14 21:40:47',1,0,1),(76,1,1,'模板-25.jpg',NULL,'/article/image/2010_4/12_14/mhcfghoub6ue.jpg','mhcfghoub6ue.jpg',274,0,'25 - Elastic rubber Casters','/Products/67.htm',67,'文章','2010-12-14 21:40:47',1,0,1),(77,1,1,'模板-24.jpg',NULL,'/article/image/2010_4/12_14/nhgyghouc9x1.jpg','nhgyghouc9x1.jpg',15,0,'24 - Red PU Casters','/Products/68.htm',68,'文章','2010-12-14 21:41:16',1,0,1),(78,1,1,'模板-24.jpg',NULL,'/article/image/2010_4/12_14/wc90ghoubv8l.jpg','wc90ghoubv8l.jpg',244,0,'24 - Red PU Casters','/Products/68.htm',68,'文章','2010-12-14 21:41:16',1,0,1),(79,1,1,'模板-23.jpg',NULL,'/article/image/2010_4/12_14/38afghoud1kz.jpg','38afghoud1kz.jpg',14,0,'23 - Industrial Casters','/Products/69.htm',69,'文章','2010-12-14 21:41:52',1,0,1),(80,1,1,'模板-23.jpg',NULL,'/article/image/2010_4/12_14/anm7ghouchww.jpg','anm7ghouchww.jpg',272,0,'23 - Industrial Casters','/Products/69.htm',69,'文章','2010-12-14 21:41:52',1,0,1),(93,1,1,'模板-15.jpg',NULL,'/article/image/2010_4/12_14/2lhtghouh73w.jpg','2lhtghouh73w.jpg',314,0,'15 - Blue frame Casters','/Products/76.htm',76,'文章','2010-12-14 21:45:20',1,0,1),(94,1,1,'模板-15.jpg',NULL,'/article/image/2010_4/12_14/bq8cghouhbyg.jpg','bq8cghouhbyg.jpg',15,0,'15 - Blue frame Casters','/Products/76.htm',76,'文章','2010-12-14 21:45:20',1,0,1),(95,1,1,'模板-14.jpg',NULL,'/article/image/2010_4/12_14/b48yghouhys5.jpg','b48yghouhys5.jpg',14,0,'14 - Blue frame Casters','/Products/77.htm',77,'文章','2010-12-14 21:45:53',1,0,1),(96,1,1,'模板-14.jpg',NULL,'/article/image/2010_4/12_14/pqy2ghouhu5l.jpg','pqy2ghouhu5l.jpg',267,0,'14 - Blue frame Casters','/Products/77.htm',77,'文章','2010-12-14 21:45:53',1,0,1),(97,1,1,'模板-13.jpg',NULL,'/article/image/2010_4/12_14/3gblghouir6w.jpg','3gblghouir6w.jpg',14,0,'13 - Polyurethane Casters','/Products/78.htm',78,'文章','2010-12-14 21:46:28',1,0,1),(98,1,1,'模板-13.jpg',NULL,'/article/image/2010_4/12_14/qpgbghouiiaa.jpg','qpgbghouiiaa.jpg',261,0,'13 - Polyurethane Casters','/Products/78.htm',78,'文章','2010-12-14 21:46:28',1,0,1),(99,1,1,'模板-12.jpg',NULL,'/article/image/2010_4/12_14/oot4ghouj7d9.jpg','oot4ghouj7d9.jpg',279,0,'12 - Standard Casters','/Products/79.htm',79,'文章','2010-12-14 21:46:58',1,0,1),(100,1,1,'模板-12.jpg',NULL,'/article/image/2010_4/12_14/xza1ghoujdcc.jpg','xza1ghoujdcc.jpg',14,0,'12 - Standard Casters','/Products/79.htm',79,'文章','2010-12-14 21:46:58',1,0,1),(101,1,1,'模板-11.jpg',NULL,'/article/image/2010_4/12_14/1gl2ghoujtrw.jpg','1gl2ghoujtrw.jpg',235,0,'11 - Red pu Casters','/Products/80.htm',80,'文章','2010-12-14 21:47:22',1,0,1),(102,1,1,'模板-11.jpg',NULL,'/article/image/2010_4/12_14/vlkqghoujyj0.jpg','vlkqghoujyj0.jpg',14,0,'11 - Red pu Casters','/Products/80.htm',80,'文章','2010-12-14 21:47:22',1,0,1),(103,1,1,'模板-10.jpg',NULL,'/article/image/2010_4/12_14/t7brghoukfsi.jpg','t7brghoukfsi.jpg',265,0,'10 - Polyurethane on aluminium Casters','/Products/81.htm',81,'文章','2010-12-14 21:48:02',1,0,1),(104,1,1,'模板-10.jpg',NULL,'/article/image/2010_4/12_14/j0idghoukopl.jpg','j0idghoukopl.jpg',15,0,'10 - Polyurethane on aluminium Casters','/Products/81.htm',81,'文章','2010-12-14 21:48:02',1,0,1),(105,1,1,'模板-9.jpg',NULL,'/article/image/2010_4/12_14/h8wpghoulcnw.jpg','h8wpghoulcnw.jpg',14,0,'9 - Furniture Casters','/Products/82.htm',82,'文章','2010-12-14 21:48:27',1,0,1),(106,1,1,'模板-9.jpg',NULL,'/article/image/2010_4/12_14/m06wghoul72z.jpg','m06wghoul72z.jpg',253,0,'9 - Furniture Casters','/Products/82.htm',82,'文章','2010-12-14 21:48:27',1,0,1),(107,1,1,'模板-8.jpg',NULL,'/article/image/2010_4/12_14/q8h6ghoulrsy.jpg','q8h6ghoulrsy.jpg',215,0,'8 - Shock absorption Casters','/Products/83.htm',83,'文章','2010-12-14 21:49:04',1,0,1),(108,1,1,'模板-8.jpg',NULL,'/article/image/2010_4/12_14/amuwghoulw6l.jpg','amuwghoulw6l.jpg',13,0,'8 - Shock absorption Casters','/Products/83.htm',83,'文章','2010-12-14 21:49:04',1,0,1),(109,1,1,'模板-7.jpg',NULL,'/article/image/2010_4/12_14/r4n3ghoumigt.jpg','r4n3ghoumigt.jpg',234,0,'7 - Shock abSorption Casters','/Products/84.htm',84,'文章','2010-12-14 21:49:40',1,0,1),(110,1,1,'模板-7.jpg',NULL,'/article/image/2010_4/12_14/nzbhghoumob5.jpg','nzbhghoumob5.jpg',13,0,'7 - Shock abSorption Casters','/Products/84.htm',84,'文章','2010-12-14 21:49:40',1,0,1),(111,1,1,'模板-6.jpg',NULL,'/article/image/2010_4/12_14/fs9tghounevy.jpg','fs9tghounevy.jpg',14,0,'6 - Polyurethane on polyolefin Casters','/Products/85.htm',85,'文章','2010-12-14 21:50:17',1,0,1),(112,1,1,'模板-6.jpg',NULL,'/article/image/2010_4/12_14/9bnfghounai5.jpg','9bnfghounai5.jpg',251,0,'6 - Polyurethane on polyolefin Casters','/Products/85.htm',85,'文章','2010-12-14 21:50:17',1,0,1),(113,1,1,'模板-5.jpg',NULL,'/article/image/2010_4/12_14/7ul9ghouo2k5.jpg','7ul9ghouo2k5.jpg',259,0,'5 - Blue Frame Casters','/Products/86.htm',86,'文章','2010-12-14 21:50:46',1,0,1),(114,1,1,'模板-5.jpg',NULL,'/article/image/2010_4/12_14/wlq8ghouoamc.jpg','wlq8ghouoamc.jpg',14,0,'5 - Blue Frame Casters','/Products/86.htm',86,'文章','2010-12-14 21:50:46',1,0,1),(115,1,1,'模板-4.jpg',NULL,'/article/image/2010_4/12_14/afi1ghouoq8x.jpg','afi1ghouoq8x.jpg',269,0,'4 - Heavy duty Casters','/Products/87.htm',87,'文章','2010-12-14 21:51:18',1,0,1),(116,1,1,'模板-4.jpg',NULL,'/article/image/2010_4/12_14/fc4vghouozc7.jpg','fc4vghouozc7.jpg',15,0,'4 - Heavy duty Casters','/Products/87.htm',87,'文章','2010-12-14 21:51:18',1,0,1),(117,1,1,'模板-3.jpg',NULL,'/article/image/2010_4/12_14/kxo9ghoupnan.jpg','kxo9ghoupnan.jpg',266,0,'3 - Foam rubber wheel Casters','/Products/88.htm',88,'文章','2010-12-14 21:52:02',1,0,1),(118,1,1,'模板-3.jpg',NULL,'/article/image/2010_4/12_14/795lghoupttw.jpg','795lghoupttw.jpg',15,0,'3 - Foam rubber wheel Casters','/Products/88.htm',88,'文章','2010-12-14 21:52:02',1,0,1),(119,1,1,'模板-2.jpg',NULL,'/article/image/2010_4/12_14/ekjvghouqecu.jpg','ekjvghouqecu.jpg',238,0,'2 - Furniture Casters','/Products/89.htm',89,'文章','2010-12-14 21:52:36',1,0,1),(120,1,1,'模板-2.jpg',NULL,'/article/image/2010_4/12_14/tljvghouqinu.jpg','tljvghouqinu.jpg',15,0,'2 - Furniture Casters','/Products/89.htm',89,'文章','2010-12-14 21:52:36',1,0,1),(121,1,1,'模板-1.jpg',NULL,'/article/image/2010_4/12_14/erkjghour5gj.jpg','erkjghour5gj.jpg',220,0,'1 - Tweenwheel casters','/Products/90.htm',90,'文章','2010-12-14 21:53:19',1,0,1),(122,1,1,'模板-1.jpg',NULL,'/article/image/2010_4/12_14/uch2ghour9t2.jpg','uch2ghour9t2.jpg',14,0,'1 - Tweenwheel casters','/Products/90.htm',90,'文章','2010-12-14 21:53:19',1,0,1),(123,1,1,'26_PVC丝扣.jpg',NULL,'/article/image/2010_4/12_14/7gzpghoye5pm.jpg','7gzpghoye5pm.jpg',15,0,'26 - PP CASTER','/Products2/91.htm',91,'文章','2010-12-14 23:34:51',1,0,1),(124,1,1,'26_PVC丝扣.jpg',NULL,'/article/image/2010_4/12_14/dztaghoydxav.jpg','dztaghoydxav.jpg',232,0,'26 - PP CASTER','/Products2/91.htm',91,'文章','2010-12-14 23:34:51',1,0,1),(125,1,1,'25_黄色扁轮.jpg',NULL,'/article/image/2010_4/12_14/xma7ghoyfpf0.jpg','xma7ghoyfpf0.jpg',237,0,'25 - Yellow color PU Casters','/Products2/92.htm',92,'文章','2010-12-14 23:36:18',1,0,1),(126,1,1,'25_黄色扁轮.jpg',NULL,'/article/image/2010_4/12_14/npexghoyftpf.jpg','npexghoyftpf.jpg',15,0,'25 - Yellow color PU Casters','/Products2/92.htm',92,'文章','2010-12-14 23:36:18',1,0,1),(127,1,1,'24_PVC+单轮.jpg',NULL,'/article/image/2010_4/12_14/o51jghoygk08.jpg','o51jghoygk08.jpg',15,0,'24 - PVC Wheels','/Products2/93.htm',93,'文章','2010-12-14 23:36:42',1,0,1),(128,1,1,'24_PVC+单轮.jpg',NULL,'/article/image/2010_4/12_14/o6a1ghoygf7u.jpg','o6a1ghoygf7u.jpg',255,0,'24 - PVC Wheels','/Products2/93.htm',93,'文章','2010-12-14 23:36:42',1,0,1),(129,1,1,'23_铝芯+单轮.jpg',NULL,'/article/image/2010_4/12_14/3mzsghoygxdy.jpg','3mzsghoygxdy.jpg',247,0,'23 - ALUMINIUM CASTER','/Products2/94.htm',94,'文章','2010-12-14 23:37:08',1,0,1),(130,1,1,'23_铝芯+单轮.jpg',NULL,'/article/image/2010_4/12_14/qox2ghoyh1b5.jpg','qox2ghoyh1b5.jpg',15,0,'23 - ALUMINIUM CASTER','/Products2/94.htm',94,'文章','2010-12-14 23:37:08',1,0,1),(131,1,1,'22_耐油轮+PP.jpg',NULL,'/article/image/2010_4/12_14/76lwghoyhhco.jpg','76lwghoyhhco.jpg',246,0,'22 - Oil protected Casters','/Products2/95.htm',95,'文章','2010-12-14 23:37:35',1,0,1),(132,1,1,'22_耐油轮+PP.jpg',NULL,'/article/image/2010_4/12_14/tilcghoyhlhf.jpg','tilcghoyhlhf.jpg',15,0,'22 - Oil protected Casters','/Products2/95.htm',95,'文章','2010-12-14 23:37:35',1,0,1),(133,1,1,'21_SCHNIDER+铝芯.jpg',NULL,'/article/image/2010_4/12_14/jd6bghoyi6wz.jpg','jd6bghoyi6wz.jpg',15,0,'21 - BLACK PP+ RUBBER WHEEL AND SCHNIDER CASTERS','/Products2/96.htm',96,'文章','2010-12-14 23:38:17',1,0,1),(134,1,1,'21_SCHNIDER+铝芯.jpg',NULL,'/article/image/2010_4/12_14/yof6ghoyi2sk.jpg','yof6ghoyi2sk.jpg',252,0,'21 - BLACK PP+ RUBBER WHEEL AND SCHNIDER CASTERS','/Products2/96.htm',96,'文章','2010-12-14 23:38:17',1,0,1),(135,1,1,'20_PU鹰架+PVC.jpg',NULL,'/article/image/2010_4/12_14/2784ghoyjmcl.jpg','2784ghoyjmcl.jpg',244,0,'21 - Scaffolding Casters with PU wheel','/Products2/97.htm',97,'文章','2010-12-14 23:39:32',1,0,1),(136,1,1,'20_PU鹰架+PVC.jpg',NULL,'/article/image/2010_4/12_14/ci36ghoyjt5o.jpg','ci36ghoyjt5o.jpg',15,0,'21 - Scaffolding Casters with PU wheel','/Products2/97.htm',97,'文章','2010-12-14 23:39:32',1,0,1),(137,1,1,'20_PU鹰架+PVC.jpg',NULL,'/article/image/2010_4/12_14/zgtughoyl8ja.jpg','zgtughoyl8ja.jpg',15,0,'20 - Scaffolding Casters with PU wheel','/Products2/98.htm',98,'文章','2010-12-14 23:40:15',1,0,1),(138,1,1,'20_PU鹰架+PVC.jpg',NULL,'/article/image/2010_4/12_14/00rvghoyks48.jpg','00rvghoyks48.jpg',244,0,'20 - Scaffolding Casters with PU wheel','/Products2/98.htm',98,'文章','2010-12-14 23:40:15',1,0,1),(139,1,1,'19_肥仔轮.jpg',NULL,'/article/image/2010_4/12_14/fnorghoyln2q.jpg','fnorghoyln2q.jpg',14,0,'19 - STANDARD CASTERS','/Products2/99.htm',99,'文章','2010-12-14 23:42:01',1,0,1),(140,1,1,'19_肥仔轮.jpg',NULL,'/article/image/2010_4/12_14/qwujghoylhcb.jpg','qwujghoylhcb.jpg',251,0,'19 - STANDARD CASTERS','/Products2/99.htm',99,'文章','2010-12-14 23:42:01',1,0,1),(141,1,1,'18_风火轮+割草轮.jpg',NULL,'/article/image/2010_4/12_14/v0s2ghoynxr3.jpg','v0s2ghoynxr3.jpg',15,0,'18 - Heavy duty ball Bearing Casters','/Products2/100.htm',100,'文章','2010-12-14 23:42:33',1,0,1),(142,1,1,'18_风火轮+割草轮.jpg',NULL,'/article/image/2010_4/12_14/qbakghoynto3.jpg','qbakghoynto3.jpg',255,0,'18 - Heavy duty ball Bearing Casters','/Products2/100.htm',100,'文章','2010-12-14 23:42:33',1,0,1),(143,1,1,'16_尼龙轮.jpg',NULL,'/article/image/2010_4/12_14/p59xghoyog3m.jpg','p59xghoyog3m.jpg',214,0,'16 - TWEEN WHEEL CASTERS','/Products2/101.htm',101,'文章','2010-12-14 23:43:00',1,0,1),(144,1,1,'16_尼龙轮.jpg',NULL,'/article/image/2010_4/12_14/crgqghoyok40.jpg','crgqghoyok40.jpg',14,0,'16 - TWEEN WHEEL CASTERS','/Products2/101.htm',101,'文章','2010-12-14 23:43:00',1,0,1),(145,1,1,'15_尼龙轮.jpg',NULL,'/article/image/2010_4/12_14/ne6dghoyp3z9.jpg','ne6dghoyp3z9.jpg',13,0,'15 - TWEEN WHEEL CASTERS','/Products2/102.htm',102,'文章','2010-12-14 23:43:18',1,0,1),(146,1,1,'15_尼龙轮.jpg',NULL,'/article/image/2010_4/12_14/o8jlghoyp08u.jpg','o8jlghoyp08u.jpg',230,0,'15 - TWEEN WHEEL CASTERS','/Products2/102.htm',102,'文章','2010-12-14 23:43:18',1,0,1),(147,1,1,'14_波轮带刹+白色扁轮.jpg',NULL,'/article/image/2010_4/12_14/sh9lghoypi77.jpg','sh9lghoypi77.jpg',16,0,'14 - Ball Casters','/Products2/103.htm',103,'文章','2010-12-14 23:43:40',1,0,1),(148,1,1,'14_波轮带刹+白色扁轮.jpg',NULL,'/article/image/2010_4/12_14/hnl0ghoypesk.jpg','hnl0ghoypesk.jpg',238,0,'14 - Ball Casters','/Products2/103.htm',103,'文章','2010-12-14 23:43:40',1,0,1),(149,1,1,'13_波轮.jpg',NULL,'/article/image/2010_4/12_14/22ggghoypv0o.jpg','22ggghoypv0o.jpg',211,0,'13 - Ball Casters','/Products2/104.htm',104,'文章','2010-12-14 23:44:00',1,0,1),(150,1,1,'13_波轮.jpg',NULL,'/article/image/2010_4/12_14/z6phghoypydl.jpg','z6phghoypydl.jpg',15,0,'13 - Ball Casters','/Products2/104.htm',104,'文章','2010-12-14 23:44:00',1,0,1),(151,1,1,'12_灰胶轮-2.jpg',NULL,'/article/image/2010_4/12_14/a8e7ghoyqhcd.jpg','a8e7ghoyqhcd.jpg',14,0,'12 - GREY RUBBER CASTER(2)','/Products2/105.htm',105,'文章','2010-12-14 23:44:46',1,0,1),(152,1,1,'12_灰胶轮-2.jpg',NULL,'/article/image/2010_4/12_14/csu6ghoyqd3u.jpg','csu6ghoyqd3u.jpg',254,0,'12 - GREY RUBBER CASTER(2)','/Products2/105.htm',105,'文章','2010-12-14 23:44:46',1,0,1),(153,1,1,'11_灰胶轮-1.jpg',NULL,'/article/image/2010_4/12_14/5j3kghoyrdqy.jpg','5j3kghoyrdqy.jpg',293,0,'11 - GREY RUBBER CASTERS(1)','/Products2/106.htm',106,'文章','2010-12-14 23:45:14',1,0,1),(154,1,1,'11_灰胶轮-1.jpg',NULL,'/article/image/2010_4/12_14/sigqghoyrhiw.jpg','sigqghoyrhiw.jpg',15,0,'11 - GREY RUBBER CASTERS(1)','/Products2/106.htm',106,'文章','2010-12-14 23:45:14',1,0,1),(155,1,1,'10_重型轮.jpg',NULL,'/article/image/2010_4/12_14/0q8bghoys1mz.jpg','0q8bghoys1mz.jpg',15,0,'10 - Single wheel','/Products2/107.htm',107,'文章','2010-12-14 23:45:37',1,0,1),(156,1,1,'10_重型轮.jpg',NULL,'/article/image/2010_4/12_14/e5p2ghoyrxe0.jpg','e5p2ghoyrxe0.jpg',267,0,'10 - Single wheel','/Products2/107.htm',107,'文章','2010-12-14 23:45:37',1,0,1),(157,1,1,'9_扁轮（黑色）.jpg',NULL,'/article/image/2010_4/12_14/zj1qghoyshqf.jpg','zj1qghoyshqf.jpg',15,0,'9 - N.P. Casters With Rubber Wheel','/Products2/108.htm',108,'文章','2010-12-14 23:46:07',1,0,1),(158,1,1,'9_扁轮（黑色）.jpg',NULL,'/article/image/2010_4/12_14/5ikbghoyse0j.jpg','5ikbghoyse0j.jpg',262,0,'9 - N.P. Casters With Rubber Wheel','/Products2/108.htm',108,'文章','2010-12-14 23:46:07',1,0,1),(159,1,1,'7_重型PU.jpg',NULL,'/article/image/2010_4/12_14/ji27ghoyt1n6.jpg','ji27ghoyt1n6.jpg',253,0,'7 - Heavy duty Casters with red PU wheel','/Products2/109.htm',109,'文章','2010-12-14 23:46:42',1,0,1),(160,1,1,'7_重型PU.jpg',NULL,'/article/image/2010_4/12_14/p9v7ghoyt6pv.jpg','p9v7ghoyt6pv.jpg',15,0,'7 - Heavy duty Casters with red PU wheel','/Products2/109.htm',109,'文章','2010-12-14 23:46:42',1,0,1),(161,1,1,'6_重型包胶+PU.jpg',NULL,'/article/image/2010_4/12_14/7lzoghoytu86.jpg','7lzoghoytu86.jpg',309,0,'6 - Heavy duty Casters','/Products2/110.htm',110,'文章','2010-12-14 23:47:11',1,0,1),(162,1,1,'6_重型包胶+PU.jpg',NULL,'/article/image/2010_4/12_14/smnbghoytzbo.jpg','smnbghoytzbo.jpg',16,0,'6 - Heavy duty Casters','/Products2/110.htm',110,'文章','2010-12-14 23:47:11',1,0,1),(163,1,1,'5_重型铸铁+包胶.jpg',NULL,'/article/image/2010_4/12_14/lymqghoyufd6.jpg','lymqghoyufd6.jpg',310,0,'5 - Heavy duty Casters','/Products2/111.htm',111,'文章','2010-12-14 23:47:36',1,0,1),(164,1,1,'5_重型铸铁+包胶.jpg',NULL,'/article/image/2010_4/12_14/vc0eghoyujfn.jpg','vc0eghoyujfn.jpg',16,0,'5 - Heavy duty Casters','/Products2/111.htm',111,'文章','2010-12-14 23:47:36',1,0,1),(165,1,1,'4_PVC+铸铁轮.jpg',NULL,'/article/image/2010_4/12_14/wof7ghoyv3jw.jpg','wof7ghoyv3jw.jpg',15,0,'4 - Induatrial Casters with PVC wheel','/Products2/112.htm',112,'文章','2010-12-14 23:48:07',1,0,1),(166,1,1,'4_PVC+铸铁轮.jpg',NULL,'/article/image/2010_4/12_14/sfywghoyuyks.jpg','sfywghoyuyks.jpg',314,0,'4 - Induatrial Casters with PVC wheel','/Products2/112.htm',112,'文章','2010-12-14 23:48:07',1,0,1),(167,1,1,'3_工业白PP.jpg',NULL,'/article/image/2010_4/12_14/glx3ghoyvm8n.jpg','glx3ghoyvm8n.jpg',313,0,'3 - Industrial Casters With PP Wheel','/Products2/113.htm',113,'文章','2010-12-14 23:48:38',1,0,1),(168,1,1,'3_工业白PP.jpg',NULL,'/article/image/2010_4/12_14/lyctghoyvq5u.jpg','lyctghoyvq5u.jpg',16,0,'3 - Industrial Casters With PP Wheel','/Products2/113.htm',113,'文章','2010-12-14 23:48:38',1,0,1),(169,1,1,'2工业轮.jpg',NULL,'/article/image/2010_4/12_14/6viyghoywemu.jpg','6viyghoywemu.jpg',15,0,'2 - Industrial Casters','/Products2/114.htm',114,'文章','2010-12-14 23:49:05',1,0,1),(170,1,1,'2工业轮.jpg',NULL,'/article/image/2010_4/12_14/bik0ghoywaxu.jpg','bik0ghoywaxu.jpg',270,0,'2 - Industrial Casters','/Products2/114.htm',114,'文章','2010-12-14 23:49:05',1,0,1),(171,1,1,'1_工业轮.jpg',NULL,'/article/image/2010_4/12_14/4d6gghoyx1cb.jpg','4d6gghoyx1cb.jpg',16,0,'1 - Industrial Casters','/Products2/115.htm',115,'文章','2010-12-14 23:49:28',1,0,1),(172,1,1,'1_工业轮.jpg',NULL,'/article/image/2010_4/12_14/r7c3ghoywtyi.jpg','r7c3ghoywtyi.jpg',319,0,'1 - Industrial Casters','/Products2/115.htm',115,'文章','2010-12-14 23:49:28',1,0,1),(175,1,1,'妯℃澘-21.jpg',NULL,'/article/image/2010_4/12_15/1bunghqbf9r5.jpg','1bunghqbf9r5.jpg',15,0,'21 - Available wheels','/Products1/117.htm',117,'文章','2010-12-15 22:27:40',1,0,1),(176,1,1,'妯℃澘-21.jpg',NULL,'/article/image/2010_4/12_15/bhfpghqbwv0r.jpg','bhfpghqbwv0r.jpg',256,0,'21 - Available wheels','/Products1/117.htm',117,'文章','2010-12-15 22:40:58',1,0,1),(177,1,1,'妯℃澘-29.jpg',NULL,'/article/image/2010_4/12_15/ozu8ghqc5owk.jpg','ozu8ghqc5owk.jpg',15,0,'29 - Ex. heavy duty Casters','/Products1/118.htm',118,'文章','2010-12-15 22:47:54',1,0,1),(178,1,1,'妯℃澘-29.jpg',NULL,'/article/image/2010_4/12_15/y0uyghqc4xuv.jpg','y0uyghqc4xuv.jpg',297,0,'29 - Ex. heavy duty Casters','/Products1/118.htm',118,'文章','2010-12-15 22:47:54',1,0,1),(179,1,1,'妯℃澘-32.jpg',NULL,'/article/image/2010_4/12_16/8yd0ghqfzeem.jpg','8yd0ghqfzeem.jpg',14,0,'32 - Furniture Casters','/Products1/119.htm',119,'文章','2010-12-16 00:35:12',1,0,1),(180,1,1,'妯℃澘-32.jpg',NULL,'/article/image/2010_4/12_16/jyiighqfytkm.jpg','jyiighqfytkm.jpg',247,0,'32 - Furniture Casters','/Products1/119.htm',119,'文章','2010-12-16 00:35:12',1,0,1),(181,1,1,'8_楣版灦.jpg',NULL,'/article/image/2010_4/12_16/28idghqgci6z.jpg','28idghqgci6z.jpg',249,0,'8 - Scaffolding Casters','/Products2/120.htm',120,'文章','2010-12-16 00:45:35',1,0,1),(182,1,1,'8_楣版灦.jpg',NULL,'/article/image/2010_4/12_16/b0hpghqgcopq.jpg','b0hpghqgcopq.jpg',15,0,'8 - Scaffolding Casters','/Products2/120.htm',120,'文章','2010-12-16 00:45:35',1,0,1),(183,1,1,'17_冲气轮.jpg',NULL,'/article/image/2010_4/12_16/r816ghqgdk3w.jpg','r816ghqgdk3w.jpg',14,0,'17 - Penumatic Casters','/Products2/121.htm',121,'文章','2010-12-16 00:47:38',1,0,1),(184,1,1,'17_冲气轮.jpg',NULL,'/article/image/2010_4/12_16/6ldjghqgdekn.jpg','6ldjghqgdekn.jpg',250,0,'17 - Penumatic Casters','/Products2/121.htm',121,'文章','2010-12-16 00:47:38',1,0,1),(187,1,1,'2.jpg',NULL,'/article/image/2011_4/11_3/o0fegujsug1g.jpg','o0fegujsug1g.jpg',208,0,'1new','/Products1/122.htm',122,'文章','2011-11-03 21:38:04',1,0,1),(188,1,1,'2S.jpg',NULL,'/article/image/2011_4/11_3/snykgujsv9b7.jpg','snykgujsv9b7.jpg',20,0,'1new','/Products1/122.htm',122,'文章','2011-11-03 21:38:04',1,0,1),(189,1,1,'T3S.jpg',NULL,'/article/image/2011_4/11_3/zod5gujuroo6.jpg','zod5gujuroo6.jpg',20,0,'2new','/Products1/123.htm',123,'文章','2011-11-03 22:30:46',1,0,1),(190,1,1,'T3.jpg',NULL,'/article/image/2011_4/11_3/gcs4gujuqlyf.jpg','gcs4gujuqlyf.jpg',199,0,'2new','/Products1/123.htm',123,'文章','2011-11-03 22:30:46',1,0,1),(191,1,1,'F2s.jpg',NULL,'/article/image/2011_4/11_3/ipvmgujvqmrr.jpg','ipvmgujvqmrr.jpg',21,0,'3new','/Products1/124.htm',124,'文章','2011-11-03 23:00:21',1,0,1),(192,1,1,'F2.jpg',NULL,'/article/image/2011_4/11_3/qmpagujvtoas.jpg','qmpagujvtoas.jpg',189,0,'3new','/Products1/124.htm',124,'文章','2011-11-03 23:00:21',1,0,1),(195,1,1,'1.jpg',NULL,'/article/image/2012_1/2_28/b2lugz6rtfjl.jpg','b2lugz6rtfjl.jpg',14,0,'4new','/Products1/126.htm',126,'文章','2012-02-28 18:05:32',1,0,1),(196,1,1,'大图2.jpg',NULL,'/article/image/2012_1/2_28/lv9agz6rt0ot.jpg','lv9agz6rt0ot.jpg',175,0,'4new','/Products1/126.htm',126,'文章','2012-02-28 18:05:32',1,0,1),(197,1,1,'1_副本_副本_副本_副本.jpg',NULL,'/article/image/2013_2/4_10/bwc9hfc22mzx.jpg','bwc9hfc22mzx.jpg',23,0,'new','/Products1/128.htm',128,'文章','2013-04-10 13:27:01',1,0,1),(198,1,1,'1_副本_副本_副本.jpg',NULL,'/article/image/2013_2/4_10/ryqzhfc222y7.jpg','ryqzhfc222y7.jpg',119,0,'new','/Products1/128.htm',128,'文章','2013-04-10 13:27:01',1,0,1),(244,1,1,'22.jpg',NULL,'/article/image/2013_3/9_10/j5vrhlelywd1.jpg','j5vrhlelywd1.jpg',249,0,'New 22','/Products1/152.htm',152,'文章','2013-09-10 12:17:55',1,0,1),(245,1,1,'22_编辑.jpg',NULL,'/article/image/2013_3/9_10/5tj8hlelzbhz.jpg','5tj8hlelzbhz.jpg',40,0,'New 22','/Products1/152.htm',152,'文章','2013-09-10 12:17:55',1,0,1),(246,1,1,'21_编辑.jpg',NULL,'/article/image/2013_3/9_10/osv1hlem0430.jpg','osv1hlem0430.jpg',44,0,'New 21','/Products1/153.htm',153,'文章','2013-09-10 12:18:26',1,0,1),(247,1,1,'21.jpg',NULL,'/article/image/2013_3/9_10/nfoshlelzuf0.jpg','nfoshlelzuf0.jpg',273,0,'New 21','/Products1/153.htm',153,'文章','2013-09-10 12:18:26',1,0,1),(248,1,1,'20_编辑.jpg',NULL,'/article/image/2013_3/9_10/wt52hlem0u56.jpg','wt52hlem0u56.jpg',39,0,'New 20','/Products1/154.htm',154,'文章','2013-09-10 12:18:59',1,0,1),(249,1,1,'20.jpg',NULL,'/article/image/2013_3/9_10/fuy7hlem0isr.jpg','fuy7hlem0isr.jpg',242,0,'New 20','/Products1/154.htm',154,'文章','2013-09-10 12:18:59',1,0,1),(250,1,1,'19.jpg',NULL,'/article/image/2013_3/9_10/ksuihlem17p7.jpg','ksuihlem17p7.jpg',272,0,'New 19','/Products1/155.htm',155,'文章','2013-09-10 12:19:26',1,0,1),(251,1,1,'19_编辑.jpg',NULL,'/article/image/2013_3/9_10/gvh5hlem1f7o.jpg','gvh5hlem1f7o.jpg',43,0,'New 19','/Products1/155.htm',155,'文章','2013-09-10 12:19:26',1,0,1),(252,1,1,'18_编辑.jpg',NULL,'/article/image/2013_3/9_10/92p9hlem21r0.jpg','92p9hlem21r0.jpg',38,0,'New 18','/Products1/156.htm',156,'文章','2013-09-10 12:19:55',1,0,1),(253,1,1,'18.jpg',NULL,'/article/image/2013_3/9_10/77mfhlem1srh.jpg','77mfhlem1srh.jpg',245,0,'New 18','/Products1/156.htm',156,'文章','2013-09-10 12:19:55',1,0,1),(254,1,1,'17.jpg',NULL,'/article/image/2013_3/9_10/pmeihlem2f8i.jpg','pmeihlem2f8i.jpg',257,0,'New 17','/Products1/157.htm',157,'文章','2013-09-10 12:20:23',1,0,1),(255,1,1,'17_编辑.jpg',NULL,'/article/image/2013_3/9_10/tlakhlem2mw4.jpg','tlakhlem2mw4.jpg',41,0,'New 17','/Products1/157.htm',157,'文章','2013-09-10 12:20:23',1,0,1),(256,1,1,'16.jpg',NULL,'/article/image/2013_3/9_10/agpphlemkh8j.jpg','agpphlemkh8j.jpg',249,0,'New 16','/Products1/158.htm',158,'文章','2013-09-10 12:34:25',1,0,1),(257,1,1,'16_编辑.jpg',NULL,'/article/image/2013_3/9_10/zmc4hlemkp2w.jpg','zmc4hlemkp2w.jpg',41,0,'New 16','/Products1/158.htm',158,'文章','2013-09-10 12:34:25',1,0,1),(258,1,1,'15_编辑.jpg',NULL,'/article/image/2013_3/9_10/rrc6hleml99z.jpg','rrc6hleml99z.jpg',40,0,'New 15','/Products1/159.htm',159,'文章','2013-09-10 12:34:51',1,0,1),(259,1,1,'15.jpg',NULL,'/article/image/2013_3/9_10/96mihleml1t1.jpg','96mihleml1t1.jpg',236,0,'New 15','/Products1/159.htm',159,'文章','2013-09-10 12:34:51',1,0,1),(260,1,1,'14_编辑.jpg',NULL,'/article/image/2013_3/9_10/vorkhlemlv86.jpg','vorkhlemlv86.jpg',40,0,'New 14','/Products1/160.htm',160,'文章','2013-09-10 12:35:20',1,0,1),(261,1,1,'14.jpg',NULL,'/article/image/2013_3/9_10/zfachlemlnup.jpg','zfachlemlnup.jpg',229,0,'New 14','/Products1/160.htm',160,'文章','2013-09-10 12:35:20',1,0,1),(262,1,1,'13.jpg',NULL,'/article/image/2013_3/9_10/1ca1hlemm8hx.jpg','1ca1hlemm8hx.jpg',231,0,'New 13','/Products1/161.htm',161,'文章','2013-09-10 12:35:46',1,0,1),(263,1,1,'13_编辑.jpg',NULL,'/article/image/2013_3/9_10/hei7hlemmfsf.jpg','hei7hlemmfsf.jpg',39,0,'New 13','/Products1/161.htm',161,'文章','2013-09-10 12:35:46',1,0,1),(264,1,1,'12_编辑.jpg',NULL,'/article/image/2013_3/9_10/ecghhlemn13p.jpg','ecghhlemn13p.jpg',38,0,'New 12','/Products1/162.htm',162,'文章','2013-09-10 12:36:15',1,0,1),(265,1,1,'12.jpg',NULL,'/article/image/2013_3/9_10/vh4shlemmu24.jpg','vh4shlemmu24.jpg',236,0,'New 12','/Products1/162.htm',162,'文章','2013-09-10 12:36:15',1,0,1),(266,1,1,'11.jpg',NULL,'/article/image/2013_3/9_10/d85rhlemnghz.jpg','d85rhlemnghz.jpg',232,0,'New 11','/Products1/163.htm',163,'文章','2013-09-10 12:36:48',1,0,1),(267,1,1,'11_编辑.jpg',NULL,'/article/image/2013_3/9_10/dbbihlemnqj5.jpg','dbbihlemnqj5.jpg',38,0,'New 11','/Products1/163.htm',163,'文章','2013-09-10 12:36:48',1,0,1),(268,1,1,'10.jpg',NULL,'/article/image/2013_3/9_10/we26hlemo2gn.jpg','we26hlemo2gn.jpg',224,0,'New 10','/Products1/164.htm',164,'文章','2013-09-10 12:37:14',1,0,1),(269,1,1,'10_编辑.jpg',NULL,'/article/image/2013_3/9_10/grijhlemobp6.jpg','grijhlemobp6.jpg',37,0,'New 10','/Products1/164.htm',164,'文章','2013-09-10 12:37:14',1,0,1),(270,1,1,'9.jpg',NULL,'/article/image/2013_3/9_10/9tq0hlemosxo.jpg','9tq0hlemosxo.jpg',237,0,'New 9','/Products1/165.htm',165,'文章','2013-09-10 12:37:47',1,0,1),(271,1,1,'9_编辑.jpg',NULL,'/article/image/2013_3/9_10/b317hlemp0sw.jpg','b317hlemp0sw.jpg',39,0,'New 9','/Products1/165.htm',165,'文章','2013-09-10 12:37:47',1,0,1),(272,1,1,'8_编辑.jpg',NULL,'/article/image/2013_3/9_10/k0auhlempot3.jpg','k0auhlempot3.jpg',40,0,'New 8','/Products1/166.htm',166,'文章','2013-09-10 12:38:18',1,0,1),(273,1,1,'8.jpg',NULL,'/article/image/2013_3/9_10/0l93hlempfq1.jpg','0l93hlempfq1.jpg',240,0,'New 8','/Products1/166.htm',166,'文章','2013-09-10 12:38:18',1,0,1),(274,1,1,'7_编辑.jpg',NULL,'/article/image/2013_3/9_10/qwqzhlemq76i.jpg','qwqzhlemq76i.jpg',38,0,'New 7','/Products1/167.htm',167,'文章','2013-09-10 12:38:42',1,0,1),(275,1,1,'7.jpg',NULL,'/article/image/2013_3/9_10/b43bhlemq0zz.jpg','b43bhlemq0zz.jpg',245,0,'New 7','/Products1/167.htm',167,'文章','2013-09-10 12:38:42',1,0,1),(276,1,1,'6.jpg',NULL,'/article/image/2013_3/9_10/fq65hlemqm5b.jpg','fq65hlemqm5b.jpg',256,0,'New 6','/Products1/168.htm',168,'文章','2013-09-10 12:39:12',1,0,1),(277,1,1,'6_编辑.jpg',NULL,'/article/image/2013_3/9_10/qy14hlemquaq.jpg','qy14hlemquaq.jpg',42,0,'New 6','/Products1/168.htm',168,'文章','2013-09-10 12:39:12',1,0,1),(278,1,1,'5_编辑.jpg',NULL,'/article/image/2013_3/9_10/ncl2hlemrktp.jpg','ncl2hlemrktp.jpg',38,0,'New 5','/Products1/169.htm',169,'文章','2013-09-10 12:39:47',1,0,1),(279,1,1,'5.jpg',NULL,'/article/image/2013_3/9_10/5jtmhlemr88c.jpg','5jtmhlemr88c.jpg',233,0,'New 5','/Products1/169.htm',169,'文章','2013-09-10 12:39:47',1,0,1),(280,1,1,'4.jpg',NULL,'/article/image/2013_3/9_10/x0yohlemryzr.jpg','x0yohlemryzr.jpg',248,0,'New 4','/Products1/170.htm',170,'文章','2013-09-10 12:40:16',1,0,1),(281,1,1,'4_编辑.jpg',NULL,'/article/image/2013_3/9_10/mfp2hlems5lm.jpg','mfp2hlems5lm.jpg',42,0,'New 4','/Products1/170.htm',170,'文章','2013-09-10 12:40:16',1,0,1),(282,1,1,'3_编辑.jpg',NULL,'/article/image/2013_3/9_10/3sh6hlemss1i.jpg','3sh6hlemss1i.jpg',41,0,'New 3','/Products1/171.htm',171,'文章','2013-09-10 12:40:42',1,0,1),(283,1,1,'3.jpg',NULL,'/article/image/2013_3/9_10/0f96hlemsjn0.jpg','0f96hlemsjn0.jpg',257,0,'New 3','/Products1/171.htm',171,'文章','2013-09-10 12:40:42',1,0,1),(284,1,1,'2_编辑.jpg',NULL,'/article/image/2013_3/9_10/3zwwhlemtb2m.jpg','3zwwhlemtb2m.jpg',41,0,'New 2','/Products1/172.htm',172,'文章','2013-09-10 12:41:06',1,0,1),(285,1,1,'2.jpg',NULL,'/article/image/2013_3/9_10/fu5vhlemt3ms.jpg','fu5vhlemt3ms.jpg',255,0,'New 2','/Products1/172.htm',172,'文章','2013-09-10 12:41:06',1,0,1),(286,1,1,'1_编辑.jpg',NULL,'/article/image/2013_3/9_10/orb2hlemtu06.jpg','orb2hlemtu06.jpg',41,0,'New 1','/Products1/173.htm',173,'文章','2013-09-10 12:41:32',1,0,1),(287,1,1,'1.jpg',NULL,'/article/image/2013_3/9_10/vfo0hlemtmaf.jpg','vfo0hlemtmaf.jpg',255,0,'New 1','/Products1/173.htm',173,'文章','2013-09-10 12:41:32',1,0,1),(290,1,1,'E-type_副本_副本.jpg',NULL,'/article/image/2016_2/5_25/m2qyioml0dp7.jpg','m2qyioml0dp7.jpg',67,0,'(New)Europe-type Industrial Casters','/Products2/175.htm',175,'文章','2016-05-25 16:01:19',1,0,1),(291,1,1,'E-type.jpg',NULL,'/article/image/2016_2/5_25/qh10iomkzx7f.jpg','qh10iomkzx7f.jpg',750,0,'(New)Europe-type Industrial Casters','/Products2/175.htm',175,'文章','2016-05-25 16:01:19',1,0,1),(292,1,1,'E-type G.jpg',NULL,'/article/image/2016_2/5_25/ht9mioml1w0l.jpg','ht9mioml1w0l.jpg',730,0,'(New)Europe-type Grey Rubber','/Products2/176.htm',176,'文章','2016-05-25 16:02:45',1,0,1),(293,1,1,'E-type G_副本_副本.jpg',NULL,'/article/image/2016_2/5_25/p35eioml27dy.jpg','p35eioml27dy.jpg',65,0,'(New)Europe-type Grey Rubber','/Products2/176.htm',176,'文章','2016-05-25 16:02:45',1,0,1),(294,1,1,'scaffolding1.jpg',NULL,'/article/image/2016_2/5_25/59fwioml3i2x.jpg','59fwioml3i2x.jpg',728,0,'(New)Scaffolding Casters','/Products2/177.htm',177,'文章','2016-05-25 16:04:05',1,0,1),(295,1,1,'scaffolding1_副本_副本.jpg',NULL,'/article/image/2016_2/5_25/k6whioml3xj4.jpg','k6whioml3xj4.jpg',61,0,'(New)Scaffolding Casters','/Products2/177.htm',177,'文章','2016-05-25 16:04:05',1,0,1),(296,1,1,'Green PU 2.jpg',NULL,'/article/image/2016_2/5_31/cualiouvu48g.jpg','cualiouvu48g.jpg',506,0,'(New)Green PU 2','/Products2/178.htm',178,'文章','2016-05-31 11:26:51',1,0,1),(297,1,1,'Green PU 2_副本.jpg',NULL,'/article/image/2016_2/5_31/iunxiouvui3f.jpg','iunxiouvui3f.jpg',46,0,'(New)Green PU 2','/Products2/178.htm',178,'文章','2016-05-31 11:26:51',1,0,1),(298,1,1,'Green PU 1_副本.jpg',NULL,'/article/image/2016_2/5_31/2fzyiouvvhv4.jpg','2fzyiouvvhv4.jpg',45,0,'(New)Green PU 1','/Products2/179.htm',179,'文章','2016-05-31 11:27:38',1,0,1),(299,1,1,'Green PU 1.jpg',NULL,'/article/image/2016_2/5_31/17nkiouvv8ro.jpg','17nkiouvv8ro.jpg',503,0,'(New)Green PU 1','/Products2/179.htm',179,'文章','2016-05-31 11:27:38',1,0,1),(300,1,1,'K-Type PU.jpg',NULL,'/article/image/2016_2/5_31/bzboiouvx6we.jpg','bzboiouvx6we.jpg',498,0,'(New)Korean Type PU','/Products2/180.htm',180,'文章','2016-05-31 11:29:12',1,0,1),(301,1,1,'K-Type PU_副本.jpg',NULL,'/article/image/2016_2/5_31/fehbiouvxj63.jpg','fehbiouvxj63.jpg',47,0,'(New)Korean Type PU','/Products2/180.htm',180,'文章','2016-05-31 11:29:12',1,0,1),(304,1,1,'pp casters_副本.jpg',NULL,'/article/image/2016_2/5_31/mm0viouw1cl5.jpg','mm0viouw1cl5.jpg',41,0,'(New)PP Pattern Casters','/Products2/182.htm',182,'文章','2016-05-31 11:32:09',1,0,1),(305,1,1,'pp casters.jpg',NULL,'/article/image/2016_2/5_31/h8kjiouw11eh.jpg','h8kjiouw11eh.jpg',445,0,'(New)PP Pattern Casters','/Products2/182.htm',182,'文章','2016-05-31 11:32:09',1,0,1),(306,1,1,'JER.jpg',NULL,'/article/image/2016_2/5_31/zmogiouw5wwp.jpg','zmogiouw5wwp.jpg',475,0,'(New)Elastic Rubber Wheel','/Products2/183.htm',183,'文章','2016-05-31 11:35:57',1,0,1),(307,1,1,'JER_副本.jpg',NULL,'/article/image/2016_2/5_31/imapiouw6858.jpg','imapiouw6858.jpg',43,0,'(New)Elastic Rubber Wheel','/Products2/183.htm',183,'文章','2016-05-31 11:35:57',1,0,1),(314,1,1,'A-type Casters.jpg',NULL,'/article/image/2016_2/6_13/oe9xipdmyxxz.jpg','oe9xipdmyxxz.jpg',431,0,'(New)A-type Casters','/Products2/187.htm',187,'文章','2016-06-13 14:26:15',1,0,1),(315,1,1,'A-type Casters_副本.jpg',NULL,'/article/image/2016_2/6_13/7g5uipdmzbtp.jpg','7g5uipdmzbtp.jpg',40,0,'(New)A-type Casters','/Products2/187.htm',187,'文章','2016-06-13 14:26:15',1,0,1),(316,1,1,'EH4.jpg',NULL,'/article/image/2016_2/6_13/6x76ipdmzuhc.jpg','6x76ipdmzuhc.jpg',459,0,'(New)Extra Heavy Duty Casters 4','/Products2/188.htm',188,'文章','2016-06-13 14:26:48',1,0,1),(317,1,1,'EH4_副本.jpg',NULL,'/article/image/2016_2/6_13/1a7aipdn01a0.jpg','1a7aipdn01a0.jpg',44,0,'(New)Extra Heavy Duty Casters 4','/Products2/188.htm',188,'文章','2016-06-13 14:26:48',1,0,1),(318,1,1,'EH3.jpg',NULL,'/article/image/2016_2/6_13/py2eipdn0ixw.jpg','py2eipdn0ixw.jpg',474,0,'(New)Extra Heavy Duty Casters 3','/Products2/189.htm',189,'文章','2016-06-13 14:27:22',1,0,1),(319,1,1,'EH3_副本.jpg',NULL,'/article/image/2016_2/6_13/5r45ipdn0rze.jpg','5r45ipdn0rze.jpg',44,0,'(New)Extra Heavy Duty Casters 3','/Products2/189.htm',189,'文章','2016-06-13 14:27:22',1,0,1),(320,1,1,'EH2_副本.jpg',NULL,'/article/image/2016_2/6_13/9ipkipdn1dlw.jpg','9ipkipdn1dlw.jpg',45,0,'(New)Extra Heavy Duty Casters 2','/Products2/190.htm',190,'文章','2016-06-13 14:27:50',1,0,1),(321,1,1,'EH2.jpg',NULL,'/article/image/2016_2/6_13/2f77ipdn1746.jpg','2f77ipdn1746.jpg',494,0,'(New)Extra Heavy Duty Casters 2','/Products2/190.htm',190,'文章','2016-06-13 14:27:50',1,0,1),(322,1,1,'EH1_副本.jpg',NULL,'/article/image/2016_2/6_13/icu9ipdn2181.jpg','icu9ipdn2181.jpg',48,0,'(New)Extra Heavy Duty Casters 1','/Products2/191.htm',191,'文章','2016-06-13 14:28:21',1,0,1),(323,1,1,'EH1.jpg',NULL,'/article/image/2016_2/6_13/upzuipdn1tvv.jpg','upzuipdn1tvv.jpg',518,0,'(New)Extra Heavy Duty Casters 1','/Products2/191.htm',191,'文章','2016-06-13 14:28:21',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),(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);


