145 lines
5.8 KiB
SQL
145 lines
5.8 KiB
SQL
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : mysql57
|
|
Source Server Type : MySQL
|
|
Source Server Version : 50732
|
|
Source Host : 127.0.0.1:3306
|
|
Source Schema : gin
|
|
|
|
Target Server Type : MySQL
|
|
Target Server Version : 50732
|
|
File Encoding : 65001
|
|
|
|
Date: 03/02/2023 10:01:55
|
|
*/
|
|
|
|
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for admin
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `admin`;
|
|
CREATE TABLE `admin` (
|
|
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
`created_at` datetime(0) NULL DEFAULT NULL,
|
|
`updated_at` datetime(0) NULL DEFAULT NULL,
|
|
`deleted_at` datetime(0) NULL DEFAULT NULL,
|
|
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
|
`age` bigint(20) NULL DEFAULT NULL,
|
|
`birthday` datetime(0) NULL DEFAULT NULL,
|
|
`email` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
|
`role` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
|
`member_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
|
|
`num` int(11) NULL DEFAULT NULL,
|
|
`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
UNIQUE INDEX `member_number`(`member_number`) USING BTREE,
|
|
UNIQUE INDEX `uix_admin_email`(`email`) USING BTREE,
|
|
INDEX `idx_admin_deleted_at`(`deleted_at`) USING BTREE,
|
|
INDEX `addr`(`address`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of admin
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for sms_animal
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `sms_animal`;
|
|
CREATE TABLE `sms_animal` (
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
|
`age` bigint(20) NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of sms_animal
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for test_user
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `test_user`;
|
|
CREATE TABLE `test_user` (
|
|
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
|
`gender` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '男',
|
|
`hobby` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of test_user
|
|
-- ----------------------------
|
|
INSERT INTO `test_user` VALUES (1, '张三', '男', '游戏');
|
|
INSERT INTO `test_user` VALUES (2, '张三', '男', '游戏');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for todo
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `todo`;
|
|
CREATE TABLE `todo` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
|
`status` tinyint(1) NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of todo
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for user
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `user`;
|
|
CREATE TABLE `user` (
|
|
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
`created_at` datetime(0) NULL DEFAULT NULL,
|
|
`updated_at` datetime(0) NULL DEFAULT NULL,
|
|
`deleted_at` datetime(0) NULL DEFAULT NULL,
|
|
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
|
`age` bigint(20) NULL DEFAULT NULL,
|
|
`birthday` datetime(0) NULL DEFAULT NULL,
|
|
`email` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
|
`role` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
|
`member_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
|
|
`num` int(11) NULL DEFAULT NULL,
|
|
`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
|
`gender` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '男',
|
|
`hobby` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
UNIQUE INDEX `member_number`(`member_number`) USING BTREE,
|
|
UNIQUE INDEX `uix_user_email`(`email`) USING BTREE,
|
|
INDEX `idx_user_deleted_at`(`deleted_at`) USING BTREE,
|
|
INDEX `addr`(`address`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of user
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for user_info
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `user_info`;
|
|
CREATE TABLE `user_info` (
|
|
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
|
`gender` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '男',
|
|
`hobby` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of user_info
|
|
-- ----------------------------
|
|
INSERT INTO `user_info` VALUES (1, 'zhuyijun', '男', '动漫1');
|
|
INSERT INTO `user_info` VALUES (2, 'zhuyijun', '男', '动漫1');
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|