4dkankan-fusion/doc/update-1.7.1.sql

ALTER TABLE `fd_fusion`.`t_case`
    ADD COLUMN `map_id` int NULL AFTER `show_scenes`;

ALTER TABLE `4dkankan_v4`.`t_scene_plus`
    ADD COLUMN `has_floorplan_ai` int  DEFAULT '0' AFTER `rec_status`;

CREATE TABLE `fd_fusion`.`t_map_config` (
                                            `id` int NOT NULL AUTO_INCREMENT,
                                            `name` varchar(255) DEFAULT NULL,
                                            `map_url` text,
                                            `coord` varchar(255) DEFAULT NULL,
                                            `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
                                            `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                                            `tb_status` int DEFAULT '0',
                                            PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;