/*
|
Navicat MySQL Data Transfer
|
|
Source Server : localhost
|
Source Server Type : MySQL
|
Source Server Version : 50721
|
Source Host : localhost:3306
|
Source Schema : guns_rest
|
|
Target Server Type : MySQL
|
Target Server Version : 50721
|
File Encoding : 65001
|
|
Date: 26/01/2018 21:16:47
|
*/
|
|
DROP DATABASE IF EXISTS guns_rest;
|
CREATE DATABASE IF NOT EXISTS guns_rest DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
|
|
SET NAMES utf8mb4;
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
-- ----------------------------
|
-- Table structure for user
|
-- ----------------------------
|
DROP TABLE IF EXISTS `user`;
|
CREATE TABLE `user` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`userName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of user
|
-- ----------------------------
|
INSERT INTO `user` VALUES (1, 'admin');
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
