/*
|
Navicat Premium Data Transfer
|
|
Source Server : localhost_3306
|
Source Server Type : MySQL
|
Source Server Version : 50737
|
Source Host : localhost:3306
|
Source Schema : springboot-vue3
|
|
Target Server Type : MySQL
|
Target Server Version : 50737
|
File Encoding : 65001
|
|
Date: 24/06/2023 10:59:04
|
*/
|
|
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,
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '姓名',
|
`date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '日期',
|
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '地址',
|
`user_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '编号',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of user
|
-- ----------------------------
|
INSERT INTO `user` VALUES (2, '张三', '2023-06-11', '安徽省合肥市', 'OKS12313');
|
INSERT INTO `user` VALUES (3, '青哥哥', '2023-06-12', '江苏省南京市', 'QA8546');
|
INSERT INTO `user` VALUES (4, '小黑子1', '2023-06-12', '江苏省南京市', 'WWD21');
|
INSERT INTO `user` VALUES (5, '小黑子2', '2023-06-12', '江苏省南京市', 'WWD21');
|
INSERT INTO `user` VALUES (6, '小黑子3', '2023-06-12', '江苏省南京市', 'WWD21');
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
