snd-escloud/sql/20200402.sql

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for industrial_land_supply_config
-- ----------------------------
DROP TABLE IF EXISTS `industrial_land_supply_config`;
CREATE TABLE `industrial_land_supply_config`  (
  `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,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '名称',
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `value` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '值',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2491 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '产业供地详情' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of industrial_land_supply_config
-- ----------------------------
INSERT INTO `industrial_land_supply_config` VALUES (1, 1, '', '2020-04-02 14:58:41', NULL, NULL, NULL, 0, '咨询反馈时间（天）', '1', '3');
INSERT INTO `industrial_land_supply_config` VALUES (2, 1, '', '2020-04-02 14:58:41', NULL, NULL, NULL, 0, '汇总审批时间（天）', '2', '5');
INSERT INTO `industrial_land_supply_config` VALUES (3, 1, '', '2020-04-02 14:58:41', NULL, NULL, NULL, 0, '分发反馈时间（天）', '3', '2');
INSERT INTO `industrial_land_supply_config` VALUES (4, 1, '', '2020-04-02 14:58:41', NULL, NULL, NULL, 0, '会审审批时间（天）', '4', '3');

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 (370, 363, '产业供地配置', 0, '\"\"', 'G_LAND_SUPPLY_CONFIG', 0, NULL, -1, '系统', '2020-03-05', NULL, NULL, NULL, 0, 0);


ALTER TABLE c_stock_land_apply ADD contract_id int(20)  COLLATE utf8_bin COMMENT '合同id'