sharding0.sql 1.7 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. /*
  2. Navicat Premium Data Transfer
  3. Source Server : 自己的阿里云3年mysql
  4. Source Server Type : MySQL
  5. Source Server Version : 50734
  6. Source Host : 47.108.115.128:3306
  7. Source Schema : sharding0
  8. Target Server Type : MySQL
  9. Target Server Version : 50734
  10. File Encoding : 65001
  11. Date: 18/02/2022 17:08:45
  12. */
  13. SET NAMES utf8mb4;
  14. SET FOREIGN_KEY_CHECKS = 0;
  15. -- ----------------------------
  16. -- Table structure for t_dict
  17. -- ----------------------------
  18. DROP TABLE IF EXISTS `t_dict`;
  19. CREATE TABLE `t_dict` (
  20. `id` bigint(18) NOT NULL COMMENT '主键',
  21. `t_name` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
  22. `t_key` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'key',
  23. `t_value` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'value',
  24. `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  25. PRIMARY KEY (`id`) USING BTREE
  26. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  27. -- ----------------------------
  28. -- Table structure for t_user
  29. -- ----------------------------
  30. DROP TABLE IF EXISTS `t_user`;
  31. CREATE TABLE `t_user` (
  32. `id` bigint(18) NOT NULL AUTO_INCREMENT COMMENT '主键',
  33. `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名',
  34. `age` int(11) NULL DEFAULT NULL COMMENT '年龄',
  35. `year` int(10) NULL DEFAULT NULL COMMENT '新增年份',
  36. `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  37. PRIMARY KEY (`id`) USING BTREE
  38. ) ENGINE = InnoDB AUTO_INCREMENT = 773 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  39. SET FOREIGN_KEY_CHECKS = 1;