555 lines
20 KiB
SQL
555 lines
20 KiB
SQL
/*
|
|
Navicat MySQL Data Transfer
|
|
|
|
Source Server : lzx
|
|
Source Server Version : 50615
|
|
Source Host : localhost:3306
|
|
Source Database : extract_result
|
|
|
|
Target Server Type : MYSQL
|
|
Target Server Version : 50615
|
|
File Encoding : 65001
|
|
|
|
Date: 2016-01-23 12:52:05
|
|
*/
|
|
|
|
SET FOREIGN_KEY_CHECKS=0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for 51cto_blog
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `51cto_blog`;
|
|
CREATE TABLE `51cto_blog` (
|
|
`id` int(11) NOT NULL DEFAULT '0',
|
|
`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,
|
|
`favor_num` int(11) DEFAULT NULL,
|
|
`source` varchar(255) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for apache
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `apache`;
|
|
CREATE TABLE `apache` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) NOT NULL,
|
|
`source` varchar(255) DEFAULT NULL,
|
|
`tags` varchar(255) DEFAULT NULL,
|
|
`description` mediumtext,
|
|
`homepage` varchar(255) DEFAULT NULL,
|
|
`url` varchar(255) NOT NULL,
|
|
`url_md5` varchar(255) DEFAULT NULL,
|
|
`language` varchar(1000) DEFAULT NULL,
|
|
`extracted_time` varchar(255) DEFAULT NULL,
|
|
`license` varchar(1000) DEFAULT NULL,
|
|
`mailing_link` varchar(255) DEFAULT NULL,
|
|
`download_link` varchar(255) DEFAULT NULL,
|
|
`issue_link` varchar(255) DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `extractTimeIdx` (`extracted_time`) USING BTREE,
|
|
KEY `stars_name` (`name`) USING BTREE,
|
|
KEY `download_name` (`name`) USING BTREE
|
|
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for cnblog_news
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `cnblog_news`;
|
|
CREATE TABLE `cnblog_news` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`title` varchar(255) DEFAULT NULL,
|
|
`content` longtext,
|
|
`created_time` datetime DEFAULT NULL,
|
|
`type` varchar(100) DEFAULT NULL,
|
|
`tags` varchar(255) DEFAULT NULL,
|
|
`url` varchar(255) DEFAULT 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 DEFAULT NULL,
|
|
`source` varchar(255) DEFAULT NULL,
|
|
`comment_num` int(11) DEFAULT NULL,
|
|
`related_posts` text,
|
|
`cnblog_news_source` varchar(255) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for cnblog_question
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `cnblog_question`;
|
|
CREATE TABLE `cnblog_question` (
|
|
`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,
|
|
`favor_num` int(11) DEFAULT NULL,
|
|
`source` varchar(255) DEFAULT NULL,
|
|
`dislike_num` int(11) DEFAULT NULL,
|
|
`reward_num` int(11) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for codeproject
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `codeproject`;
|
|
CREATE TABLE `codeproject` (
|
|
`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,
|
|
`star_num` int(11) DEFAULT NULL,
|
|
`source` varchar(255) DEFAULT NULL,
|
|
`rate_num` int(11) DEFAULT NULL,
|
|
`rate_value` double DEFAULT NULL,
|
|
`related_posts` text,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for csdn_bbs
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `csdn_bbs`;
|
|
CREATE TABLE `csdn_bbs` (
|
|
`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,
|
|
`favor_num` int(11) DEFAULT NULL,
|
|
`source` varchar(255) DEFAULT NULL,
|
|
`dislike_num` int(11) DEFAULT NULL,
|
|
`share_num` int(11) DEFAULT NULL,
|
|
`related_posts` text,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for csdn_blogs
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `csdn_blogs`;
|
|
CREATE TABLE `csdn_blogs` (
|
|
`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,
|
|
`favor_num` int(11) DEFAULT NULL,
|
|
`source` varchar(255) DEFAULT NULL,
|
|
`dislike_num` int(11) DEFAULT NULL,
|
|
`related_posts` text,
|
|
`related_topics` text,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for csdn_question
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `csdn_question`;
|
|
CREATE TABLE `csdn_question` (
|
|
`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,
|
|
`star_num` int(11) DEFAULT NULL,
|
|
`source` varchar(255) DEFAULT NULL,
|
|
`same_num` int(11) DEFAULT NULL,
|
|
`related_posts` text,
|
|
`related_documents` text,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for dewen_question
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `dewen_question`;
|
|
CREATE TABLE `dewen_question` (
|
|
`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,
|
|
`favor_num` int(11) DEFAULT NULL,
|
|
`source` varchar(255) DEFAULT NULL,
|
|
`dislike_num` int(11) DEFAULT NULL,
|
|
`comment_num` int(11) DEFAULT NULL,
|
|
`active_time` datetime DEFAULT NULL,
|
|
`related_posts` text,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for freecode_project
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `freecode_project`;
|
|
CREATE TABLE `freecode_project` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) DEFAULT NULL,
|
|
`source` varchar(255) DEFAULT NULL,
|
|
`tags` varchar(255) DEFAULT NULL,
|
|
`description` mediumtext,
|
|
`homepage` varchar(255) DEFAULT NULL,
|
|
`url` varchar(255) DEFAULT NULL,
|
|
`urlMD5` varchar(255) DEFAULT NULL,
|
|
`language` varchar(1000) DEFAULT NULL,
|
|
`extracted_time` varchar(255) DEFAULT NULL,
|
|
`license` varchar(1000) DEFAULT NULL,
|
|
`platform` varchar(255) DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `extractTimeIdx` (`extracted_time`),
|
|
KEY `stars_name` (`name`) USING BTREE,
|
|
KEY `download_name` (`name`) USING BTREE
|
|
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for iteye_blog
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `iteye_blog`;
|
|
CREATE TABLE `iteye_blog` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`title` varchar(255) DEFAULT NULL,
|
|
`content` longtext,
|
|
`created_time` datetime DEFAULT NULL,
|
|
`type` varchar(255) DEFAULT NULL,
|
|
`tags` varchar(255) DEFAULT NULL,
|
|
`url` varchar(255) DEFAULT NULL,
|
|
`url_md5` varchar(255) DEFAULT NULL,
|
|
`author` varchar(255) DEFAULT NULL,
|
|
`author_url` varchar(255) DEFAULT NULL,
|
|
`category` varchar(255) DEFAULT NULL,
|
|
`view_num` mediumint(11) DEFAULT NULL,
|
|
`review_num` mediumint(11) DEFAULT NULL,
|
|
`extracted_time` datetime DEFAULT NULL,
|
|
`favor_num` mediumint(11) DEFAULT NULL,
|
|
`dislike_num` mediumint(11) DEFAULT NULL,
|
|
`blog_category` varchar(255) DEFAULT NULL,
|
|
`source` varchar(255) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- 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` text,
|
|
`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 AUTO_INCREMENT=70 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for neitui
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `neitui`;
|
|
CREATE TABLE `neitui` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`author` varchar(255) DEFAULT NULL,
|
|
`author_url` varchar(255) DEFAULT NULL,
|
|
`url` varchar(255) NOT NULL,
|
|
`deal_title` varchar(255) NOT NULL,
|
|
`tags` varchar(255) DEFAULT NULL,
|
|
`content` text,
|
|
`salary` varchar(255) DEFAULT NULL,
|
|
`experience` varchar(255) DEFAULT NULL,
|
|
`comp_name` varchar(255) DEFAULT NULL,
|
|
`comp_url` varchar(255) DEFAULT NULL,
|
|
`addr` varchar(300) DEFAULT NULL,
|
|
`comp_scale` varchar(255) DEFAULT NULL,
|
|
`comp_field` varchar(255) DEFAULT NULL,
|
|
`financing` varchar(255) DEFAULT NULL,
|
|
`comp_vision` tinytext,
|
|
`created_time` datetime DEFAULT NULL,
|
|
`extractTime` datetime NOT NULL,
|
|
`history` int(2) unsigned DEFAULT NULL,
|
|
`relative_osps` text,
|
|
`reply_num` int(11) DEFAULT NULL,
|
|
`view_num` int(11) DEFAULT NULL,
|
|
`vote_num` int(11) DEFAULT NULL,
|
|
`collection_num` int(11) DEFAULT NULL,
|
|
`abstract` varchar(255) DEFAULT NULL,
|
|
`type` varchar(255) DEFAULT NULL,
|
|
`crawled_time` datetime DEFAULT NULL,
|
|
`category` varchar(255) DEFAULT NULL,
|
|
`source` varchar(255) DEFAULT NULL,
|
|
`last_time` datetime DEFAULT NULL,
|
|
`url_md5` varchar(255) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for openhub_project
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `openhub_project`;
|
|
CREATE TABLE `openhub_project` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) NOT NULL,
|
|
`source` varchar(255) DEFAULT NULL,
|
|
`tags` varchar(255) DEFAULT NULL,
|
|
`description` mediumtext,
|
|
`homepage` varchar(255) DEFAULT NULL,
|
|
`url` varchar(255) NOT NULL,
|
|
`urlMD5` varchar(255) DEFAULT NULL,
|
|
`language` varchar(1000) DEFAULT NULL,
|
|
`extracted_time` varchar(255) DEFAULT NULL,
|
|
`license` varchar(1000) DEFAULT NULL,
|
|
`active_degree` varchar(255) DEFAULT NULL,
|
|
`user_num` int(11) DEFAULT NULL,
|
|
`rate_num` varchar(255) DEFAULT NULL,
|
|
`rate_value` double DEFAULT NULL,
|
|
`organization` varchar(255) DEFAULT NULL,
|
|
`code_repository` varchar(255) DEFAULT NULL,
|
|
`created_time` datetime DEFAULT NULL,
|
|
`reviem_num` int(11) DEFAULT NULL,
|
|
`similar_project` text,
|
|
`manager` varchar(255) DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `stars_downloadNum_index` (`rate_num`) USING BTREE,
|
|
KEY `extractTimeIdx` (`extracted_time`),
|
|
KEY `stars_name` (`name`) USING BTREE,
|
|
KEY `download_name` (`rate_num`,`name`) USING BTREE
|
|
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for oschina_project
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `oschina_project`;
|
|
CREATE TABLE `oschina_project` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`oschina_name` varchar(255) NOT NULL,
|
|
`name` varchar(255) NOT NULL,
|
|
`source` varchar(255) DEFAULT NULL,
|
|
`tags` varchar(255) DEFAULT NULL,
|
|
`description` mediumtext,
|
|
`homepage` varchar(255) DEFAULT NULL,
|
|
`url` varchar(255) NOT NULL,
|
|
`urlMD5` varchar(255) DEFAULT NULL,
|
|
`language` varchar(1000) DEFAULT NULL,
|
|
`extracted_time` varchar(255) DEFAULT NULL,
|
|
`license` varchar(1000) DEFAULT NULL,
|
|
`star_num` int(11) DEFAULT NULL,
|
|
`user_num` varchar(255) DEFAULT NULL,
|
|
`platform` varchar(255) DEFAULT NULL,
|
|
`download_link` varchar(255) DEFAULT NULL,
|
|
`document_link` varchar(255) DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `stars_downloadNum_index` (`user_num`) USING BTREE,
|
|
KEY `extractTimeIdx` (`extracted_time`),
|
|
KEY `stars_name` (`name`) USING BTREE,
|
|
KEY `download_name` (`user_num`,`name`) USING BTREE
|
|
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for oschina_question
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `oschina_question`;
|
|
CREATE TABLE `oschina_question` (
|
|
`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,
|
|
`favor_num` int(11) DEFAULT NULL,
|
|
`source` varchar(255) DEFAULT NULL,
|
|
`dislike_num` int(11) DEFAULT NULL,
|
|
`star_num` int(11) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for records
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `records`;
|
|
CREATE TABLE `records` (
|
|
`site` varchar(255) DEFAULT NULL,
|
|
`last_record` bigint(255) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for slashdot
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `slashdot`;
|
|
CREATE TABLE `slashdot` (
|
|
`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,
|
|
`related_posts` text,
|
|
`slashdot_source` varchar(255) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for sourceforge_project
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `sourceforge_project`;
|
|
CREATE TABLE `sourceforge_project` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) NOT NULL,
|
|
`source` varchar(255) DEFAULT NULL,
|
|
`tags` varchar(255) DEFAULT NULL,
|
|
`description` mediumtext,
|
|
`homepage` varchar(255) DEFAULT NULL,
|
|
`url` varchar(255) NOT NULL,
|
|
`urlMD5` varchar(255) DEFAULT NULL,
|
|
`language` varchar(1000) DEFAULT NULL,
|
|
`extracted_time` varchar(255) DEFAULT NULL,
|
|
`license` varchar(1000) DEFAULT NULL,
|
|
`favor_num` int(11) DEFAULT NULL,
|
|
`download_num` varchar(255) DEFAULT NULL,
|
|
`updated_time` datetime DEFAULT NULL,
|
|
`platform` varchar(255) DEFAULT NULL,
|
|
`feature` text,
|
|
`audience` varchar(255) DEFAULT NULL,
|
|
`created_time` datetime DEFAULT NULL,
|
|
`review_num` int(11) DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `stars_downloadNum_index` (`download_num`) USING BTREE,
|
|
KEY `extractTimeIdx` (`extracted_time`),
|
|
KEY `stars_name` (`name`) USING BTREE,
|
|
KEY `download_name` (`download_num`,`name`) USING BTREE
|
|
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for stackoverflow
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `stackoverflow`;
|
|
CREATE TABLE `stackoverflow` (
|
|
`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,
|
|
`favor_num` int(11) DEFAULT NULL,
|
|
`source` varchar(255) DEFAULT NULL,
|
|
`dislike_num` int(11) DEFAULT NULL,
|
|
`star_num` int(11) DEFAULT NULL,
|
|
`active_time` datetime DEFAULT NULL,
|
|
`edited_time` datetime DEFAULT NULL,
|
|
`related_posts` text,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
|