sharding1.sql 2.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  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 : sharding1
  8. Target Server Type : MySQL
  9. Target Server Version : 50734
  10. File Encoding : 65001
  11. Date: 18/02/2022 17:08:55
  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_order_2022
  29. -- ----------------------------
  30. DROP TABLE IF EXISTS `t_order_2022`;
  31. CREATE TABLE `t_order_2022` (
  32. `id` bigint(18) NOT NULL COMMENT '主键',
  33. `user_id` bigint(18) NOT NULL COMMENT '用户id',
  34. `order_num` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单编号',
  35. `money` decimal(20, 0) NULL DEFAULT NULL COMMENT '订单金额',
  36. `dict_key` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据字典表',
  37. `year` int(10) NULL DEFAULT NULL COMMENT '新增年份',
  38. `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  39. PRIMARY KEY (`id`) USING BTREE
  40. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  41. -- ----------------------------
  42. -- Table structure for t_order_2023
  43. -- ----------------------------
  44. DROP TABLE IF EXISTS `t_order_2023`;
  45. CREATE TABLE `t_order_2023` (
  46. `id` bigint(18) NOT NULL COMMENT '主键',
  47. `user_id` bigint(18) NOT NULL COMMENT '用户id',
  48. `order_num` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单编号',
  49. `money` decimal(20, 0) NULL DEFAULT NULL COMMENT '订单金额',
  50. `dict_key` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据字典表',
  51. `year` int(10) NULL DEFAULT NULL COMMENT '新增年份',
  52. `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  53. PRIMARY KEY (`id`) USING BTREE
  54. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  55. SET FOREIGN_KEY_CHECKS = 1;