12345678910111213141516171819202122232425262728293031323334353637383940414243444546 |
- /*
- Navicat Premium Data Transfer
- Source Server : 自己的阿里云3年mysql
- Source Server Type : MySQL
- Source Server Version : 50734
- Source Host : 47.108.115.128:3306
- Source Schema : sharding0
- Target Server Type : MySQL
- Target Server Version : 50734
- File Encoding : 65001
- Date: 18/02/2022 17:08:45
- */
- SET NAMES utf8mb4;
- SET FOREIGN_KEY_CHECKS = 0;
- -- ----------------------------
- -- Table structure for t_dict
- -- ----------------------------
- DROP TABLE IF EXISTS `t_dict`;
- CREATE TABLE `t_dict` (
- `id` bigint(18) NOT NULL COMMENT '主键',
- `t_name` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
- `t_key` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'key',
- `t_value` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'value',
- `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for t_user
- -- ----------------------------
- DROP TABLE IF EXISTS `t_user`;
- CREATE TABLE `t_user` (
- `id` bigint(18) NOT NULL AUTO_INCREMENT COMMENT '主键',
- `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名',
- `age` int(11) NULL DEFAULT NULL COMMENT '年龄',
- `year` int(10) NULL DEFAULT NULL COMMENT '新增年份',
- `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 773 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
- SET FOREIGN_KEY_CHECKS = 1;
|