59 lines
2.2 KiB
SQL
59 lines
2.2 KiB
SQL
/*
|
|
Navicat MySQL Data Transfer
|
|
|
|
Source Server : ossean
|
|
Source Server Version : 50535
|
|
Source Host : localhost:3306
|
|
Source Database : ossean_production
|
|
|
|
Target Server Type : MYSQL
|
|
Target Server Version : 50535
|
|
File Encoding : 65001
|
|
|
|
Date: 2016-02-19 14:05:57
|
|
*/
|
|
|
|
SET FOREIGN_KEY_CHECKS=0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for open_source_projects
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `open_source_projects`;
|
|
CREATE TABLE `open_source_projects` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) NOT NULL,
|
|
`description` text,
|
|
`followers_num` int(11) DEFAULT '0',
|
|
`url` text,
|
|
`language` varchar(255) DEFAULT NULL,
|
|
`download_num` int(11) DEFAULT '0',
|
|
`view_num_crawled` int(11) DEFAULT '0',
|
|
`category` varchar(255) DEFAULT NULL,
|
|
`crawled_time` datetime DEFAULT NULL,
|
|
`source` varchar(255) DEFAULT NULL,
|
|
`view_num_local` int(11) DEFAULT '0',
|
|
`created_at` datetime DEFAULT NULL,
|
|
`updated_at` datetime DEFAULT NULL,
|
|
`composite_score` float DEFAULT '0',
|
|
`relative_memos_num` int(11) DEFAULT NULL,
|
|
`created_time` datetime DEFAULT NULL,
|
|
`updated_time` datetime DEFAULT NULL,
|
|
`view_num` int(11) DEFAULT '0',
|
|
`activeness` int(11) DEFAULT '0',
|
|
`tags` varchar(2000) DEFAULT '',
|
|
`tags_for_search` varchar(2000) DEFAULT NULL,
|
|
`synonyms` text,
|
|
`filtration` int(11) DEFAULT NULL,
|
|
`update_mark` int(11) DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `index_open_source_projects_on_download_num` (`download_num`) USING BTREE,
|
|
KEY `index_open_source_projects_on_created_at` (`created_at`) USING BTREE,
|
|
KEY `index_open_source_projects_on_ossean_score` (`composite_score`) USING BTREE,
|
|
KEY `index_open_source_projects_on_name` (`name`) USING BTREE,
|
|
KEY `index_open_source_projects_on_relative_memos_num` (`relative_memos_num`) USING BTREE,
|
|
KEY `index_open_source_projects_on_view_num` (`view_num`) USING BTREE,
|
|
KEY `index_open_source_projects_on_activeness` (`activeness`) USING BTREE,
|
|
KEY `index_open_source_projects_on_composite_score` (`composite_score`) USING BTREE,
|
|
KEY `index_open_source_projects_on_source` (`source`) USING BTREE
|
|
) ENGINE=InnoDB AUTO_INCREMENT=358430 DEFAULT CHARSET=utf8;
|