2022-11-12.sql 3.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142
  1. INSERT INTO `service_platform`.`sys_menu` (`id`, `parent_id`, `name`, `user_type`, `url`, `permission`, `sort`, `levels`, `create_by`, `create_name`, `create_time`, `update_by`, `update_name`, `update_time`, `del_flag`, `is_mobile`) VALUES (374, 284, '产业供地预审', 0, '\"\"', 'G_STOCKLAND_PREJUDICE', 21, NULL, -1, '系统', '2022-11-06', NULL, NULL, NULL, 0, 0);
  2. CREATE TABLE `industrial_land_supply_status_config` (
  3. `id` int(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  4. `create_by` int(20) DEFAULT NULL,
  5. `create_name` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
  6. `create_time` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
  7. `update_by` int(20) DEFAULT NULL,
  8. `update_name` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
  9. `update_time` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
  10. `del_flag` tinyint(1) DEFAULT NULL,
  11. `stage` varchar(2) COLLATE utf8_bin DEFAULT NULL,
  12. `status_value` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '阶段值',
  13. `status_name` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '阶段名称',
  14. PRIMARY KEY (`id`) USING BTREE
  15. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='产业供地状态表';
  16. INSERT INTO `industrial_land_supply_status_config` ( `stage`, `status_value`, `status_name`) VALUES ('1', '1', '1');
  17. INSERT INTO `industrial_land_supply_status_config` ( `stage`, `status_value`, `status_name`) VALUES ('1', '2', '2');
  18. INSERT INTO `industrial_land_supply_status_config` ( `stage`, `status_value`, `status_name`) VALUES ('1', '3', '3');
  19. INSERT INTO `industrial_land_supply_status_config` ( `stage`, `status_value`, `status_name`) VALUES ('1', '4', '4');
  20. INSERT INTO `industrial_land_supply_status_config` ( `stage`, `status_value`, `status_name`) VALUES ('1', '5', '5');
  21. INSERT INTO `industrial_land_supply_status_config` ( `stage`, `status_value`, `status_name`) VALUES ('1', '6', '6');
  22. INSERT INTO `industrial_land_supply_status_config` ( `stage`, `status_value`, `status_name`) VALUES ('1', '7', '7');
  23. INSERT INTO `industrial_land_supply_status_config` ( `stage`, `status_value`, `status_name`) VALUES ('1', '8', '8');
  24. INSERT INTO `industrial_land_supply_status_config` ( `stage`, `status_value`, `status_name`) VALUES ('1', '9', '9');
  25. INSERT INTO `industrial_land_supply_status_config` ( `stage`, `status_value`, `status_name`) VALUES ('1', '10', '10');
  26. INSERT INTO `industrial_land_supply_status_config` ( `stage`, `status_value`, `status_name`) VALUES ('1', '11', '11');
  27. INSERT INTO `industrial_land_supply_status_config` ( `stage`, `status_value`, `status_name`) VALUES ('1', '12', '12');
  28. INSERT INTO `industrial_land_supply_status_config` ( `stage`, `status_value`, `status_name`) VALUES ('1', '13', '13');
  29. INSERT INTO `industrial_land_supply_status_config` ( `stage`, `status_value`, `status_name`) VALUES ('1', '14', '14');
  30. INSERT INTO `industrial_land_supply_status_config` ( `stage`, `status_value`, `status_name`) VALUES ('2', '15', '15');
  31. INSERT INTO `industrial_land_supply_status_config` ( `stage`, `status_value`, `status_name`) VALUES ('2', '16', '16');
  32. INSERT INTO `industrial_land_supply_status_config` ( `stage`, `status_value`, `status_name`) VALUES ('2', '17', '17');
  33. INSERT INTO `industrial_land_supply_status_config` ( `stage`, `status_value`, `status_name`) VALUES ('2', '18', '18');
  34. INSERT INTO `industrial_land_supply_status_config` ( `stage`, `status_value`, `status_name`) VALUES ('2', '19', '19');
  35. INSERT INTO `industrial_land_supply_status_config` ( `stage`, `status_value`, `status_name`) VALUES ('2', '20', '20');
  36. INSERT INTO `industrial_land_supply_status_config` ( `stage`, `status_value`, `status_name`) VALUES ('2', '21', '21');
  37. INSERT INTO `industrial_land_supply_status_config` ( `stage`, `status_value`, `status_name`) VALUES ('2', '22', '22');