51 lines
1.7 KiB
SQL
51 lines
1.7 KiB
SQL
/*
|
|
Navicat MySQL Data Transfer
|
|
|
|
Source Server : ossean
|
|
Source Server Version : 50535
|
|
Source Host : localhost:3306
|
|
Source Database : ossean_new
|
|
|
|
Target Server Type : MYSQL
|
|
Target Server Version : 50535
|
|
File Encoding : 65001
|
|
|
|
Date: 2016-02-19 14:07:15
|
|
*/
|
|
|
|
SET FOREIGN_KEY_CHECKS=0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for gather_projects
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `gather_projects`;
|
|
CREATE TABLE `gather_projects` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) NOT NULL,
|
|
`tags` varchar(2000) DEFAULT '',
|
|
`url` text,
|
|
`url_md5` varchar(255) DEFAULT NULL,
|
|
`description` text,
|
|
`language` varchar(255) DEFAULT NULL,
|
|
`source` varchar(255) DEFAULT NULL,
|
|
`tags_for_search` varchar(2000) DEFAULT NULL,
|
|
`synonyms` varchar(255) DEFAULT NULL,
|
|
`license` text,
|
|
`view_num_ossean` int(11) DEFAULT '0',
|
|
`homepage` varchar(255) DEFAULT NULL,
|
|
`updated_time` datetime DEFAULT NULL,
|
|
`extracted_time` datetime DEFAULT NULL,
|
|
`category` varchar(255) DEFAULT NULL,
|
|
`composite_score` double DEFAULT '0',
|
|
`relative_memos_num` int(11) DEFAULT NULL,
|
|
`created_time` datetime DEFAULT NULL,
|
|
`filtration` int(11) DEFAULT NULL,
|
|
`update_mark` int(11) DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
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_composite_score` (`composite_score`) USING BTREE,
|
|
KEY `index_open_source_projects_on_source` (`source`) USING BTREE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|