Strona główna Odkrywaj Pomoc
Zarejestruj się Zaloguj się
lyhzzz
/
4dkankan-after-sale
1
0
Forkuj 0
Pliki Problemy 0 Oczekujące zmiany 0 Wiki
Gałąź: master
Gałęzie Tagi
4dkankan-aft...
/
doc
/
update.1.7.0.sql

update.1.7.0.sql 7.3 KB
Bezpośredni odnośnik Historia Czysty

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778 
  1. -- ----------------------------
    2. 

  2. -- Table structure for t_dict
    3. 

  3. -- ----------------------------
    4. 

  4. DROP TABLE IF EXISTS `t_dict`;
    5. 

  5. CREATE TABLE `t_dict`  (
    6. 

  6.                            `id` int NOT NULL AUTO_INCREMENT,
    7. 

  7.                            `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
    8. 

  8.                            `dict_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
    9. 

  9.                            `parent_id` int NULL DEFAULT NULL,
    10. 

  10.                            `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'A',
    11. 

  11.                            `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    12. 

  12.                            `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    13. 

  13.                            PRIMARY KEY (`id`) USING BTREE
    14. 

  14. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    15. 

  15. 

  16. -- ----------------------------
    17. 

  17. -- Records of t_dict
    18. 

  18. -- ----------------------------
    19. 

  19. INSERT INTO `t_dict` VALUES (1, '正常维修', 'repair-type', NULL, 'A', '2025-01-16 14:44:03', '2025-01-16 14:52:19');
    20. 

  20. INSERT INTO `t_dict` VALUES (2, '退换货维修', 'repair-type', NULL, 'A', '2025-01-16 14:44:08', '2025-01-16 14:52:19');
    21. 

  21. INSERT INTO `t_dict` VALUES (3, '内部维修', 'repair-type', NULL, 'A', '2025-01-16 14:44:11', '2025-01-16 14:52:19');
    22. 

  22. INSERT INTO `t_dict` VALUES (6, '相机', 'repair-item', NULL, 'A', '2025-01-16 14:51:05', '2025-01-16 14:51:58');
    23. 

  23. INSERT INTO `t_dict` VALUES (7, '配件', 'repair-item', NULL, 'A', '2025-01-16 14:51:10', '2025-01-16 14:52:00');
    24. 

  24. INSERT INTO `t_dict` VALUES (8, '四维看看', 'repair-item', 6, 'A', '2025-01-16 14:52:30', '2025-01-16 14:54:52');
    25. 

  25. INSERT INTO `t_dict` VALUES (9, '四维看见', 'repair-item', 6, 'A', '2025-01-16 14:52:35', '2025-01-16 14:54:52');
    26. 

  26. INSERT INTO `t_dict` VALUES (10, '四维深光', 'repair-item', 6, 'A', '2025-01-16 14:52:41', '2025-01-16 14:54:55');
    27. 

  27. INSERT INTO `t_dict` VALUES (11, '四维深时', 'repair-item', 6, 'A', '2025-01-16 14:52:47', '2025-01-16 14:54:55');
    28. 

  28. INSERT INTO `t_dict` VALUES (12, 'RTK', 'repair-item', 7, 'A', '2025-01-16 14:53:06', '2025-01-16 14:54:55');
    29. 

  29. INSERT INTO `t_dict` VALUES (13, '补光灯', 'repair-item', 7, 'A', '2025-01-16 14:53:11', '2025-01-16 14:54:55');
    30. 

  30. INSERT INTO `t_dict` VALUES (14, '看看三脚架', 'repair-item', 7, 'A', '2025-01-16 14:53:19', '2025-01-16 14:54:55');
    31. 

  31. INSERT INTO `t_dict` VALUES (15, '看见三脚架', 'repair-item', 7, 'A', '2025-01-16 14:53:26', '2025-01-16 14:54:55');
    32. 

  32. INSERT INTO `t_dict` VALUES (16, '深光三脚架', 'repair-item', 7, 'A', '2025-01-16 14:53:34', '2025-01-16 14:54:55');
    33. 

  33. INSERT INTO `t_dict` VALUES (17, '深时三脚架', 'repair-item', 7, 'A', '2025-01-16 14:53:42', '2025-01-16 14:54:55');
    34. 

  34. INSERT INTO `t_dict` VALUES (18, '滑轮', 'repair-item', 7, 'A', '2025-01-16 14:53:51', '2025-01-16 14:54:55');
    35. 

  35. INSERT INTO `t_dict` VALUES (19, '镜头报错', 'fault-type', NULL, 'A', '2025-01-16 15:31:27', '2025-01-16 15:32:14');
    36. 

  36. INSERT INTO `t_dict` VALUES (20, '拍摄图像异常', 'fault-type', NULL, 'A', '2025-01-16 15:32:34', '2025-01-16 15:38:00');
    37. 

  37. INSERT INTO `t_dict` VALUES (21, '无法正常开机', 'fault-type', NULL, 'A', '2025-01-16 15:32:39', '2025-01-16 15:38:00');
    38. 

  38. INSERT INTO `t_dict` VALUES (22, '内部异响', 'fault-type', NULL, 'A', '2025-01-16 15:32:45', '2025-01-16 15:38:00');
    39. 

  39. INSERT INTO `t_dict` VALUES (23, '相机外观', 'fault-type', NULL, 'A', '2025-01-16 15:32:49', '2025-01-16 15:38:00');
    40. 

  40. INSERT INTO `t_dict` VALUES (24, '其他类型', 'fault-type', NULL, 'A', '2025-01-16 15:32:54', '2025-01-16 15:38:01');
    41. 

  41. INSERT INTO `t_dict` VALUES (25, '排线松脱', 'fault-type', 19, 'A', '2025-01-16 15:33:13', '2025-01-16 15:38:44');
    42. 

  42. INSERT INTO `t_dict` VALUES (26, '镜头板故障', 'fault-type', 19, 'A', '2025-01-16 15:33:26', '2025-01-16 15:38:44');
    43. 

  43. INSERT INTO `t_dict` VALUES (27, 'FPGA板与主板不匹配', 'fault-type', 19, 'A', '2025-01-16 15:33:39', '2025-01-16 15:38:44');
    44. 

  44. INSERT INTO `t_dict` VALUES (28, '摔落破损', 'fault-type', 19, 'A', '2025-01-16 15:34:04', '2025-01-16 15:38:44');
    45. 

  45. INSERT INTO `t_dict` VALUES (29, '排线破损', 'fault-type', 19, 'A', '2025-01-16 15:34:09', '2025-01-16 15:38:44');
    46. 

  46. INSERT INTO `t_dict` VALUES (30, 'FPGA板接口破损', 'fault-type', 19, 'A', '2025-01-16 15:34:22', '2025-01-16 15:38:44');
    47. 

  47. INSERT INTO `t_dict` VALUES (31, '镜头断裂', 'fault-type', 20, 'A', '2025-01-16 15:34:29', '2025-01-16 15:38:55');
    48. 

  48. INSERT INTO `t_dict` VALUES (32, '镜头松动失焦', 'fault-type', 20, 'A', '2025-01-16 15:34:43', '2025-01-16 15:38:55');
    49. 

  49. INSERT INTO `t_dict` VALUES (33, '镜头成像异常（发红，发黑）', 'fault-type', 20, 'A', '2025-01-16 15:34:59', '2025-01-16 15:38:55');
    50. 

  50. INSERT INTO `t_dict` VALUES (34, '拼接异常（标定）', 'fault-type', 20, 'A', '2025-01-16 15:35:14', '2025-01-16 15:38:55');
    51. 

  51. INSERT INTO `t_dict` VALUES (35, '电池硬件版本不符', 'fault-type', 21, 'A', '2025-01-16 15:35:30', '2025-01-16 15:39:03');
    52. 

  52. INSERT INTO `t_dict` VALUES (36, '电池老化', 'fault-type', 21, 'A', '2025-01-16 15:35:36', '2025-01-16 15:39:03');
    53. 

  53. INSERT INTO `t_dict` VALUES (37, '开机卡LOGO', 'fault-type', 21, 'A', '2025-01-16 15:35:42', '2025-01-16 15:39:03');
    54. 

  54. INSERT INTO `t_dict` VALUES (38, '开机自动关机', 'fault-type', 21, 'A', '2025-01-16 15:35:53', '2025-01-16 15:39:03');
    55. 

  55. INSERT INTO `t_dict` VALUES (39, '风扇排线过长', 'fault-type', 22, 'A', '2025-01-16 15:36:06', '2025-01-16 15:39:15');
    56. 

  56. INSERT INTO `t_dict` VALUES (40, '风扇断裂', 'fault-type', 22, 'A', '2025-01-16 15:36:14', '2025-01-16 15:39:15');
    57. 

  57. INSERT INTO `t_dict` VALUES (41, '内部螺丝断裂脱落', 'fault-type', 22, 'A', '2025-01-16 15:36:26', '2025-01-16 15:39:15');
    58. 

  58. INSERT INTO `t_dict` VALUES (42, '外壳破损', 'fault-type', 23, 'A', '2025-01-16 15:36:40', '2025-01-16 15:39:29');
    59. 

  59. INSERT INTO `t_dict` VALUES (43, '镜头刮花', 'fault-type', 23, 'A', '2025-01-16 15:36:47', '2025-01-16 15:39:29');
    60. 

  60. INSERT INTO `t_dict` VALUES (44, '前盖刮花', 'fault-type', 23, 'A', '2025-01-16 15:36:54', '2025-01-16 15:39:29');
    61. 

  61. INSERT INTO `t_dict` VALUES (45, '后盖刮花', 'fault-type', 23, 'A', '2025-01-16 15:37:00', '2025-01-16 15:39:29');
    62. 

  62. INSERT INTO `t_dict` VALUES (46, '镜头圈丢失', 'fault-type', 23, 'A', '2025-01-16 15:37:07', '2025-01-16 15:39:29');
    63. 

  63. INSERT INTO `t_dict` VALUES (47, '无法搜索到WIFI', 'fault-type', 24, 'A', '2025-01-16 15:37:18', '2025-01-16 15:39:35');
    64. 

  64. INSERT INTO `t_dict` VALUES (48, 'WIFI无法连接', 'fault-type', 24, 'A', '2025-01-16 15:37:26', '2025-01-16 15:39:35');
    65. 

  65. INSERT INTO `t_dict` VALUES (49, '故障不再现', 'fault-type', 24, 'A', '2025-01-16 15:37:36', '2025-01-16 15:39:35');
    66. 

  66. INSERT INTO `t_dict` VALUES (50, '显示屏故障', 'fault-type', 24, 'A', '2025-01-16 15:37:41', '2025-01-16 15:39:35');
    67. 

  67. INSERT INTO `t_dict` VALUES (51, '无法充电', 'fault-type', 24, 'A', '2025-01-16 15:37:45', '2025-01-16 15:39:35');
    68. 

  68. 

  69. ALTER TABLE `4dkankan_v4_sale`.`t_repair`
    70. 

  70.     ADD COLUMN `repair_type` varchar(255) NULL AFTER `cancel_remark`,
    71. 

  71.     ADD COLUMN `repair_item` varchar(255) NULL AFTER `repair_type`;
    72. 

  72. 

  73. ALTER TABLE `4dkankan_v4_sale`.`t_repair_register`
    74. 

  74.     ADD COLUMN `fault_type` varchar(255) NULL AFTER `define_damage`;
    75. 

  75. 

  76. 

  77. ALTER TABLE `4dkankan_v4_sale`.`t_repair`
    78. 

  78.     ADD COLUMN `fault_version` varchar(255) NULL DEFAULT 'V1' AFTER `repair_item`;
    79.