49 lines
1.5 KiB
SQL
49 lines
1.5 KiB
SQL
/*
|
|
Navicat MySQL Data Transfer
|
|
|
|
Source Server : crawler
|
|
Source Server Version : 50619
|
|
Source Host : 192.168.80.104:3306
|
|
Source Database : extracted_data
|
|
|
|
Target Server Type : MYSQL
|
|
Target Server Version : 50619
|
|
File Encoding : 65001
|
|
|
|
Date: 2016-01-26 15:16:20
|
|
*/
|
|
|
|
SET FOREIGN_KEY_CHECKS=0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for job_requirements
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `job_requirements`;
|
|
CREATE TABLE `job_requirements` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`title` varchar(255) NOT NULL,
|
|
`content` longtext,
|
|
`created_time` datetime DEFAULT NULL,
|
|
`type` varchar(100) DEFAULT NULL,
|
|
`tags` varchar(255) DEFAULT NULL,
|
|
`url` varchar(255) NOT NULL,
|
|
`url_md5` varchar(34) DEFAULT NULL,
|
|
`author` varchar(100) DEFAULT NULL,
|
|
`author_url` varchar(150) DEFAULT NULL,
|
|
`category` varchar(255) DEFAULT NULL,
|
|
`view_num` int(11) unsigned DEFAULT NULL,
|
|
`review_num` int(11) unsigned DEFAULT NULL,
|
|
`extracted_time` datetime NOT NULL,
|
|
`source` varchar(255) DEFAULT NULL,
|
|
`similar_position` varchar(255) DEFAULT NULL,
|
|
`work_place` varchar(255) DEFAULT NULL,
|
|
`experience` varchar(255) DEFAULT NULL,
|
|
`salary` varchar(255) DEFAULT NULL,
|
|
`scale` varchar(255) DEFAULT NULL,
|
|
`domain` varchar(255) DEFAULT NULL,
|
|
`finance` varchar(255) DEFAULT NULL,
|
|
`style` varchar(255) DEFAULT NULL,
|
|
`education` varchar(255) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|