sharding2.sql 3.8 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788
  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 : sharding2
  8. Target Server Type : MySQL
  9. Target Server Version : 50734
  10. File Encoding : 65001
  11. Date: 21/02/2022 10:35:11
  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. `tindex` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
  22. `tkey` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'key',
  23. `tvalue` 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. INDEX `idx_tindex`(`tindex`) USING BTREE,
  27. INDEX `idx_tkey`(`tkey`) USING BTREE
  28. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  29. -- ----------------------------
  30. -- Records of t_dict
  31. -- ----------------------------
  32. INSERT INTO `t_dict` VALUES (1, '成功', 'SUCCESS', '成功', '2022-02-21 10:12:36');
  33. INSERT INTO `t_dict` VALUES (2, '失败', 'ERROR', '失败', '2022-02-21 10:13:07');
  34. -- ----------------------------
  35. -- Table structure for t_order_2022
  36. -- ----------------------------
  37. DROP TABLE IF EXISTS `t_order_2022`;
  38. CREATE TABLE `t_order_2022` (
  39. `id` bigint(18) NOT NULL COMMENT '主键',
  40. `user_id` bigint(18) NOT NULL COMMENT '用户id',
  41. `order_num` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单编号',
  42. `money` decimal(20, 0) NULL DEFAULT NULL COMMENT '订单金额',
  43. `dict_key` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据字典表',
  44. `year` int(10) NULL DEFAULT NULL COMMENT '新增年份',
  45. `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  46. PRIMARY KEY (`id`) USING BTREE,
  47. INDEX `idx_user_id`(`user_id`) USING BTREE,
  48. INDEX `idx_dict_key`(`dict_key`) USING BTREE,
  49. INDEX `idx_year`(`year`) USING BTREE
  50. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  51. -- ----------------------------
  52. -- Records of t_order_2022
  53. -- ----------------------------
  54. INSERT INTO `t_order_2022` VALUES (1495583698296795137, 772, '34', 360, 'SUCCESS', 2022, '2022-01-03 00:00:00');
  55. -- ----------------------------
  56. -- Table structure for t_order_2023
  57. -- ----------------------------
  58. DROP TABLE IF EXISTS `t_order_2023`;
  59. CREATE TABLE `t_order_2023` (
  60. `id` bigint(18) NOT NULL COMMENT '主键',
  61. `user_id` bigint(18) NOT NULL COMMENT '用户id',
  62. `order_num` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单编号',
  63. `money` decimal(20, 0) NULL DEFAULT NULL COMMENT '订单金额',
  64. `dict_key` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据字典表',
  65. `year` int(10) NULL DEFAULT NULL COMMENT '新增年份',
  66. `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  67. PRIMARY KEY (`id`) USING BTREE,
  68. INDEX `idx_user_id`(`user_id`) USING BTREE,
  69. INDEX `idx_dict_key`(`dict_key`) USING BTREE,
  70. INDEX `idx_year`(`year`) USING BTREE
  71. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  72. -- ----------------------------
  73. -- Records of t_order_2023
  74. -- ----------------------------
  75. INSERT INTO `t_order_2023` VALUES (1495583744379613185, 772, '95', 760, 'SUCCESS', 2023, '2023-01-03 01:00:00');
  76. INSERT INTO `t_order_2023` VALUES (1495583766806556673, 772, '370', 709, 'SUCCESS', 2023, '2023-01-03 02:00:00');
  77. SET FOREIGN_KEY_CHECKS = 1;