Viewing: raw.githubusercontent.com

[ Web Proxy ]
Viewing: https://raw.githubusercontent.com/matrixdekoder/SpringBootUnity/master/website/web.sql
/*
Navicat MySQL Data Transfer

Source Server         : xiaomo2017(106.15.188.160)
Source Server Version : 50717
Source Host           : 106.15.188.160:3306
Source Database       : xiaomo

Target Server Type    : MYSQL
Target Server Version : 50717
File Encoding         : 65001

Date: 2017-08-28 16:50:30
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for admin_user
-- ----------------------------
DROP TABLE IF EXISTS `admin_user`;
CREATE TABLE `admin_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `salt` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `user_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin_user
-- ----------------------------
INSERT INTO `admin_user` VALUES ('1', '2017-08-11 17:22:32', 'string', '2017-08-11 17:34:06', '11dbb64dac563eb66c5bedca104ef581', 'yg7djoh6yf', '0', 'string');

-- ----------------------------
-- Table structure for change_log
-- ----------------------------
DROP TABLE IF EXISTS `change_log`;
CREATE TABLE `change_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `online_time` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of change_log
-- ----------------------------
INSERT INTO `change_log` VALUES ('1', '2017-08-11 17:35:34', 'string', '2017-08-11 17:35:34', 'string');

-- ----------------------------
-- Table structure for link
-- ----------------------------
DROP TABLE IF EXISTS `link`;
CREATE TABLE `link` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of link
-- ----------------------------

-- ----------------------------
-- Table structure for shikigame
-- ----------------------------
DROP TABLE IF EXISTS `shikigame`;
CREATE TABLE `shikigame` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `des` varchar(255) DEFAULT NULL,
  `get_way` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `level` varchar(255) DEFAULT NULL,
  `seiyou` varchar(255) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `star` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of shikigame
-- ----------------------------
INSERT INTO `shikigame` VALUES ('1', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201706/999/image/388/388/hd/20170628104915566.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('2', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201706/999/image/388/388/hd/20170628103321193.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('3', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201706/999/image/388/388/hd/20170628103321133.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('4', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201706/999/image/388/388/hd/20170628103321247.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('5', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201706/999/image/388/388/hd/20170628103321038.jpeg', 'SSR', '', '', '');
INSERT INTO `shikigame` VALUES ('6', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201704/999/image/388/388/hd/20170425111533689.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('7', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201704/999/image/388/388/hd/20170425110822062.jpeg', 'SSR', '', '', '');
INSERT INTO `shikigame` VALUES ('8', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201704/999/image/388/388/hd/20170425102028952.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('9', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201702/999/image/388/388/hd/20170215123933616.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('10', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201702/999/image/388/388/hd/20170215123707014.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('11', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201702/999/image/388/388/hd/20170215113029024.jpeg', 'SSR', '', '', '');
INSERT INTO `shikigame` VALUES ('12', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201702/999/image/388/388/hd/20170215112700922.jpeg', 'SSR', '', '', '');
INSERT INTO `shikigame` VALUES ('13', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201702/999/image/388/388/hd/20170214170613314.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('14', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201702/999/image/388/388/hd/20170214170026831.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('15', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201702/999/image/388/388/hd/20170214165135364.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('16', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201702/999/image/388/388/hd/20170214172404430.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('17', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201611/999/image/388/388/hd/20161114141227302.jpeg', 'N', '', '', '');
INSERT INTO `shikigame` VALUES ('18', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201611/999/image/388/388/hd/20161111163947709.jpeg', 'SSR', '', '', '');
INSERT INTO `shikigame` VALUES ('19', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201611/999/image/388/388/hd/20161111163328046.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('20', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201611/999/image/388/388/hd/20161103100753671.jpeg', 'N', '', '', '');
INSERT INTO `shikigame` VALUES ('21', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201610/999/image/388/388/hd/20161014155409432.jpeg', 'N', '', '', '');
INSERT INTO `shikigame` VALUES ('22', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201610/999/image/388/388/hd/20161014154807857.jpeg', 'N', '-', '', '');
INSERT INTO `shikigame` VALUES ('23', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201610/999/image/388/388/hd/20161014154249087.jpeg', 'N', '', '', '');
INSERT INTO `shikigame` VALUES ('24', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201610/999/image/388/388/hd/20161014153630952.jpeg', 'N', '', '', '');
INSERT INTO `shikigame` VALUES ('25', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201610/999/image/388/388/hd/20161013132716253.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('26', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201610/999/image/388/388/hd/20161012162340089.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('27', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201610/999/image/388/388/hd/20161012155327721.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('28', null, '', null, '', '', 'http://uus-ng.img.d.cn/snapshot/201610/999/image/388/388/hd/20161012152409709.jpeg', 'SSR', '', '', '');
INSERT INTO `shikigame` VALUES ('29', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926104658402.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('30', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926104424533.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('31', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926102711340.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('32', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926102255825.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('33', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926102013107.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('34', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926101743950.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('35', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926101422781.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('36', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926101100598.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('37', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926100725543.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('38', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926095821891.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('39', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926095543173.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('40', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926095401921.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('41', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926095022134.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('42', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926094814879.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('43', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926094600059.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('44', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926094357103.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('45', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926094121029.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('46', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926093300209.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('47', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160926093041921.jpeg', 'SSR', '', '', '');
INSERT INTO `shikigame` VALUES ('48', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160923170213025.jpeg', 'SSR', '', '', '');
INSERT INTO `shikigame` VALUES ('49', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160923165754494.jpeg', 'SSR', '', '', '');
INSERT INTO `shikigame` VALUES ('50', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160923165614197.jpeg', 'SSR', '', '', '');
INSERT INTO `shikigame` VALUES ('51', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160923165311983.jpeg', 'SSR', '', '', '');
INSERT INTO `shikigame` VALUES ('52', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160923165039787.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('53', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201701/999/image/388/388/hd/20170119113153623.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('54', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160923163557641.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('55', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160923163207205.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('56', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920181314803.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('57', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920180651005.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('58', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920180215320.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('59', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920175835892.jpeg', 'SSR', '', '', '');
INSERT INTO `shikigame` VALUES ('60', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920175602498.jpeg', 'SSR', '', '', '');
INSERT INTO `shikigame` VALUES ('61', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920175352199.jpeg', 'SSR', '', '', '');
INSERT INTO `shikigame` VALUES ('62', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920175142834.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('63', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920174727153.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('64', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920174540667.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('65', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920174232252.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('66', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920174054507.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('67', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920155914788.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('68', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920155617178.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('69', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920155205681.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('70', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920151321465.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('71', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920151047481.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('72', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920150850532.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('73', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920150636794.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('74', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920150447931.jpeg', 'SR', '', '', '');
INSERT INTO `shikigame` VALUES ('75', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920150221571.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('76', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160920145918831.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('77', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160919192452025.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('78', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160919192104507.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('79', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160919191747925.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('80', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160919111719964.png', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('81', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160919111049876.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('82', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160919110029060.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('83', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160919103128584.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('84', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160919101843632.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('85', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160919102039254.jpeg', 'R', '', '', '');
INSERT INTO `shikigame` VALUES ('86', null, '', null, '', ',', 'http://uus-ng.img.d.cn/snapshot/201609/999/image/388/388/hd/20160919102003545.jpeg', 'R', '', '', '');

-- ----------------------------
-- Table structure for system_set
-- ----------------------------
DROP TABLE IF EXISTS `system_set`;
CREATE TABLE `system_set` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `beian_number` varchar(255) DEFAULT NULL,
  `beian_url` varchar(255) DEFAULT NULL,
  `from_year` int(11) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `site_name` varchar(255) DEFAULT NULL,
  `to_year` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of system_set
-- ----------------------------
INSERT INTO `system_set` VALUES ('1', '2017-08-28 16:46:20', 'xiaomo', '2017-08-28 16:46:25', '', 'https://xxx.xxx.xxx', '2015', 'https://image.xiaom.info/logo/avatar.png', '', '2017');

-- ----------------------------
-- Table structure for technology
-- ----------------------------
DROP TABLE IF EXISTS `technology`;
CREATE TABLE `technology` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `img_url` varchar(255) DEFAULT NULL,
  `summary` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of technology
-- ----------------------------

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `register_time` bigint(20) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `gender` int(11) DEFAULT NULL,
  `img_url` varchar(255) DEFAULT NULL,
  `nick_name` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `phone` bigint(20) DEFAULT NULL,
  `salt` varchar(255) DEFAULT NULL,
  `validate_code` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------

-- ----------------------------
-- Table structure for works
-- ----------------------------
DROP TABLE IF EXISTS `works`;
CREATE TABLE `works` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `complete_time` varchar(255) DEFAULT NULL,
  `img_url` varchar(255) DEFAULT NULL,
  `summary` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of works
-- ----------------------------
Web Proxy Viewer | New URL | Original Page