garden_server/garden.sql

/*
Navicat MySQL Data Transfer

Source Server         : Superbee
Source Server Version : 50625
Source Host           : localhost:3306
Source Database       : garden

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

Date: 2017-03-10 17:34:09
*/

SET FOREIGN_KEY_CHECKS=0;


-- ----------------------------
-- Table structure for gd_user
-- ----------------------------
DROP TABLE IF EXISTS `gd_user`;
CREATE TABLE `gd_user` (
  `id` bigint(20) NOT NULL,
  `uid` varchar(255) NOT NULL DEFAULT '',
  `diamond` int(11) DEFAULT '0',
  `coin` int(11) DEFAULT '0',
  `nickname` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `registertime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`,`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for gd_user_skill
-- ----------------------------
DROP TABLE IF EXISTS `gd_user_skill`;
CREATE TABLE `gd_user_skill` (
  `id` bigint(20) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `skill_id` int(11) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;