/*
SQLyog Ultimate v12.5.0 (64 bit)
MySQL - 8.0.11 : Database - seis
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
/*Table structure for table `se_layer` */

CREATE TABLE `se_layer` (
  `data_id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
  `rect_minx` double NOT NULL DEFAULT '0' COMMENT '外包矩形',
  `rect_miny` double NOT NULL DEFAULT '0' COMMENT '外包矩形',
  `rect_maxx` double NOT NULL DEFAULT '0' COMMENT '外包矩形',
  `rect_maxy` double NOT NULL DEFAULT '0' COMMENT '外包矩形',
  `rect` polygon NOT NULL /*!80003 SRID 4326 */ COMMENT '创建索引用',
  `start_scale` double NOT NULL DEFAULT '1000000000' COMMENT '起始比例尺',
  `end_scale` double NOT NULL DEFAULT '1' COMMENT '结束比例尺',
  `projection` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'EPSG:4326' COMMENT '投影系',
  `trans_color` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '-1,-1,-1' COMMENT '透明色',
  `type` int(11) NOT NULL DEFAULT '0' COMMENT '类型，请参考文档',
  `config` varchar(15000) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '配置',
  `image_start_time` timestamp NULL DEFAULT NULL COMMENT '影像拍摄开始时间',
  `image_end_time` timestamp NULL DEFAULT NULL COMMENT '影像拍摄结束时间',
  `data_status` int(11) NOT NULL DEFAULT '1' COMMENT '1:Enabled, 0:Disabled,-1:Removed',
  `data_version` int(11) NOT NULL DEFAULT '0',
  `data_update_user` int(11) NOT NULL DEFAULT '0',
  `data_update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`data_id`),
  KEY `idx_start_level` (`start_scale`),
  KEY `idx_end_level` (`end_scale`),
  KEY `idx_image_start_time` (`image_start_time`),
  SPATIAL KEY `sp_rect` (`rect`),
  KEY `idx_type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='影像图层';

/*Data for the table `se_layer` */

insert  into `se_layer`(`data_id`,`name`,`rect_minx`,`rect_miny`,`rect_maxx`,`rect_maxy`,`rect`,`start_scale`,`end_scale`,`projection`,`trans_color`,`type`,`config`,`image_start_time`,`image_end_time`,`data_status`,`data_version`,`data_update_user`,`data_update_time`) values (1001,'测试图层',116.35507710331,39.856861809485,116.38617778613,39.899993954469,'�\0\0
\0\0\0
\0\0\0\0\0\0�_�]@����f�C@�_�]@�Rk�y�C@P�Q��]@�Rk�y�C@P�Q��]@����f�C@�_�]@����f�C@',1000000000,1,'EPSG:4326','-1,-1,-1',0,NULL,NULL,NULL,1,3,1,'2018-05-06 21:43:17');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;