laser_pc/AppFile/laser/mysql/update/update.sql

UPDATE `laser`.`sys_job` SET `cron_expression` = '0/1 * * * * ?'  WHERE `job_id` = 4 AND `job_name` = '计算场景' AND `job_group` = 'DEFAULT';


-- ----------------------------
-- Table structure for t_fusion_model
-- ----------------------------
Create Table If Not Exists `t_fusion_model`  (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`fusion_id` int NULL DEFAULT NULL,
`model_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`model_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '三维模型标题',
`transform` json NULL COMMENT '位置,比例等属性',
`opacity` float NULL DEFAULT 100 COMMENT '透明度',
`bottom` float NULL DEFAULT 0,
`hide` int NULL DEFAULT 0 COMMENT '是否隐藏0否，1是',
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '备注信息',
`deleted` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '逻辑未删除值0，逻辑已删除值1',
`delete_flag` datetime NULL DEFAULT NULL COMMENT '逻辑删除',
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_model
-- ----------------------------
Create Table If Not Exists `t_model`  (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`model_date_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '三维模型数据类型',
`model_size` bigint NULL DEFAULT NULL COMMENT '大小',
`model_obj_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`model_glb_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`create_status` int NULL DEFAULT 0 COMMENT '0初始化，创建中，1创建成功',
`type` int NULL DEFAULT 3 COMMENT '0看看，1看见，2深时，3用户上传三维模型',
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '备注信息',
`deleted` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '逻辑未删除值0，逻辑已删除值1',
`delete_flag` datetime NULL DEFAULT NULL COMMENT '逻辑删除',
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
`model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模型类型\'glb\'|\'pointcloud\',类型 点云还是模型,',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_scene_tag
-- ----------------------------
Create Table If Not Exists `t_scene_tag`  (
 `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
 `tag_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
 `tag_describe` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
 `leave_behind` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '遗留部位',
 `get_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '提取方法',
 `get_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '提取人',
 `place_num` int NULL DEFAULT NULL,
 `meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '标注图片集',
 `hot_icon_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '热点iconurl',
 `hot_icon_id` int NULL DEFAULT NULL COMMENT '热点iconid',
 `fusion_id` bigint NULL DEFAULT NULL COMMENT '融合id',
 `sort` int NULL DEFAULT 1,
 `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
 `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
 `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '备注信息',
 `deleted` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '逻辑未删除值0，逻辑已删除值1',
 `delete_flag` datetime NULL DEFAULT NULL COMMENT '逻辑删除',
 `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
 `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scene_tag_point
-- ----------------------------
Create Table If Not Exists `t_scene_tag_point`  (
   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
   `tag_point_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '位置名称',
   `tag_point` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '位置json',
   `tag_id` int NULL DEFAULT NULL COMMENT '标注id',
   `model_id` int NULL DEFAULT NULL,
   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
   `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '备注信息',
   `deleted` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '逻辑未删除值0，逻辑已删除值1',
   `delete_flag` datetime NULL DEFAULT NULL COMMENT '逻辑删除',
   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
   `sort` int NULL DEFAULT 1,
   PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scene_fusion
-- ----------------------------
Create Table If Not Exists `t_scene_fusion`  (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`scene_id` int NULL DEFAULT NULL,
`fusion_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '备注信息',
`deleted` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '逻辑未删除值0，逻辑已删除值1',
`delete_flag` datetime NULL DEFAULT NULL COMMENT '逻辑删除',
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_fusion_guide_path
-- ----------------------------
Create Table If Not Exists `t_fusion_guide_path`  (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`guide_id` int NULL DEFAULT NULL COMMENT '导览id',
`cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '封面图',
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
`url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '视频地址',
`target` json NULL COMMENT '位置json',
`position` json NULL COMMENT '位置',
`time`  double(10, 2) DEFAULT NULL COMMENT '持续时间 秒',
`speed` double(10, 2) NULL DEFAULT NULL COMMENT '速度 m/s',
`sort` int NULL DEFAULT 1 COMMENT '排序',
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '备注信息',
`deleted` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '逻辑未删除值0，逻辑已删除值1',
`delete_flag` datetime NULL DEFAULT NULL COMMENT '逻辑删除',
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_fusion_guide
-- ----------------------------
Create Table If Not Exists `t_fusion_guide`  (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`fusion_id` int NULL DEFAULT NULL COMMENT '融合场景id',
`cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '封面图',
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
`sort` int NULL DEFAULT 1 COMMENT '排序',
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '备注信息',
`deleted` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '0' COMMENT '逻辑未删除值0，逻辑已删除值1',
`delete_flag` datetime NULL DEFAULT NULL COMMENT '逻辑删除',
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;


Create Table If Not Exists `t_scene_upload`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '文件上传资源记录表',
  `num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传文件路径',
  `biz_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '业务类型',
  `upload_user` bigint NULL DEFAULT NULL COMMENT '上传用户id',
  `rec_status` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_scene_plus_ext
-- ----------------------------
Create Table If Not Exists `t_scene_plus_ext`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `plus_id` bigint NOT NULL COMMENT 't_scene_plus主键',
  `data_source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '场景数据目录',
  `web_site` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '场景链接',
  `thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '缩略图链接',
  `scene_scheme` tinyint NULL DEFAULT NULL COMMENT '方案：1-双目，2-转台，3-六目,4-八目,10-获取4k图，11-获取2k，12-获取1k',
  `space` bigint NULL DEFAULT NULL COMMENT '使用用量',
  `ecs` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'aliyun' COMMENT '云服务器类型',
  `shoot_count` int UNSIGNED NULL DEFAULT NULL COMMENT '点位数量',
  `view_count` int NULL DEFAULT NULL COMMENT '浏览次数',
  `gps` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'gps定位',
  `algorithm` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'slam' COMMENT '算法类型(slam、sfm)',
  `firmware_version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '固件版本',
  `build_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '算法类型（V2,V3）',
  `scene_resolution` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '分辨率（2k,4k）',
  `scene_from` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '场景来源，lite：双目lite相机，pro：八目相机，minion：双面转台相机，laser：激光相机，virtual：虚拟场景，sketch：图片建模场景',
  `scene_kind` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '切图方式（tiles：瓦片图，face：切片图，pan：全景图 ，local：本地切片，cube：立体图）',
  `videos` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '点位视频',
  `compute_time` bigint NULL DEFAULT 0 COMMENT '计算耗时',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'A' COMMENT '0-有效，1-删除, 2-禁用',
  `yun_file_bucket` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '4dkankan',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_plusId_dataSource`(`plus_id`, `data_source`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_scene_plus
-- ----------------------------
Create Table If Not Exists `t_scene_plus`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '场景码',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
  `camera_id` bigint NULL DEFAULT NULL COMMENT '相机id',
  `phone_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '手机id',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '场景名称',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '场景描述',
  `scene_status` tinyint NOT NULL DEFAULT 0 COMMENT '场景状态：0-未建好，1--已建好，-1-计算出错，-2--不在官网显示',
  `scene_source` int NULL DEFAULT NULL COMMENT '场景来源：相机拍摄10以内表示，1表示八目，2双目，3转台，4 激光  其他来源10以上，11：一键换装，12：123看房，13文通虚拟场景',
  `pay_status` tinyint NULL DEFAULT 0 COMMENT '支付状态：0表示未付款，1表示付款了，-1表示欠费，-2表示容量不足',
  `scene_type` int NULL DEFAULT NULL COMMENT '场景类型  0-其他，1-文博，2-地产，3-电商，4-餐饮，5-家居,99-一件换装虚拟房源',
  `recommend` tinyint NOT NULL DEFAULT 0 COMMENT '是否推荐：0-否，1-是',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'A' COMMENT '0-有效，1-删除, 2-禁用',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_num`(`num`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '场景主表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_scene_edit_info_ext
-- ----------------------------
Create Table If Not Exists `t_scene_edit_info_ext`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `scene_pro_id` bigint NULL DEFAULT NULL,
  `scene_plus_id` bigint NULL DEFAULT NULL,
  `edit_info_id` bigint NULL DEFAULT NULL,
  `floor_plan_angle` float NULL DEFAULT 0 COMMENT '户型角度',
  `floor_plan_compass` float NULL DEFAULT 0 COMMENT '指南针角度',
  `vr_num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '大场景序号(随心装场景码)  原pro_edit表中的字段',
  `tours` tinyint NULL DEFAULT 0 COMMENT '是否有保存导览（0-否，1-是）',
  `mosaics` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '马赛克数据',
  `mosaic` tinyint NOT NULL DEFAULT 0 COMMENT '是否有马赛克',
  `water_mark` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '水印文件名',
  `links` tinyint NOT NULL DEFAULT 0 COMMENT '是否有场景关联(0-否，1-是)',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'A' COMMENT '0-有效，1-删除, 2-禁用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_scene_edit_info
-- ----------------------------
Create Table If Not Exists `t_scene_edit_info`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scene_pro_id` bigint NULL DEFAULT NULL,
  `scene_plus_id` bigint NULL DEFAULT NULL,
  `floor_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '地面logo名称',
  `floor_logo_size` int NULL DEFAULT NULL COMMENT '地面logo大小',
  `floor_logo_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '地面logo文件名称',
  `music` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '背景音乐名称',
  `music_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '背景音乐文件名称',
  `scene_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '浏览密码',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '场景标题',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '场景描述',
  `floor_plan_user` tinyint NULL DEFAULT 0 COMMENT '用户是否上传户型图（0-否，1-是）',
  `tags` tinyint NULL DEFAULT 0 COMMENT '是否有热点数据（0-否，1-是）',
  `version` int NOT NULL DEFAULT 1 COMMENT '版本',
  `img_version` int NOT NULL DEFAULT 0 COMMENT '图片版本',
  `link_version` int NOT NULL DEFAULT 0 COMMENT '场景关联版本',
  `is_upload_obj` tinyint NULL DEFAULT 0 COMMENT '是否上传模型',
  `floor_edit_ver` int NULL DEFAULT 0 COMMENT '重新建模的版本',
  `floor_publish_ver` int NULL DEFAULT 0 COMMENT '正式发布重新建模的版本',
  `box_videos` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '空间视频数据',
  `box_photos` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '空间贴图数据',
  `build_video_status` tinyint NOT NULL DEFAULT 0 COMMENT '是否需要处理球幕视频',
  `entry` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '初始点信息',
  `loading_logo` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '加载logo名',
  `loading_logo_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '加载logo文件名',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'A' COMMENT '0-有效，1-删除, 2-禁用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_scene_edit_controls
-- ----------------------------
Create Table If Not Exists `t_scene_edit_controls`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
  `edit_info_id` bigint NOT NULL COMMENT 't_scene_edit_info表id',
  `show_map` tinyint NOT NULL DEFAULT 1 COMMENT '是否展示小地图（0-不展示，1-展示）',
  `show_lock` tinyint NOT NULL DEFAULT 0 COMMENT '是否需要密码（0-不需要，1-需要）',
  `show_title` tinyint NOT NULL DEFAULT 1 COMMENT '是否展示标题（0-不需要，1-需要）',
  `show_panorama` tinyint NOT NULL DEFAULT 1 COMMENT '是否展示漫游按钮（0-不需要，1-需要）',
  `show_dollhouse` tinyint NOT NULL DEFAULT 1 COMMENT '是否展示3D按钮（0-不需要，1-需要）',
  `show_floorplan` tinyint NOT NULL DEFAULT 1 COMMENT '是否展示2D按钮（0-不需要，1-需要）',
  `show_VR` tinyint NOT NULL DEFAULT 1 COMMENT '是否展示VR（0-不需要，1-需要）',
  `show_tour` tinyint NOT NULL DEFAULT 1 COMMENT '是否展示自动导览（0-不需要，1-需要）',
  `show_rule` tinyint NOT NULL DEFAULT 1 COMMENT '是否展示测量线（0-不需要，1-需要）',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'A' COMMENT '0-有效，1-删除, 2-禁用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for t_user_increment
-- ----------------------------
Create Table If Not Exists `t_user_increment`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `key_word` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权益包标识',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户表t_user的id',
  `camera_id` bigint NULL DEFAULT NULL COMMENT '相机主表t_camera的id',
  `increment_type_id` int NULL DEFAULT NULL COMMENT '会员权益类型Id',
  `increment_end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
  `is_expired` int NULL DEFAULT 0 COMMENT '是否过期（1过期，0未过期）',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `order_sn` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '扩容订单集合',
  `increment_start_time` datetime NULL DEFAULT NULL COMMENT '生效时间',
  `download_num` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户增值权益表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
Create Table If Not Exists `t_user`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `head` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像对应的链接地址',
  `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户密码',
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户邮箱',
  `register_time` datetime NULL DEFAULT NULL COMMENT '注册时间',
  `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `nick_name` varchar(55) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '昵称',
  `status` tinyint NULL DEFAULT 1 COMMENT '0表示禁言（bbs）',
  `is_notice` tinyint NULL DEFAULT 1 COMMENT '0表示拒绝通知，1表示接受通知',
  `organization_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '机构名称',
  `main_page` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主页链接',
  `country` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '86' COMMENT '所在国家，默认是86',
  `province` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所在省份',
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所在城市',
  `download_num_total` int NULL DEFAULT 0 COMMENT '可下载场景总数',
  `download_num` int NULL DEFAULT 0 COMMENT '已下载场景总数',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `user_name`(`user_name`) USING BTREE,
  INDEX `nick_name`(`nick_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户信息表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Table structure for t_scene_resource_cooperation
-- ----------------------------
Create Table If Not Exists `t_scene_resource_cooperation`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `scene_resource_id` bigint NULL DEFAULT NULL COMMENT '场景资源id',
  `scene_cooperation_id` bigint NULL DEFAULT NULL COMMENT '协作用户的id',
  `create_time` datetime NULL DEFAULT NULL,
  `update_time` datetime NULL DEFAULT NULL,
  `rec_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '场景资源和协作用户关联表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Table structure for t_scene_resource
-- ----------------------------
Create Table If Not Exists `t_scene_resource`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限名称',
  `en_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '英文名',
  `key_word` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限key',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限图标',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源描述',
  `version` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '版本(v3,v4)',
  `create_time` datetime NULL DEFAULT NULL,
  `update_time` datetime NULL DEFAULT NULL,
  `rec_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '场景资源表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Table structure for t_scene_data_download
-- ----------------------------
Create Table If Not Exists `t_scene_data_download`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `scene_num` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `file_md5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件md5',
  `download_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件下载地址',
  `create_time` datetime NULL DEFAULT NULL,
  `update_time` datetime NULL DEFAULT NULL,
  `rec_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '安居客场景数据下载' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Table structure for t_scene_cooperation
-- ----------------------------
Create Table If Not Exists `t_scene_cooperation`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `scene_num` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `user_id` bigint NULL DEFAULT NULL COMMENT '协作的用户id',
  `create_time` datetime NULL DEFAULT NULL,
  `update_time` datetime NULL DEFAULT NULL,
  `rec_status` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'A',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

SET FOREIGN_KEY_CHECKS = 1;


ALTER TABLE `laser`.`t_scene` MODIFY COLUMN `build_obj_status` int NULL DEFAULT 0 COMMENT '生成OBJ状态,0，未生成 1完成，2计算中' AFTER `obj_url`;




ALTER TABLE `laser`.`t_model` change model_glb_url model_url varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL ;