64 lines
2.1 KiB
SQL
64 lines
2.1 KiB
SQL
/*
|
|
Navicat MySQL Data Transfer
|
|
|
|
Source Server : qiangge
|
|
Source Server Version : 50537
|
|
Source Host : localhost:3306
|
|
Source Database : zlb_github
|
|
|
|
Target Server Type : MYSQL
|
|
Target Server Version : 50537
|
|
File Encoding : 65001
|
|
|
|
Date: 2016-01-31 14:20:28
|
|
*/
|
|
|
|
SET FOREIGN_KEY_CHECKS=0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for issues
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `issues`;
|
|
CREATE TABLE `issues` (
|
|
`body` text,
|
|
`events_url` varchar(200) DEFAULT NULL,
|
|
`locked` int(5) DEFAULT NULL,
|
|
`title` text,
|
|
`url` varchar(200) DEFAULT NULL,
|
|
`labels_url` varchar(200) DEFAULT NULL,
|
|
`created_at` varchar(200) DEFAULT NULL,
|
|
`comments_url` varchar(200) DEFAULT NULL,
|
|
`html_url` varchar(200) DEFAULT NULL,
|
|
`comments` int(11) DEFAULT NULL,
|
|
`number` int(11) DEFAULT NULL,
|
|
`updated_at` varchar(100) DEFAULT NULL,
|
|
`state` varchar(100) DEFAULT NULL,
|
|
`closed_at` varchar(100) DEFAULT NULL,
|
|
`project_id` int(11) DEFAULT NULL,
|
|
`id` int(100) NOT NULL AUTO_INCREMENT,
|
|
`user.following_url` varchar(200) DEFAULT NULL,
|
|
`user.gists_url` varchar(200) DEFAULT NULL,
|
|
`user.organizations_url` varchar(200) DEFAULT NULL,
|
|
`user.url` varchar(200) DEFAULT NULL,
|
|
`user.events_url` varchar(200) DEFAULT NULL,
|
|
`user.html_url` varchar(200) DEFAULT NULL,
|
|
`user.subscriptions_url` varchar(200) DEFAULT NULL,
|
|
`user.avatar_url` varchar(200) DEFAULT NULL,
|
|
`user.repos_url` varchar(200) DEFAULT NULL,
|
|
`user.received_events_url` varchar(200) DEFAULT NULL,
|
|
`user.gravatar_id` varchar(200) DEFAULT NULL,
|
|
`user.starred_url` varchar(200) DEFAULT NULL,
|
|
`user.site_admin` int(11) DEFAULT NULL,
|
|
`user.login` varchar(100) DEFAULT NULL,
|
|
`user.type` varchar(50) DEFAULT NULL,
|
|
`user.id` varchar(100) DEFAULT NULL,
|
|
`user.followers_url` varchar(200) DEFAULT NULL,
|
|
`issue_type` varchar(255) DEFAULT NULL,
|
|
`kmeans` int(11) DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `proj_id` (`project_id`),
|
|
KEY `issue_type` (`issue_type`(250)),
|
|
KEY `number` (`number`),
|
|
KEY `kmeans_index` (`kmeans`)
|
|
) ENGINE=MyISAM AUTO_INCREMENT=123846131 DEFAULT CHARSET=utf8mb4;
|