CREATE DATABASE IF NOT EXISTS ting;
USE ting;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `password` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `age` int(11) NOT NULL,
  `sex` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `address` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `status` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 49 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, '张三', '123', 18, 'man', '广东', 0);
INSERT INTO `user` VALUES (2, '李四', '456', 19, 'woman', '湖南', 1);
INSERT INTO `user` VALUES (3, '王五', '789', 20, 'man', '湖北', 2);
INSERT INTO `user` VALUES (4, '赵六', '123', 21, 'woman', '北京', 0);
INSERT INTO `user` VALUES (5, '田七', '456', 22, 'man', '上海', 1);
INSERT INTO `user` VALUES (6, '李八', '789', 18, 'woman', '广东', 0);
INSERT INTO `user` VALUES (7, '王九', '123', 17, 'man', '湖北', 1);
INSERT INTO `user` VALUES (8, '赵十', '456', 16, 'woman', '广西', 0);
INSERT INTO `user` VALUES (9, '李十一', '456', 15, 'woman', '湖南', 1);
INSERT INTO `user` VALUES (10, '王十二', '789', 14, 'man', '湖北', 1);
INSERT INTO `user` VALUES (11, '赵十三', '123', 18, 'woman', '北京', 0);
INSERT INTO `user` VALUES (12, '田十四', '456', 50, 'man', '上海', 1);
INSERT INTO `user` VALUES (13, '李十五', '789', 51, 'woman', '广东', 0);
INSERT INTO `user` VALUES (14, '王十六', '123', 52, 'man', '湖北', NULL);
INSERT INTO `user` VALUES (15, '赵十七', '456', 53, 'woman', '广西', 0);
INSERT INTO `user` VALUES (17, '李十八', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (18, '李十九', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (19, '李二十', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (20, '李二十一', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (21, '李二十二', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (22, '李二十三', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (23, '李二十四', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (24, '李二十五', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (25, '李十八', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (27, '李十八', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (28, 'mybatis', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (29, 'mybatis', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (30, '李二十五', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (31, '李二十六', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (32, 'mybatis', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (33, '李二十五', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (34, '李二十六', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (35, 'mybatis', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (36, '李二十五', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (37, '李二十六', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (38, 'mybatis', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (39, '李二十五', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (40, '李二十六', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (41, 'mybatis', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (42, '李二十五', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (43, '李二十六', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (44, 'mybatis', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (45, 'mybatis', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (46, 'mybatis', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (47, 'mybatis', '123', 20, 'man', '西藏', 1);
INSERT INTO `user` VALUES (48, 'mybatis26', '123', 20, 'man', '西藏', 1);

SET FOREIGN_KEY_CHECKS = 1;