/*
MySQL Data Transfer
Source Host: localhost
Source Database: myjeecms
Target Host: localhost
Target Database: myjeecms
Date: 2012-3-2 10:02:01
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for jc_acquisition
-- ----------------------------
CREATE TABLE `jc_acquisition` (
  `acquisition_id` int(11) NOT NULL AUTO_INCREMENT,
  `site_id` int(11) NOT NULL,
  `channel_id` int(11) NOT NULL,
  `type_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `acq_name` varchar(50) NOT NULL COMMENT '采集名称',
  `start_time` datetime DEFAULT NULL COMMENT '开始时间',
  `end_time` datetime DEFAULT NULL COMMENT '停止时间',
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '当前状态(0:静止;1:采集;2:暂停)',
  `curr_num` int(11) NOT NULL DEFAULT '0' COMMENT '当前号码',
  `curr_item` int(11) NOT NULL DEFAULT '0' COMMENT '当前条数',
  `total_item` int(11) NOT NULL DEFAULT '0' COMMENT '每页总条数',
  `pause_time` int(11) NOT NULL DEFAULT '0' COMMENT '暂停时间(毫秒)',
  `page_encoding` varchar(20) NOT NULL DEFAULT 'GBK' COMMENT '页面编码',
  `plan_list` longtext COMMENT '采集列表',
  `dynamic_addr` varchar(255) DEFAULT NULL COMMENT '动态地址',
  `dynamic_start` int(11) DEFAULT NULL COMMENT '页码开始',
  `dynamic_end` int(11) DEFAULT NULL COMMENT '页码结束',
  `linkset_start` varchar(255) DEFAULT NULL COMMENT '内容链接区开始',
  `linkset_end` varchar(255) DEFAULT NULL COMMENT '内容链接区结束',
  `link_start` varchar(255) DEFAULT NULL COMMENT '内容链接开始',
  `link_end` varchar(255) DEFAULT NULL COMMENT '内容链接结束',
  `title_start` varchar(255) DEFAULT NULL COMMENT '标题开始',
  `title_end` varchar(255) DEFAULT NULL COMMENT '标题结束',
  `keywords_start` varchar(255) DEFAULT NULL COMMENT '关键字开始',
  `keywords_end` varchar(255) DEFAULT NULL COMMENT '关键字结束',
  `description_start` varchar(255) DEFAULT NULL COMMENT '描述开始',
  `description_end` varchar(255) DEFAULT NULL COMMENT '描述结束',
  `content_start` varchar(255) DEFAULT NULL COMMENT '内容开始',
  `content_end` varchar(255) DEFAULT NULL COMMENT '内容结束',
  `pagination_start` varchar(255) DEFAULT NULL COMMENT '内容分页开始',
  `pagination_end` varchar(255) DEFAULT NULL COMMENT '内容分页结束',
  `pagination_repair_url` varchar(255) DEFAULT NULL COMMENT '内容分页补全URL',
  `queue` int(11) NOT NULL DEFAULT '0' COMMENT '队列',
  `repeat_check_type` varchar(20) NOT NULL DEFAULT 'NONE' COMMENT '重复类型',
  `use_proxy` varchar(20) DEFAULT 'false' COMMENT '是否使用代理',
  `proxy_port` varchar(100) DEFAULT NULL COMMENT '代理地址端口',
  `proxy_address` varchar(100) DEFAULT NULL COMMENT '代理地址',
  PRIMARY KEY (`acquisition_id`),
  KEY `fk_jc_acquisition_channel` (`channel_id`),
  KEY `fk_jc_acquisition_contenttype` (`type_id`),
  KEY `fk_jc_acquisition_site` (`site_id`),
  KEY `fk_jc_acquisition_user` (`user_id`),
  CONSTRAINT `fk_jc_acquisition_channel` FOREIGN KEY (`channel_id`) REFERENCES `jc_channel` (`channel_id`),
  CONSTRAINT `fk_jc_acquisition_contenttype` FOREIGN KEY (`type_id`) REFERENCES `jc_content_type` (`type_id`),
  CONSTRAINT `fk_jc_acquisition_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`),
  CONSTRAINT `fk_jc_acquisition_user` FOREIGN KEY (`user_id`) REFERENCES `jc_user` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='CMS采集表';

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `jc_acquisition` VALUES ('1', '1', '37', '1', '1', '新浪国内新闻', '2011-12-21 08:34:33', '2011-12-21 08:34:36', '0', '0', '0', '0', '500', 'GBK', 'http://roll.news.sina.com.cn/news/gnxw/gdxw1/index.shtml', 'http://roll.news.sina.com.cn/news/gnxw/gdxw1/index_[page].shtml', '2', '5', '<ul class=\"list_009\">', '</ul>', '<li><a href=\"', '\" target=\"_blank\"', '<title>', '_新闻中心_新浪网</title>', '[{\"fields\":\"\",\"filterStart\":\"\",\"filterEnd\":\"\"}]', '4,3,2,1', '', '', ' f_id=\'3\' -->', '<!-- publish_helper_end -->', null, null, null, '0', 'NONE', 'false', null, null);
INSERT INTO `jc_acquisition` VALUES ('2', '1', '11', '1', '1', '新浪-国内新闻', '2011-12-21 08:34:41', '2011-12-21 08:42:01', '0', '0', '0', '0', '500', 'gb2312', '', 'http://roll.news.sina.com.cn/news/gnxw/gdxw1/index_[page].shtml', '1', '1', 'class=list_009', '', '', '', 'false', 'false', '[{\"fields\":\"\",\"filterStart\":\"\",\"filterEnd\":\"\"}]', null, '', '', 'id=artibody', '', null, null, null, '0', 'NONE', 'false', null, null);
INSERT INTO `jc_acquisition` VALUES ('4', '1', '11', '1', '1', '本地采集', '2012-02-09 10:19:30', '2012-02-09 10:19:38', '0', '0', '0', '0', '500', 'gb2312', 'http://localhost/v7/list.php?fid=33', '', '2', '10', 'style=margin-left:5px;margin-top:10px;', '', 'http://localhost/v7/', '', 'false', 'true', '[{\"fields\":\"maintitle\",\"filterStart\":\"class=main_title\",\"filterEnd\":\"\"}]', null, '', '', 'id=post1', '', null, null, null, '0', 'NONE', 'false', null, null);
INSERT INTO `jc_acquisition` VALUES ('6', '1', '11', '1', '1', '美食天下-行业资讯', '2012-02-09 10:13:59', '2012-02-09 10:14:47', '0', '0', '0', '0', '500', 'gb2312', '', 'http://www.meishichina.com/News/HangYe/List_[page].html', '50', '50', 'class=tList', '', 'http://www.meishichina.com/', '', 'false', 'true', '[{\"fields\":\"\",\"filterStart\":\"\",\"filterEnd\":\"\"}]', '4,3', '', '', 'class=content.*', '', null, null, null, '0', 'NONE', 'false', null, null);
INSERT INTO `jc_acquisition` VALUES ('7', '1', '12', '1', '1', '美食天下-厨房资讯', '2012-02-09 10:12:40', '2012-02-09 10:15:39', '0', '0', '0', '0', '500', 'gb2312', 'http://www.meishichina.com/News/ChuFang/', '', '35', '35', 'class=tList', '', 'http://www.meishichina.com/', '', 'false', 'false', '[{\"fields\":\"\",\"filterStart\":\"\",\"filterEnd\":\"\"}]', '2,1', '', '', 'class=content.*', '', null, null, null, '0', 'NONE', 'false', null, null);
INSERT INTO `jc_acquisition` VALUES ('10', '1', '79', '1', '1', '美食天下-饮食常识', '2012-01-31 23:07:11', '2012-01-31 23:08:01', '0', '0', '0', '0', '500', 'gb2312', 'http://www.meishichina.com/Health/CommonSense/index.html', '', '2', '10', 'class=pList5', 'class=pic_art_title', 'http://www.meishichina.com/', '', 'false', 'true', '[{\"fields\":\"\",\"filterStart\":\"\",\"filterEnd\":\"\"}]', null, '', '', 'class=content.*', 'iframe', null, null, null, '0', 'NONE', 'false', null, null);
INSERT INTO `jc_acquisition` VALUES ('11', '1', '73', '1', '1', '美食天下-女性健康', '2012-01-31 23:08:15', '2012-01-31 23:10:48', '0', '0', '0', '0', '500', 'gb2312', 'http://www.meishichina.com/Physique/Woman/', '', '2', '10', 'class=pList5', 'class=pic_art_title', 'http://www.meishichina.com/', '', 'false', 'true', '[{\"fields\":\"\",\"filterStart\":\"\",\"filterEnd\":\"\"}]', null, '', '', 'class=content.*', 'iframe', null, null, null, '0', 'NONE', 'false', null, null);
INSERT INTO `jc_acquisition` VALUES ('13', '1', '75', '1', '1', '39健康-老人健康', '2012-02-08 21:17:36', '2012-02-08 21:18:03', '0', '0', '0', '0', '500', 'gb2312', '', 'http://oldman.39.net/nutrition/index_[page].html', '2', '2', 'class=listbox', '', '', '', 'false', 'false', '[{\"fields\":\"\",\"filterStart\":\"\",\"filterEnd\":\"\"}]', null, '', '', 'id=contentText', 'IFRAME,align=right', null, null, null, '0', 'NONE', 'false', null, null);
INSERT INTO `jc_acquisition` VALUES ('14', '1', '73', '1', '1', '39健康-女人健康', '2011-12-23 17:47:50', '2012-02-08 22:26:31', '0', '0', '0', '0', '500', 'gb2312', '', 'http://woman.39.net/nxyy/bjsp/index_[page].html', '2', '2', 'class=newslist', '', '', '', 'false', 'false', '[{\"fields\":\"\",\"filterStart\":\"\",\"filterEnd\":\"\"}]', null, 'class=summary', '', 'id=contentText', 'IFRAME,align=right', null, null, null, '0', 'NONE', 'false', null, null);
INSERT INTO `jc_acquisition` VALUES ('15', '1', '13', '1', '1', '测试', null, null, '0', '0', '0', '0', '500', 'GBK', '', '', '2', '10', '', '', '', '', 'false', 'false', '[{\"fields\":\"\",\"filterStart\":\"\",\"filterEnd\":\"\"}]', '4,3,2', '', '', '', '', null, null, null, '0', 'NONE', 'false', null, null);
INSERT INTO `jc_acquisition` VALUES ('16', '1', '67', '1', '1', '测试', null, null, '0', '0', '0', '0', '500', 'GBK', '', '', '2', '10', '', '', '', '', 'false', 'false', '[{\"fields\":\"\",\"filterStart\":\"\",\"filterEnd\":\"\"}]', '', '', '', '', '', null, null, null, '0', 'NONE', 'false', null, null);
INSERT INTO `jc_acquisition` VALUES ('17', '1', '73', '1', '1', '美食健康-女性健康', '2012-02-11 09:07:20', '2012-02-11 09:08:20', '0', '0', '0', '0', '500', 'utf-8', 'http://health.lady8844.com/317489/index.html', '', '2', '10', 'class=sitlistbox', '', '', '', 'false', 'false', '[{\"fields\":\"\",\"filterStart\":\"\",\"filterEnd\":\"\"}]', '4', 'class=guide_txt', '', 'id=TEXT_CONTENT', '', 'id=content_pagelist', '', '', '0', 'true', 'true', '', '');
INSERT INTO `jc_acquisition` VALUES ('18', '1', '82', '1', '1', '美食健康-女性健康', '2012-03-02 09:43:06', '2012-03-02 09:49:05', '0', '0', '0', '0', '500', 'utf-8', 'http://health.lady8844.com/292301/index.html', '', '2', '10', 'class=sitlistbox', '', '', '', 'false', 'false', '[{\"fields\":\"\",\"filterStart\":\"\",\"filterEnd\":\"\"}]', '4', '', '', 'id=TEXT_CONTENT', '', 'id=content_pagelist', '', '', '0', 'true', 'true', '808', '128.160.97.58');
