snd-escloud/sql/20200413.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 47
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : 47.105.241.108:33060
 Source Schema         : service_platform

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

 Date: 13/04/2020 15:30:18
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for c_stock_land_out_park
-- ----------------------------
DROP TABLE IF EXISTS `c_stock_land_out_park`;
CREATE TABLE `c_stock_land_out_park`  (
  `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,
  `out_park_location` varchar(500) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '园区外地址',
  `out_park_contract_area` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '园区外租赁面积',
  `out_park_contract_start` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '园区外租赁合同开始时间',
  `out_park_contract_end` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '园区外租赁合同结束时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2519 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;



ALTER TABLE c_stock_land_apply ADD is_in_park varchar(2)  COLLATE utf8_bin COMMENT '是否在园区内';