-
Notifications
You must be signed in to change notification settings - Fork 0
/
springboot_exp.sql
65 lines (56 loc) · 2.43 KB
/
springboot_exp.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
/*
Navicat Premium Data Transfer
Source Server : aliyun
Source Server Type : MySQL
Source Server Version : 80017
Source Host : 39.106.41.184:33306
Source Schema : springboot_exp
Target Server Type : MySQL
Target Server Version : 80017
File Encoding : 65001
Date: 19/04/2020 21:13:14
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
`id` bigint(10) NOT NULL,
`userName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`sex` enum('1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES (1, 'godfrey', '1', 'abc');
INSERT INTO `t_user` VALUES (2, 'duiyi', '2', 'cba');
INSERT INTO `t_user` VALUES (3, 'echo', '1', 'wzjsd');
INSERT INTO `t_user` VALUES (4, 'meimei', '2', 'xiaoxiao');
INSERT INTO `t_user` VALUES (5, 'didi', '1', 'sl');
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
`age` int(11) NULL DEFAULT NULL COMMENT '年龄',
`email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'godfrey', 21, '[email protected]');
INSERT INTO `user` VALUES (2, 'duiyi', 23, '[email protected]');
INSERT INTO `user` VALUES (3, 'echo', 15, '[email protected]');
INSERT INTO `user` VALUES (4, 'wu', 45, '[email protected]');
INSERT INTO `user` VALUES (5, 'guo', 16, '[email protected]');
INSERT INTO `user` VALUES (6, 'booleanbl', 12, '[email protected]');
INSERT INTO `user` VALUES (7, 'wenda', 12, '[email protected]');
INSERT INTO `user` VALUES (8, 'booleanbl', 12, '[email protected]');
SET FOREIGN_KEY_CHECKS = 1;