首頁 探索 說明
登入
zhangtao
/
programs_info
關註 1
讚好 0
複刻 0
Files 問題管理 0 合併請求 0 Wiki
分支: master
分支列表 標籤列表
programs_info
/
胡埭市场主体两张清单
/
于杰
/
special.sql

special.sql 6.8 KB
永久連結 文件歷史 原始文件

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : 0测试数据库_47.113.226.116
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 50744
    7. 

  7.  Source Host           : 47.113.226.116:3306
    8. 

  8.  Source Schema         : idea_fire_safety_hd
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 50744
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 10/03/2025 13:52:47
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

  20. -- ----------------------------
    21. 

  21. -- Table structure for special
    22. 

  22. -- ----------------------------
    23. 

  23. DROP TABLE IF EXISTS `special`;
    24. 

  24. CREATE TABLE `special`  (
    25. 

  25.   `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
    26. 

  26.   `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
    27. 

  27.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    28. 

  28.   `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    29. 

  29.   `create_user` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
    30. 

  30.   `update_user` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',
    31. 

  31.   PRIMARY KEY (`id`) USING BTREE
    32. 

  32. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '专项领域表' ROW_FORMAT = Dynamic;
    33. 

  33. 

  34. -- ----------------------------
    35. 

  35. -- Records of special
    36. 

  36. -- ----------------------------
    37. 

  37. INSERT INTO `special` VALUES ('1', '三级消防和日常监管', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL);
    38. 

  38. INSERT INTO `special` VALUES ('10', '安全消防', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL);
    39. 

  39. INSERT INTO `special` VALUES ('11', '安全生产', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL);
    40. 

  40. INSERT INTO `special` VALUES ('12', '市场监督', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL);
    41. 

  41. INSERT INTO `special` VALUES ('13', '律师事务所', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL);
    42. 

  42. INSERT INTO `special` VALUES ('14', '房屋租赁', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL);
    43. 

  43. INSERT INTO `special` VALUES ('15', '持证合法经营', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL);
    44. 

  44. INSERT INTO `special` VALUES ('16', '教育文体', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL);
    45. 

  45. INSERT INTO `special` VALUES ('17', '既有建筑', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL);
    46. 

  46. INSERT INTO `special` VALUES ('18', '治安', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL);
    47. 

  47. INSERT INTO `special` VALUES ('19', '派出所以外的日常消防监管', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL);
    48. 

  48. INSERT INTO `special` VALUES ('2', '交通运输', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL);
    49. 

  49. INSERT INTO `special` VALUES ('20', '消防', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL);
    50. 

  50. INSERT INTO `special` VALUES ('21', '消防安全', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL);
    51. 

  51. INSERT INTO `special` VALUES ('22', '消防执法', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    52. 

  52. INSERT INTO `special` VALUES ('23', '消防监管', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    53. 

  53. INSERT INTO `special` VALUES ('24', '燃气', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    54. 

  54. INSERT INTO `special` VALUES ('25', '特种设备', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    55. 

  55. INSERT INTO `special` VALUES ('26', '环保', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    56. 

  56. INSERT INTO `special` VALUES ('27', '瓶改电', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    57. 

  57. INSERT INTO `special` VALUES ('28', '用电', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    58. 

  58. INSERT INTO `special` VALUES ('29', '电动自行车等质量', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    59. 

  59. INSERT INTO `special` VALUES ('3', '住建', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL);
    60. 

  60. INSERT INTO `special` VALUES ('30', '电动车全链条专项整治行动', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    61. 

  61. INSERT INTO `special` VALUES ('31', '电气线路', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    62. 

  62. INSERT INTO `special` VALUES ('32', '租赁', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    63. 

  63. INSERT INTO `special` VALUES ('33', '综治', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    64. 

  64. INSERT INTO `special` VALUES ('34', '违建', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    65. 

  65. INSERT INTO `special` VALUES ('35', '食品安全', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    66. 

  66. INSERT INTO `special` VALUES ('36', '危化品或剧毒、易制爆、易制毒三类危化品', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    67. 

  67. INSERT INTO `special` VALUES ('37', '压力容器、电梯等', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    68. 

  68. INSERT INTO `special` VALUES ('38', '易制毒、易制爆', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    69. 

  69. INSERT INTO `special` VALUES ('39', '消防、危化品或易燃易爆物品、治安', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    70. 

  70. INSERT INTO `special` VALUES ('4', '住房租赁', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL);
    71. 

  71. INSERT INTO `special` VALUES ('40', '燃气、危废', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    72. 

  72. INSERT INTO `special` VALUES ('41', '燃气、危废、房屋租赁', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    73. 

  73. INSERT INTO `special` VALUES ('42', '燃气、既有建筑、房屋租赁', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    74. 

  74. INSERT INTO `special` VALUES ('43', '燃气、用电（瓶改电）', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    75. 

  75. INSERT INTO `special` VALUES ('44', '特种设备、产品质量', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    76. 

  76. INSERT INTO `special` VALUES ('45', '特种设备、电动自行车质量', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    77. 

  77. INSERT INTO `special` VALUES ('46', '特种设备（压力容器、电梯、行车、叉车等）', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    78. 

  78. INSERT INTO `special` VALUES ('47', '用电（燃气、瓶改电）', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    79. 

  79. INSERT INTO `special` VALUES ('48', '银行、保险', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL);
    80. 

  80. INSERT INTO `special` VALUES ('5', '供电', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL);
    81. 

  81. INSERT INTO `special` VALUES ('6', '卫健', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL);
    82. 

  82. INSERT INTO `special` VALUES ('7', '危化品或易燃易爆物品', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL);
    83. 

  83. INSERT INTO `special` VALUES ('8', '危废', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL);
    84. 

  84. INSERT INTO `special` VALUES ('9', '商务', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL);
    85. 

  85. 

  86. SET FOREIGN_KEY_CHECKS = 1;
    87. 

  87.