/*
 Navicat Premium Data Transfer

 Source Server         : 阿里云
 Source Server Type    : MySQL
 Source Server Version : 50736
 Source Host           : 112.74.86.144:3306
 Source Schema         : scms

 Target Server Type    : MySQL
 Target Server Version : 50736
 File Encoding         : 65001

 Date: 30/01/2024 18:14:33
*/

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 COMMENT '主键',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `age` int(11) NULL DEFAULT NULL COMMENT '年龄',
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '城市',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, '钟子音', 24, '广东省茂名市', '茂名');
INSERT INTO `user` VALUES (2, '李宋茜', 24, '广东省湛江市', '湛江');
INSERT INTO `user` VALUES (3, '李国强', 24, '江西省南昌市', '南昌');
INSERT INTO `user` VALUES (4, '王琪', 21, '广东省茂名市兰山留村', '茂名');
INSERT INTO `user` VALUES (5, '钟秀才', 31, '北京市东城区', '北京');
INSERT INTO `user` VALUES (6, '刘付聪', 18, '广东省广州市', '广州');
INSERT INTO `user` VALUES (7, '李洪', 25, '广东省广州市天河区', '广州');
INSERT INTO `user` VALUES (8, '王志旋', 21, '广东省清远市', '清远');
INSERT INTO `user` VALUES (9, '李丹', 27, '湖南省长沙市', '长沙');
INSERT INTO `user` VALUES (10, '张知青', 33, '广西贺州', '贺州');
INSERT INTO `user` VALUES (11, '刘德华', 18, '广东省广州市', '广州');
INSERT INTO `user` VALUES (12, '张学友', 50, '广东省广州市', '广州');
INSERT INTO `user` VALUES (13, '张国荣', 24, '广东省广州市', '广州');
INSERT INTO `user` VALUES (14, '刘广州', 24, '广东省广州市', '广州');
INSERT INTO `user` VALUES (15, '张北京', 12, '北京市海定区', '北京');

SET FOREIGN_KEY_CHECKS = 1;