snd-escloud/sql/20200317.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 115外网地址
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : 222.92.16.3:33061
 Source Schema         : service_platform

 Target Server Type    : MySQL
 Target Server Version : 50726
 File Encoding         : 65001

 Date: 17/03/2020 20:56:40
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for industrial_land_supply
-- ----------------------------
DROP TABLE IF EXISTS `industrial_land_supply`;
CREATE TABLE `industrial_land_supply`  (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `create_by` int(20) NULL DEFAULT NULL,
  `create_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `create_time` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `update_by` int(20) NULL DEFAULT NULL,
  `update_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `update_time` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `del_flag` tinyint(1) NULL DEFAULT NULL,
  `no` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '编号',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '标题',
  `location` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '地点',
  `content` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '介绍',
  `process_stage` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '项目阶段',
  `approve_status` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '项目状态',
  `supplement` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '补充信息',
  `consultation_summary` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '咨询汇总',
  `distribution_summary` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '分发汇总',
  `accept_date` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '受理日期',
  `commerce_leader_pre_approve_operate` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '商务局领导 预审操作结果',
  `commerce_leader_pre_approve_comment` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '商务局领导 预审审核意见',
  `committee_leader_pre_approve_operate` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '分管领导领导 预审操作结果',
  `committee_leader_pre_approve_comment` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '分管领导领导 预审审核意见',
  `joint_trial` tinyint(255) NULL DEFAULT NULL COMMENT '是否专题会审',
  `joint_trial_comment` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '会审意见',
  `joint_trial_result` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '会审结果',
  `land_supply_comment` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '供地审批 审批意见',
  `land_supply_result` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '供地审批 审批结果',
  `final_comment` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '最终信息 审核信息',
  `final_result` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '最终信息 审批状态',
  `gs_feedback` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '行政反馈信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2470 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '产业供地详情' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for industrial_land_supply_consultation
-- ----------------------------
DROP TABLE IF EXISTS `industrial_land_supply_consultation`;
CREATE TABLE `industrial_land_supply_consultation`  (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `create_by` int(20) NULL DEFAULT NULL,
  `create_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `create_time` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `update_by` int(20) NULL DEFAULT NULL,
  `update_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `update_time` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `del_flag` tinyint(1) NULL DEFAULT NULL,
  `industrial_land_supply_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '产业供地id',
  `department_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '部门id',
  `consultation` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '咨询',
  `feedback` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT '反馈',
  `consultation_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '咨询时间',
  `feedback_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '回答时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2480 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '产业供地咨询表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for industrial_land_supply_distribution
-- ----------------------------
DROP TABLE IF EXISTS `industrial_land_supply_distribution`;
CREATE TABLE `industrial_land_supply_distribution`  (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `create_by` int(20) NULL DEFAULT NULL,
  `create_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `create_time` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `update_by` int(20) NULL DEFAULT NULL,
  `update_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `update_time` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `del_flag` tinyint(1) NULL DEFAULT NULL,
  `industrial_land_supply_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '产业供地id',
  `department_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '部门id',
  `feedback` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '反馈',
  `distribute_time` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '分发时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2452 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '产业供地分发表' ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 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 (363, 201, '产业供地', 0, '\"\"', 'G_LAND_SUPPLY', 0, NULL, -1, '系统', '2020-03-05', NULL, NULL, NULL, 0, 0);
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 (364, 363, '待处理', 0, '\"\"', 'G_LAND_SUPPLY_WAIT', 0, NULL, -1, '系统', '2020-03-05', NULL, NULL, NULL, 0, 0);
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 (365, 363, '已处理', 0, '\"\"', 'G_LAND_SUPPLY_HANDLE', 0, NULL, -1, '系统', '2020-03-05', NULL, NULL, NULL, 0, 0);
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 (366, 207, '产业供地', 4, '\"\"', 'S_LAND_SUPPLY', 0, NULL, -1, '系统', '2020-03-05', NULL, NULL, NULL, 0, 0);
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 (367, 366, '待处理', 4, '\"\"', 'S_LAND_SUPPLY_WAIT', 0, NULL, -1, '系统', '2020-03-05', NULL, NULL, NULL, 0, 0);
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 (368, 366, '已处理', 4, '\"\"', 'S_LAND_SUPPLY_HANDLE', 0, NULL, -1, '系统', '2020-03-05', NULL, NULL, NULL, 0, 0);
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 (369, 363, '项目列表', 0, '\"\"', 'G_LAND_SUPPLY_ALL', 0, NULL, -1, '系统', '2020-03-05', NULL, NULL, NULL, 0, 0);