50 lines
1.6 KiB
SQL
50 lines
1.6 KiB
SQL
/*
|
|
Navicat MySQL Data Transfer
|
|
|
|
Source Server : ossean
|
|
Source Server Version : 50535
|
|
Source Host : 127.0.0.1:3306
|
|
Source Database : ossean_new
|
|
|
|
Target Server Type : MYSQL
|
|
Target Server Version : 50535
|
|
File Encoding : 65001
|
|
|
|
Date: 2016-11-17 18:44:25
|
|
*/
|
|
|
|
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,
|
|
`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 `name_index` (`name`) USING BTREE,
|
|
KEY `relative_memos_num_index` (`relative_memos_num`) USING BTREE,
|
|
KEY `composite_score_index` (`composite_score`) USING BTREE,
|
|
KEY `source_index` (`source`) USING BTREE
|
|
) ENGINE=InnoDB AUTO_INCREMENT=210 DEFAULT CHARSET=utf8;
|