Startseite Erkunden Hilfe
Anmelden
shuf
/
sql
1
0
Fork 0
Dateien Issues 0 Pull-Requests 0 Wiki
Struktur: 5040efd7b3
Branches Tags
sql
/
upgrade_260806
/
system.sql

system.sql 11 KB
Verlauf Originalformat

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566 
  1. SET FOREIGN_KEY_CHECKS=0;
    2. 

  2. 

  3. ALTER TABLE `systemservice`.`sys_user` ADD COLUMN `project_no` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目编号' AFTER `park_tag`;
    4. 

  4. 

  5. ALTER TABLE `systemservice`.`tool_ad_park` ADD COLUMN `project_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '项目名称' AFTER `park_name`;
    6. 

  6. 

  7. ALTER TABLE `systemservice`.`tool_ad_park` ADD COLUMN `api_type` tinyint NOT NULL COMMENT '广告商 1:知蛛' AFTER `update_time`;
    8. 

  8. 

  9. ALTER TABLE `systemservice`.`tool_ad_park` ADD COLUMN `ext_default` tinyint NOT NULL DEFAULT 0 COMMENT '是否使用默认配置 0否 1是' AFTER `api_type`;
    10. 

  10. 

  11. ALTER TABLE `systemservice`.`tool_ad_park` ADD COLUMN `region_id` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '区域Id，优先取车场area，再取city，没有就取province' AFTER `ext_default`;
    12. 

  12. 

  13. ALTER TABLE `systemservice`.`tool_ad_park` ADD COLUMN `province_id` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '省' AFTER `region_id`;
    14. 

  14. 

  15. ALTER TABLE `systemservice`.`tool_ad_park` ADD COLUMN `city_id` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '市' AFTER `province_id`;
    16. 

  16. 

  17. ALTER TABLE `systemservice`.`tool_ad_park` ADD COLUMN `area_id` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '区' AFTER `city_id`;
    18. 

  18. 

  19. INSERT INTO `systemservice`.`sys_dict` (`type_name`, `type_code`, `create_name`, `create_time`) VALUES ('设备相机类型', 'device_camera_type', 'system', '2026-04-17 18:51:23');
    20. 

  20. INSERT INTO `systemservice`.`sys_dict` (`type_name`, `type_code`, `create_name`, `create_time`) VALUES ('设备地感启用模式', 'device_loop_mode', 'system', '2026-04-17 18:51:23');
    21. 

  21. INSERT INTO `systemservice`.`sys_dict` (`type_name`, `type_code`, `create_name`, `create_time`) VALUES ('设备语音主板', 'device_voice_board', 'system', '2026-04-17 18:51:23');
    22. 

  22. INSERT INTO `systemservice`.`sys_dict` (`type_name`, `type_code`, `create_name`, `create_time`) VALUES ('设备产品线', 'device_product_line', 'system', '2026-04-17 18:52:36');
    23. 

  23. INSERT INTO `systemservice`.`sys_dict` (`type_name`, `type_code`, `create_name`, `create_time`) VALUES ('设备产品类型', 'device_product_category', 'system', '2026-04-17 18:52:36');
    24. 

  24. INSERT INTO `systemservice`.`sys_dict` (`type_name`, `type_code`, `create_name`, `create_time`) VALUES ('设备产品型号', 'device_product_model', 'system', '2026-04-17 18:52:36');
    25. 

  25. INSERT INTO `systemservice`.`sys_dict` (`type_name`, `type_code`, `create_name`, `create_time`) VALUES ('设备相机协议', 'device_camera_protocol', 'system', '2026-05-18 14:52:53');
    26. 

  26. INSERT INTO `systemservice`.`sys_dict` (`type_name`, `type_code`, `create_name`, `create_time`) VALUES ('设备显示屏', 'device_display_screen', 'system', '2026-05-18 14:52:53');
    27. 

  27. 

  28. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_camera_type', 'R5L', 'R5L', 1, 1, 'system', '2026-04-17 18:51:23.000000');
    29. 

  29. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_camera_type', 'C5', 'C5', 2, 1, 'system', '2026-04-17 18:51:23.000000');
    30. 

  30. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_loop_mode', '有地感', 'WITH_LOOP', 1, 1, 'system', '2026-04-17 18:51:23.000000');
    31. 

  31. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_loop_mode', '无地感', 'NO_LOOP', 2, 1, 'system', '2026-04-17 18:51:23.000000');
    32. 

  32. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_voice_board', '道通', 'DAO_TONG', 1, 1, 'system', '2026-04-17 18:51:23.000000');
    33. 

  33. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_voice_board', '富士', 'FUJICA', 2, 1, 'system', '2026-04-17 18:51:23.000000');
    34. 

  34. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_line', '车场', '0', 1, 1, 'system', '2026-04-17 18:52:36.000000');
    35. 

  35. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_line', '车位', '1', 2, 1, 'system', '2026-04-17 18:52:36.000000');
    36. 

  36. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_category', '车场控制机', '0|1|0001', 1, 1, 'system', '2026-04-17 18:52:36.000000');
    37. 

  37. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_category', '车场监控相机', '0|3|0003', 2, 1, 'system', '2026-04-17 18:52:36.000000');
    38. 

  38. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_category', '车场辅机', '0|2|0002', 3, 1, 'system', '2026-04-17 18:52:36.000000');
    39. 

  39. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_model', 'FJC-TX21', '0|1|0001|1001', 1, 1, 'system', '2026-04-17 18:52:36.000000');
    40. 

  40. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_model', 'FJC-TX27B', '0|1|0001|1002', 2, 1, 'system', '2026-04-17 18:52:36.000000');
    41. 

  41. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_model', 'FJC-CWQ201', '0|3|0003|2001', 1, 1, 'system', '2026-04-17 18:52:36.000000');
    42. 

  42. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_model', 'FJC-CWQ310', '0|3|0003|2002', 2, 1, 'system', '2026-04-17 18:52:36.000000');
    43. 

  43. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_model', 'TJC-TX24F-B', '0|2|0002|3001', 1, 1, 'system', '2026-04-17 18:52:36.000000');
    44. 

  44. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('orderBizType', '储值账户', '7', 8, 1, 'admin', '2026-04-24 11:51:35.000000');
    45. 

  45. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_camera_protocol', '瑧识', 'VZICLOUD', 1, 1, 'system', '2026-05-18 14:53:26.000000');
    46. 

  46. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_camera_protocol', '信路通', 'XLT', 2, 1, 'system', '2026-05-18 14:53:26.000000');
    47. 

  47. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_display_screen', '道通LCD', 'DAOTONG_LCD', 1, 1, 'system', '2026-05-18 14:53:26.000000');
    48. 

  48. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_display_screen', '自研LCD', 'FUJICA_LCD', 2, 1, 'system', '2026-05-18 14:53:26.000000');
    49. 

  49. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_display_screen', '自研LED', 'FUJICA_LED', 3, 1, 'system', '2026-05-18 14:53:26.000000');
    50. 

  50. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_category', '车场显示屏', '0|4|0004', 4, 1, 'system', '2026-05-19 16:18:07.000000');
    51. 

  51. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_category', '车场道闸', '0|5|0005', 5, 1, 'system', '2026-05-19 16:18:07.000000');
    52. 

  52. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_category', '车场地感', '0|6|0006', 6, 1, 'system', '2026-05-19 16:18:07.000000');
    53. 

  53. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_model', '道通LCD屏', '0|4|0004|4001', 1, 1, 'system', '2026-05-19 16:18:07.000000');
    54. 

  54. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_model', '自研LCD屏', '0|4|0004|4002', 2, 1, 'system', '2026-05-19 16:18:07.000000');
    55. 

  55. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_model', '自研LED屏', '0|4|0004|4003', 3, 1, 'system', '2026-05-19 16:18:07.000000');
    56. 

  56. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_model', '道闸', '0|5|0005|5001', 1, 1, 'system', '2026-05-19 16:18:07.000000');
    57. 

  57. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_model', '标准地感', '0|6|0006|6001', 1, 1, 'system', '2026-05-19 16:18:07.000000');
    58. 

  58. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('invoiceStatus', '已作废', '4', 5, 1, 'admin', '2026-06-10 17:28:04.000000');
    59. 

  59. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('invoiceStatus', '已冲红', '5', 6, 1, 'admin', '2026-06-10 17:28:04.000000');
    60. 

  60. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('invoiceStatus', '申请失败', '6', 7, 1, 'admin', '2026-06-10 17:28:04.000000');
    61. 

  61. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('invoiceStatus', '已冲红未开新票', '7', 8, 1, 'admin', '2026-06-10 17:28:04.000000');
    62. 

  62. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('invoicePlatform', '支付宝', 'ALI', 6, 1, 'admin', '2026-06-23 10:25:57.000000');
    63. 

  63. INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('invoicePlatform', '微信', 'WX', 7, 1, 'admin', '2026-07-21 08:55:47.000000');
    64. 

  64. 

  65. 

  66. SET FOREIGN_KEY_CHECKS=1;
    67.