xiaoan/xiaoan.sql

/*
SQLyog Ultimate v11.5 (64 bit)
MySQL - 5.5.23 : Database - xiaoan
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

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

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`xiaoan` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;

USE `xiaoan`;

/*Table structure for table `tb_camera` */

DROP TABLE IF EXISTS `tb_camera`;

CREATE TABLE `tb_camera` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `child_name` varchar(255) DEFAULT NULL COMMENT '相机的Mac地址',
  `activated_time` datetime DEFAULT NULL COMMENT '激活时间',
  `child_password` varchar(20) DEFAULT '4dkankan@4dage' COMMENT '相机密码',
  `sn_code` varchar(255) DEFAULT NULL COMMENT 'sn码',
  `wifi_name` varchar(255) DEFAULT NULL COMMENT 'wifi名称',
  `wifi_password` varchar(255) DEFAULT NULL COMMENT 'wifi密码',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `rec_status` varchar(2) DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  PRIMARY KEY (`id`),
  KEY `child_name` (`child_name`)
) ENGINE=InnoDB AUTO_INCREMENT=704 DEFAULT CHARSET=utf8 COMMENT='相机主表';

/*Data for the table `tb_camera` */

insert  into `tb_camera`(`id`,`child_name`,`activated_time`,`child_password`,`sn_code`,`wifi_name`,`wifi_password`,`create_time`,`update_time`,`rec_status`) values (699,'4DKKPRO_74EE2AB96D92','2020-02-18 15:15:32','4dkankan@4dage','4DKKP01B000111','4DKKPRO_74EE2AB96D92','12345678','2020-02-18 15:15:32','2020-02-18 15:15:32','A'),(700,'4DKKPRO_74EE2AB96A7E','2020-02-20 16:02:44','4dkankan@4dage','4DKKP01B000124','4DKKPRO_74EE2AB96A7E','12345678','2020-02-20 16:02:44','2020-02-20 16:02:44','A'),(701,'4DKKPRO_74EE2AB9DF09','2020-02-21 10:23:23','4dkankan@4dage','4DKKP01B000125','4DKKPRO_74EE2AB9DF09','12345678','2020-02-21 10:23:23','2020-02-21 10:23:23','A'),(702,'4DKKPRO_74EE2AB9DEF9','2020-02-21 15:04:56','4dkankan@4dage','4DKKP01B000126','4DKKPRO_74EE2AB9DEF9','12345678','2020-02-21 15:04:56','2020-02-21 15:04:56','A'),(703,'4DKKPRO_74EE2AB9F8EE','2020-02-28 10:31:14','4dkankan@4dage','4DKKP01B000127','4DKKPRO_74EE2AB9F8EE','12345678','2020-02-28 10:31:14','2020-02-28 10:31:14','A');

/*Table structure for table `tb_camera_detail` */

DROP TABLE IF EXISTS `tb_camera_detail`;

CREATE TABLE `tb_camera_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `balance` varchar(255) DEFAULT '0' COMMENT '余额',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户表t_user的id',
  `own` tinyint(3) DEFAULT '0' COMMENT '0表示客户，1表示员工，2表示赠送，3表示其他',
  `order_sn` varchar(255) DEFAULT NULL COMMENT '订单号',
  `country` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0表示本国，1表示国外',
  `agency` varchar(255) NOT NULL DEFAULT '4dage' COMMENT '经销商',
  `type` tinyint(3) NOT NULL DEFAULT '1' COMMENT '相机类型，0表示双目，1表示专业八目，2表示商业八目，3表示企业八目',
  `total_space` bigint(20) unsigned DEFAULT '0' COMMENT '总容量',
  `used_space` bigint(20) unsigned DEFAULT '0' COMMENT '已使用容量',
  `camera_id` bigint(20) DEFAULT NULL COMMENT '相机主表t_camera的id',
  `goods_id` bigint(20) DEFAULT NULL COMMENT '商品表t_goods的id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `rec_status` varchar(2) DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  PRIMARY KEY (`id`),
  KEY `camera_id` (`camera_id`),
  CONSTRAINT `tb_camera_detail_ibfk_1` FOREIGN KEY (`camera_id`) REFERENCES `tb_camera` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=558 DEFAULT CHARSET=utf8 COMMENT='相机子表';

/*Data for the table `tb_camera_detail` */

insert  into `tb_camera_detail`(`id`,`balance`,`user_id`,`own`,`order_sn`,`country`,`agency`,`type`,`total_space`,`used_space`,`camera_id`,`goods_id`,`create_time`,`update_time`,`rec_status`) values (553,'0',NULL,0,'O15820101321150015',0,'4dage',1,10737418240,41969567,699,4,'2020-02-18 15:15:32','2020-02-18 15:15:32','A'),(554,'1',NULL,0,'O15821857644620017',0,'4dage',1,10737418240,283168225,700,4,'2020-02-20 16:02:44','2020-02-20 16:02:44','A'),(555,'0',367,0,'O15822518037200011',0,'4dage',1,10737418240,171450121,701,4,'2020-02-21 10:23:23','2020-02-21 10:23:23','A'),(556,'0',NULL,0,'O15822686969700015',0,'4dage',1,10737418240,0,702,4,'2020-02-21 15:04:56','2020-02-21 15:04:56','A'),(557,'0',NULL,1,'O15828570740720011',0,'4dage',1,10737418240,26465069,703,4,'2020-02-28 10:31:14','2020-02-28 10:31:14','A');

/*Table structure for table `tb_data_dictionary` */

DROP TABLE IF EXISTS `tb_data_dictionary`;

CREATE TABLE `tb_data_dictionary` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `code` varchar(24) DEFAULT NULL COMMENT '数据字典code',
  `data_key` varchar(255) DEFAULT NULL COMMENT '数据字典key',
  `data_value` varchar(255) DEFAULT NULL COMMENT '数据字典value',
  `description` varchar(255) DEFAULT NULL COMMENT '描述',
  `param1` varchar(255) DEFAULT NULL COMMENT '备用，参数1',
  `param2` varchar(255) DEFAULT NULL COMMENT '备用，参数2',
  `param3` varchar(255) DEFAULT NULL COMMENT '备用，参数3',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='数据字典表';

/*Data for the table `tb_data_dictionary` */

/*Table structure for table `tb_department` */

DROP TABLE IF EXISTS `tb_department`;

CREATE TABLE `tb_department` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `rec_status` tinyint(4) DEFAULT NULL COMMENT '状态，0：激活，1：禁用',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `num` varchar(50) NOT NULL COMMENT '部门代号',
  `name` varchar(50) NOT NULL COMMENT '部门名称',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

/*Data for the table `tb_department` */

insert  into `tb_department`(`id`,`create_time`,`rec_status`,`update_time`,`num`,`name`,`create_by`) values (1,'2020-02-27 15:57:10',0,'2020-02-27 15:57:10','001','测试部门',NULL);

/*Table structure for table `tb_resource` */

DROP TABLE IF EXISTS `tb_resource`;

CREATE TABLE `tb_resource` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `description` varchar(255) DEFAULT NULL COMMENT '资源描述',
  `icon` varchar(10) DEFAULT NULL COMMENT '图标',
  `name` varchar(50) DEFAULT NULL COMMENT '资源名称',
  `url` varchar(255) DEFAULT NULL COMMENT '资源地址',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父资源id',
  `resource_type` enum('menu','button') DEFAULT NULL COMMENT '资源类型',
  `resource_key` varchar(255) DEFAULT NULL COMMENT '资源key',
  `rec_status` tinyint(2) DEFAULT NULL COMMENT '记录的状态，0: 生效，1: 禁用',
  `sort` tinyint(4) DEFAULT NULL COMMENT '排序',
  `create_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKf5ra2gn0xedeida2op8097sr5` (`parent_id`) USING BTREE,
  CONSTRAINT `FKf5ra2gn0xedeida2op8097sr5` FOREIGN KEY (`parent_id`) REFERENCES `tb_resource` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='资源表';

/*Data for the table `tb_resource` */

insert  into `tb_resource`(`id`,`create_time`,`update_time`,`description`,`icon`,`name`,`url`,`parent_id`,`resource_type`,`resource_key`,`rec_status`,`sort`,`create_by`) values (1,'2018-05-10 17:18:36','2018-05-10 17:22:42',NULL,'&#xe716','系统管理','javascript:void(0);',NULL,'menu','system',0,1,NULL),(2,'2018-05-11 10:05:41','2018-12-04 11:22:02',NULL,'&#xe66f','用户管理','/admin/user/list',1,'menu','admin:user:list',0,2,NULL),(3,'2018-05-14 09:38:43','2018-05-14 09:38:46',NULL,'&#xe66f','用户添加','/admin/user/add',2,'button','admin:user:add',0,3,NULL),(4,'2018-05-14 10:46:32','2018-05-14 10:46:36',NULL,'&#xe66f','用户编辑','/admin/user/edit',2,'button','admin:user:edit',0,4,NULL),(5,'2018-05-14 12:03:20','2018-05-14 12:03:30',NULL,'&#xe66f','用户重置密码','/admin/user/resetPass',2,'button','admin:user:resetPass',0,5,NULL),(6,'2018-05-14 14:08:16','2018-05-14 14:08:20',NULL,'&#xe66f','用户删除','/admin/user/remove',2,'button','admin:user:remove',0,6,NULL),(7,'2018-05-14 14:09:07','2018-05-14 14:09:10',NULL,'&#xe770','角色管理','/admin/role/list',1,'menu','admin:role:list',0,7,NULL),(8,'2018-05-14 15:06:59','2018-05-14 15:07:01',NULL,'&#xe770','角色添加','/admin/role/add',7,'button','admin:role:add',0,8,NULL),(9,'2018-05-14 15:06:59','2018-05-14 15:07:01',NULL,'&#xe770','角色编辑','/admin/role/edit',7,'button','admin:role:edit',0,9,NULL),(10,'2018-05-14 15:08:06','2018-05-14 15:08:08',NULL,'&#xe770','角色删除','/admin/role/remove',7,'button','admin:role:remove',0,10,NULL),(11,'2018-05-14 15:08:06','2018-05-14 15:08:08',NULL,'&#xe671','资源管理','/admin/resource/list',1,'menu','admin:resource:list',0,11,NULL),(12,'2018-05-15 09:51:49','2018-05-15 09:51:51',NULL,'&#xe671','资源添加','/admin/resource/add',11,'button','admin:resource:add',0,12,NULL),(13,'2018-05-15 09:51:49','2018-05-15 09:51:51',NULL,'&#xe671','资源编辑','/admin/resource/edit',11,'button','admin:resource:edit',0,13,NULL),(14,'2018-05-15 09:51:49','2018-12-04 11:20:29',NULL,'&#xe671','资源删除','/admin/resource/remove',11,'button','admin:resource:remove',0,14,NULL),(15,'2018-07-27 16:30:51','2018-07-27 16:30:51',NULL,'&#xe66e','数据字典管理','/admin/dataDictionary/list',1,'menu','admin:dataDictionary:list',0,40,NULL),(16,'2018-07-27 16:31:57','2018-07-27 16:31:57',NULL,'&#xe66e','数据字典添加','/admin/dataDictionary/add',15,'button','admin:dataDictionary:add',0,41,NULL),(17,'2018-07-27 16:35:59','2018-07-27 16:35:59',NULL,'&#xe66e','数据字典编辑','/admin/dataDictionary/edit',15,'button','admin:dataDictionary:edit',0,42,NULL),(18,'2018-07-27 16:36:56','2018-07-27 16:36:56',NULL,'&#xe66e','数据字典删除','/admin/dataDictionary/remove',15,'button','admin:dataDictionary:remove',0,43,NULL),(19,'2019-03-29 11:36:57','2019-03-29 11:36:57',NULL,'&#xe66f','设备管理','/admin/device/list',1,'menu','admin:device:list',0,100,NULL),(20,'2019-03-29 11:38:00','2019-03-29 11:38:00',NULL,'&#xe66e','设备添加','/admin/device/add',19,'button','admin:device:add',0,3,NULL),(21,'2019-03-29 11:40:20','2019-03-29 11:40:20',NULL,'&#xe66e','设备添加','/admin/device/edit',19,'button','admin:device:edit',0,43,NULL),(22,'2019-03-29 11:41:08','2019-03-29 11:41:08',NULL,'&#xe66e','设备删除','/admin/device/remove',19,'button','admin:device:remove',0,47,NULL),(23,'2019-04-01 15:56:00','2019-04-01 15:56:00',NULL,'&#xe66f','设备告警管理','/admin/deviceEvent/list',1,'menu','admin:deviceEvent:list',0,105,NULL);

/*Table structure for table `tb_role` */

DROP TABLE IF EXISTS `tb_role`;

CREATE TABLE `tb_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `role_desc` varchar(255) DEFAULT NULL COMMENT '角色描述',
  `role_name` varchar(50) DEFAULT NULL COMMENT '角色名',
  `role_key` varchar(255) DEFAULT NULL COMMENT '角色key',
  `rec_status` tinyint(2) DEFAULT NULL COMMENT '记录的状态，0: 生效，1: 禁用',
  `create_by` varchar(255) DEFAULT NULL,
  `sort` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='角色表';

/*Data for the table `tb_role` */

insert  into `tb_role`(`id`,`create_time`,`update_time`,`role_desc`,`role_name`,`role_key`,`rec_status`,`create_by`,`sort`) values (1,'2018-05-11 10:02:27','2019-04-01 16:07:09','超级管理员','超级管理员','admin',0,NULL,'1'),(2,'2019-11-12 09:10:25','2019-12-04 15:40:29','指定模块增删改','普通管理员','normal',0,NULL,'2');

/*Table structure for table `tb_role_resource` */

DROP TABLE IF EXISTS `tb_role_resource`;

CREATE TABLE `tb_role_resource` (
  `role_id` bigint(20) NOT NULL COMMENT '角色表id',
  `resource_id` bigint(20) NOT NULL COMMENT '资源表id',
  PRIMARY KEY (`role_id`,`resource_id`) USING BTREE,
  KEY `FK868kc8iic48ilv5npa80ut6qo` (`resource_id`) USING BTREE,
  CONSTRAINT `tb_role_resource_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `tb_role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `tb_role_resource_ibfk_2` FOREIGN KEY (`resource_id`) REFERENCES `tb_resource` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='角色资源关系表';

/*Data for the table `tb_role_resource` */

insert  into `tb_role_resource`(`role_id`,`resource_id`) values (1,1),(2,1),(1,2),(1,3),(1,4),(1,5),(1,6),(1,7),(1,8),(1,9),(1,10),(1,11),(1,12),(1,13),(1,14),(1,15),(1,16),(1,17),(1,18),(1,19),(2,19),(1,20),(2,20),(1,21),(2,21),(1,22),(2,22),(1,23),(2,23);

/*Table structure for table `tb_scene_pro` */

DROP TABLE IF EXISTS `tb_scene_pro`;

CREATE TABLE `tb_scene_pro` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `scene_name` varchar(255) DEFAULT NULL COMMENT '场景名称',
  `scene_dec` longtext COMMENT '场景描述',
  `web_site` varchar(255) DEFAULT NULL COMMENT '场景的链接地址',
  `thumb` varchar(255) DEFAULT 'https://4dkk.4dage.com/loading/thumb.jpg' COMMENT '场景缩略图',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `status` tinyint(3) DEFAULT '0' COMMENT '0表示未建好，1表示建好，-1表示出错，-2表示不要在官网上显示',
  `data_source` varchar(255) DEFAULT NULL COMMENT '原始的大场景数据（七牛）',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户表t_user的id',
  `pay_status` tinyint(3) DEFAULT '0' COMMENT '0表示未付款，1表示付款了，-1表示欠费，-2表示容量不足',
  `camera_id` bigint(20) DEFAULT NULL COMMENT '相机主表t_camera的id',
  `phone_id` varchar(255) DEFAULT NULL COMMENT '手机id',
  `scene_logo` varchar(255) DEFAULT NULL COMMENT '场景logo',
  `num` varchar(255) DEFAULT NULL COMMENT '大场景序号',
  `scene_type` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0表示其他，1表示文博，2表示地产，3表示电商，4表示餐饮，5表示家居',
  `recommend` tinyint(3) DEFAULT '0' COMMENT '1表示推荐，0表示正常',
  `view_count` int(3) DEFAULT '0' COMMENT '浏览次数',
  `shoot_count` int(11) DEFAULT NULL COMMENT '拍摄数量',
  `files_name` text COMMENT '所有资源文件名',
  `videos` text COMMENT '点位视频',
  `gps` varchar(255) DEFAULT NULL COMMENT '要gps定位',
  `scene_scheme` tinyint(3) DEFAULT '1' COMMENT '方案：1是双目，2是转台，3是六目,4是八目',
  `rec_status` varchar(2) DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `algorithm` varchar(10) DEFAULT 'slam' COMMENT '算法类型',
  `oss` varchar(25) DEFAULT 'aliyun' COMMENT 'oss服务商',
  `space` bigint(20) unsigned DEFAULT '0' COMMENT '使用容量',
  `create_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=729 DEFAULT CHARSET=utf8 COMMENT='pro场景表';

/*Data for the table `tb_scene_pro` */

insert  into `tb_scene_pro`(`id`,`scene_name`,`scene_dec`,`web_site`,`thumb`,`create_time`,`status`,`data_source`,`user_id`,`pay_status`,`camera_id`,`phone_id`,`scene_logo`,`num`,`scene_type`,`recommend`,`view_count`,`shoot_count`,`files_name`,`videos`,`gps`,`scene_scheme`,`rec_status`,`update_time`,`algorithm`,`oss`,`space`,`create_by`) values (719,'项目0227.15.05','<p>四维看看 让空间讲故事</p>','https://test.4dkankan.com/showProMobile.html?m=t-XKPc3XU','https://4dkk.4dage.com/images/imagest-XKPc3XU/final.png','2020-02-28 16:24:33',-1,'/home/ubuntu/data/74ee2ab96a76/682986383559622656/3c100e20ead15d3f793c68e271374640_20200227150548548',13,0,699,'3c100e20ead15d3f793c68e271374640',NULL,'t-XKPc3XU',0,0,0,1,'',NULL,NULL,10,'A','2020-02-28 16:24:33','sfm','aliyun',0,NULL),(720,'项目0227.14.08','<p>四维看看 让空间讲故事</p>','https://test.4dkankan.com/showProMobile.html?m=t-7BJVnKF','https://4dkk.4dage.com/images/imagest-7BJVnKF/final.png','2020-02-28 16:28:29',-1,'/home/ubuntu/data/74ee2ab96a76/682987319384342528/3c100e20ead15d3f793c68e271374640_20200227140845845',14,0,699,'3c100e20ead15d3f793c68e271374640',NULL,'t-7BJVnKF',0,0,0,1,'',NULL,NULL,10,'A','2020-02-28 16:28:29','sfm','aliyun',0,NULL),(721,'ces1','<p>四维看看 让空间讲故事</p>','https://test.4dkankan.com/showProMobile.html?m=t-eR2LHCa','https://4dkk.4dage.com/images/imagest-eR2LHCa/final.png','2020-02-28 16:42:55',-1,'/home/ubuntu/data/74ee2ab7f6b1/682991076331487232/3ef09a0b1021368d07d7a8856374fcfa_202002281639423942',13,0,702,'3ef09a0b1021368d07d7a8856374fcfa',NULL,'t-eR2LHCa',0,0,0,2,'',NULL,'{\"latitude\":22.36707,\"longitude\":113.595917,\"altitude\":0.0,\"horizontalAccuracy\":40.0,\"verticalAccuracy\":40.0,\"timestamp\":1582879034.032}',10,'A','2020-02-28 16:42:55','sfm','aliyun',0,NULL),(722,'ces2','<p>四维看看 让空间讲故事</p>','https://test.4dkankan.com/showProMobile.html?m=t-3SnXk16','https://4dkk.4dage.com/images/imagest-3SnXk16/final.png','2020-02-28 16:43:23',-1,'/home/ubuntu/data/74ee2ab7f6b1/682991217968939008/3ef09a0b1021368d07d7a8856374fcfa_202002281641254125',13,0,701,'3ef09a0b1021368d07d7a8856374fcfa',NULL,'t-3SnXk16',0,0,0,1,'',NULL,'{\"latitude\":22.36707,\"longitude\":113.595917,\"altitude\":0.0,\"horizontalAccuracy\":40.0,\"verticalAccuracy\":40.0,\"timestamp\":1582879227.073}',10,'A','2020-02-28 16:43:23','sfm','aliyun',0,NULL),(723,'项目0228.16.45','<p>四维看看 让空间讲故事</p>','https://test.4dkankan.com/showProMobile.html?m=t-pcqv8Ue','https://4dkk.4dage.com/images/imagest-pcqv8Ue/final.png','2020-02-28 16:49:57',-2,'/home/ubuntu/data/74ee2ab96a76/682992093760585728/3c100e20ead15d3f793c68e271374640_202002281645384538',13,1,701,'3c100e20ead15d3f793c68e271374640',NULL,'t-pcqv8Ue',0,0,0,1,'','{\"data\":[{\"id\":\"0\",\"tsSize\":386904}],\"upPath\":\"https://4dkk.4dage.com/home/74ee2ab96a76/682992093760585728/3c100e20ead15d3f793c68e271374640_202002281645384538/Up2.xml\",\"version\":1}','{\"latitude\":22.3671551,\"longitude\":113.595512,\"altitude\":0.0,\"horizontalAccuracy\":30.0,\"verticalAccuracy\":30.0,\"timestamp\":1582879539.084}',10,'A','2020-02-28 16:46:51','sfm','aliyun',17254749,NULL),(724,'电量3容量大1','<p>四维看看 让空间讲故事</p>','https://test.4dkankan.com/showProMobile.html?m=t-ZVPqKNw','https://4dkk.4dage.com/images/imagest-ZVPqKNw/final.png','2020-02-28 16:48:31',-1,'/home/ubuntu/data/74ee2ab96a7e/682992346928775168/ca7559906e8706b98658dc5c0b349591_202002281615261526',14,0,700,'ca7559906e8706b98658dc5c0b349591',NULL,'t-ZVPqKNw',0,0,0,1,'',NULL,'{\"latitude\":22.3671913,\"longitude\":113.595863,\"altitude\":0.0,\"horizontalAccuracy\":18.0,\"verticalAccuracy\":18.0,\"timestamp\":1582878230.0}',10,'A','2020-02-28 16:48:31','sfm','aliyun',0,NULL),(725,'电量剩百分3 录制视频大于2g','<p>四维看看 让空间讲故事</p>','https://test.4dkankan.com/showProMobile.html?m=t-qgztLlo','https://4dkk.4dage.com/images/imagest-qgztLlo/final.png','2020-02-28 16:48:52',-1,'/home/ubuntu/data/74ee2ab96a7e/682992560137830400/ca7559906e8706b98658dc5c0b349591_202002281558535853',13,0,700,'ca7559906e8706b98658dc5c0b349591',NULL,'t-qgztLlo',0,0,0,1,'',NULL,'{\"latitude\":22.3671761,\"longitude\":113.59584,\"altitude\":0.0,\"horizontalAccuracy\":12.0,\"verticalAccuracy\":12.0,\"timestamp\":1582875139.0}',10,'A','2020-02-28 16:48:52','sfm','aliyun',0,NULL),(726,'电量剩下百分2，会自动结束录制','<p>四维看看 让空间讲故事</p>','https://test.4dkankan.com/showProMobile.html?m=t-EGwgQDo','https://4dkk.4dage.com/images/imagest-EGwgQDo/final.png','2020-02-28 16:49:58',-1,'/home/ubuntu/data/74ee2ab96a7e/682992643369598976/ca7559906e8706b98658dc5c0b349591_20200228153209329',13,0,700,'ca7559906e8706b98658dc5c0b349591',NULL,'t-EGwgQDo',0,0,0,1,'',NULL,'{\"latitude\":22.3672161,\"longitude\":113.595947,\"altitude\":0.0,\"horizontalAccuracy\":15.0,\"verticalAccuracy\":15.0,\"timestamp\":1582875108.448}',10,'A','2020-02-28 16:49:58','sfm','aliyun',0,NULL),(727,'项目0228.17.01','<p>四维看看 让空间讲故事</p>','https://test.4dkankan.com/showProMobile.html?m=t-Jaicz5I','https://4dkk.4dage.com/images/imagest-Jaicz5I/final.png','2020-02-28 17:04:31',-2,'/home/ubuntu/data/74ee2ab96a76/682995939706667008/3c100e20ead15d3f793c68e271374640_20200228170113113',14,1,703,'3c100e20ead15d3f793c68e271374640',NULL,'t-Jaicz5I',0,0,0,1,'','{\"data\":[{\"id\":\"0\",\"tsSize\":551968}],\"upPath\":\"https://4dkk.4dage.com/home/74ee2ab96a76/682995939706667008/3c100e20ead15d3f793c68e271374640_20200228170113113/Up2.xml\",\"version\":1}','{\"latitude\":22.3670788,\"longitude\":113.595863,\"altitude\":0.0,\"horizontalAccuracy\":53.0,\"verticalAccuracy\":53.0,\"timestamp\":1582880473.661}',10,'A','2020-02-28 17:02:07','sfm','aliyun',17295110,NULL),(728,'项目0228.16.52','<p>四维看看 让空间讲故事</p>','https://test.4dkankan.com/showProMobile.html?m=t-l6gyHeg','https://4dkk.4dage.com/images/imagest-l6gyHeg/final.png','2020-02-28 17:09:10',-1,'/home/ubuntu/data/74ee2ab96a7e/682997683459194880/ca7559906e8706b98658dc5c0b349591_202002281652335233',14,0,700,'ca7559906e8706b98658dc5c0b349591',NULL,'t-l6gyHeg',0,0,0,1,'',NULL,'{\"latitude\":22.3672333,\"longitude\":113.595673,\"altitude\":0.0,\"horizontalAccuracy\":30.0,\"verticalAccuracy\":30.0,\"timestamp\":1582879567.23}',10,'A','2020-02-28 17:09:10','sfm','aliyun',0,NULL);

/*Table structure for table `tb_scene_pro_edit` */

DROP TABLE IF EXISTS `tb_scene_pro_edit`;

CREATE TABLE `tb_scene_pro_edit` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `pro_id` bigint(20) NOT NULL COMMENT 'pro场景id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `scene_key` varchar(255) DEFAULT NULL COMMENT '大场景的密钥',
  `version` int(11) DEFAULT '0' COMMENT '版本',
  `thumb_status` tinyint(3) DEFAULT '0' COMMENT '表示缩略图是否存在',
  `floor_logo` varchar(10) DEFAULT '0' COMMENT '0表示默认，1表示自己上传',
  `floor_logo_size` int(11) DEFAULT '50' COMMENT '标记大小',
  `hots_ids` varchar(500) DEFAULT NULL COMMENT '要上传的热点的id集合，用逗号隔开',
  `entry` varchar(255) DEFAULT NULL COMMENT '表示初始点信息',
  `bg_music` varchar(255) DEFAULT '0' COMMENT '背景音乐名称',
  `rec_status` varchar(2) DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `screencap_voice_src` varchar(255) DEFAULT NULL COMMENT '普通录屏文件地址',
  `screencap_voice_sound` varchar(255) DEFAULT NULL COMMENT '录音文件地址',
  `screencap_voice_soundsync` varchar(255) DEFAULT NULL COMMENT '同步录音地址',
  `screencap_voice_type` varchar(255) DEFAULT NULL COMMENT '选择的类型，sound为screencapVoiceSound，file为screencapVoiceSrc，soundsync为screencap_voice_soundsync',
  `play_data` varchar(255) DEFAULT NULL COMMENT '录屏文件地址',
  `floor_edit_ver` int(5) DEFAULT '0' COMMENT '重新建模的版本',
  `floor_publish_ver` int(5) DEFAULT '0' COMMENT '正式发布重新建模的版本',
  `screencap_thumb` varchar(255) DEFAULT NULL COMMENT '录屏图片存放文件',
  `share_logo` varchar(255) DEFAULT NULL COMMENT '分享的logo和生成二维码的logo',
  `map_visi` int(2) DEFAULT '1' COMMENT '小地图浏览',
  `tour_visi` int(2) DEFAULT '1' COMMENT '自动导览',
  `vr_visi` int(2) DEFAULT '1' COMMENT 'vr模式',
  `ruler_visi` int(2) DEFAULT '1' COMMENT '展示页面是否显示标尺',
  `cad_img_visi` int(2) DEFAULT '1' COMMENT '展示页面cad图在平面图是否显示',
  `floor_plan_png` varchar(255) DEFAULT NULL COMMENT 'cad平面图',
  `cad_info` text COMMENT 'cad平面图参数',
  `pano_visi` int(2) DEFAULT '1',
  `m2d_visi` int(2) DEFAULT '1',
  `m3d_visi` int(2) DEFAULT '1',
  `measure_visi` int(2) DEFAULT '1',
  `create_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=729 DEFAULT CHARSET=utf8 COMMENT='pro场景编辑数据表';

/*Data for the table `tb_scene_pro_edit` */

insert  into `tb_scene_pro_edit`(`id`,`pro_id`,`create_time`,`scene_key`,`version`,`thumb_status`,`floor_logo`,`floor_logo_size`,`hots_ids`,`entry`,`bg_music`,`rec_status`,`update_time`,`screencap_voice_src`,`screencap_voice_sound`,`screencap_voice_soundsync`,`screencap_voice_type`,`play_data`,`floor_edit_ver`,`floor_publish_ver`,`screencap_thumb`,`share_logo`,`map_visi`,`tour_visi`,`vr_visi`,`ruler_visi`,`cad_img_visi`,`floor_plan_png`,`cad_info`,`pano_visi`,`m2d_visi`,`m3d_visi`,`measure_visi`,`create_by`) values (719,719,'2020-02-28 16:24:33',NULL,0,0,'0',100,NULL,NULL,'0','A','2020-02-28 16:24:33',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,1,1,1,1,1,NULL,NULL,1,1,1,0,NULL),(720,720,'2020-02-28 16:28:29',NULL,0,0,'0',100,NULL,NULL,'0','A','2020-02-28 16:28:29',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,1,1,1,1,1,NULL,NULL,1,1,1,0,NULL),(721,721,'2020-02-28 16:42:55',NULL,0,0,'0',100,NULL,NULL,'0','A','2020-02-28 16:42:55',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,1,1,1,1,1,NULL,NULL,1,1,1,0,NULL),(722,722,'2020-02-28 16:43:23',NULL,0,0,'0',100,NULL,NULL,'0','A','2020-02-28 16:43:23',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,1,1,1,1,1,NULL,NULL,1,1,1,0,NULL),(723,723,'2020-02-28 16:46:51',NULL,0,0,'0',100,NULL,NULL,'0','A','2020-02-28 16:46:51',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,1,1,1,1,1,NULL,NULL,1,1,1,0,NULL),(724,724,'2020-02-28 16:48:31',NULL,0,0,'0',100,NULL,NULL,'0','A','2020-02-28 16:48:31',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,1,1,1,1,1,NULL,NULL,1,1,1,0,NULL),(725,725,'2020-02-28 16:48:52',NULL,0,0,'0',100,NULL,NULL,'0','A','2020-02-28 16:48:52',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,1,1,1,1,1,NULL,NULL,1,1,1,0,NULL),(726,726,'2020-02-28 16:49:58',NULL,0,0,'0',100,NULL,NULL,'0','A','2020-02-28 16:49:58',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,1,1,1,1,1,NULL,NULL,1,1,1,0,NULL),(727,727,'2020-02-28 17:02:07',NULL,0,0,'0',100,NULL,NULL,'0','A','2020-02-28 17:02:07',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,1,1,1,1,1,NULL,NULL,1,1,1,0,NULL),(728,728,'2020-02-28 17:09:10',NULL,0,0,'0',100,NULL,NULL,'0','A','2020-02-28 17:09:10',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,1,1,1,1,1,NULL,NULL,1,1,1,0,NULL);

/*Table structure for table `tb_user` */

DROP TABLE IF EXISTS `tb_user`;

CREATE TABLE `tb_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `rec_status` tinyint(4) DEFAULT NULL COMMENT '状态，0：激活，1：禁用',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `password` varchar(100) DEFAULT NULL COMMENT '登录密码',
  `real_name` varchar(50) DEFAULT NULL COMMENT '用户名',
  `user_name` varchar(50) DEFAULT NULL COMMENT '手机号，用户号',
  `department_id` bigint(20) DEFAULT NULL COMMENT '部门id',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `user_num` varchar(255) DEFAULT NULL COMMENT '用户代号',
  `sex` tinyint(4) DEFAULT NULL COMMENT '性别， 0：男， 1：女',
  `create_by` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户表';

/*Data for the table `tb_user` */

insert  into `tb_user`(`id`,`create_time`,`rec_status`,`update_time`,`password`,`real_name`,`user_name`,`department_id`,`email`,`user_num`,`sex`,`create_by`,`status`) values (9,'2018-05-10 15:12:42',0,'2018-12-04 10:58:51','60d04be2bbd3057f4f84af743b9a7faa','超级管理员','15999999999',1,NULL,'001',1,NULL,0),(13,'2020-02-20 12:21:23',0,'2020-02-20 12:21:23','2c01ba92b4dab363','普通用户','15888888888',1,'string','002',0,'owen',0),(14,'2020-02-20 17:38:38',0,'2020-02-20 17:38:38','52c356a463b5d4fc','测试用户','15777777777',1,'string','003',0,NULL,0);

/*Table structure for table `tb_user_role` */

DROP TABLE IF EXISTS `tb_user_role`;

CREATE TABLE `tb_user_role` (
  `user_id` bigint(20) NOT NULL COMMENT '用户表id',
  `role_id` bigint(20) NOT NULL COMMENT '角色表id',
  PRIMARY KEY (`user_id`,`role_id`) USING BTREE,
  KEY `role_id` (`role_id`) USING BTREE,
  CONSTRAINT `tb_user_role_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `tb_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `tb_user_role_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `tb_role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户角色关系表';

/*Data for the table `tb_user_role` */

insert  into `tb_user_role`(`user_id`,`role_id`) values (9,1),(13,2);

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