From a2a1f2a22db7c2e53275359fb5f8d6c0dd15d8d6 Mon Sep 17 00:00:00 2001
From: kongzy <kongzy>
Date: 星期五, 09 八月 2024 16:25:58 +0800
Subject: [PATCH] update

---
 assess-admin/src/main/resources/db/migration/V20231205002_investigation.sql |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/assess-admin/src/main/resources/db/migration/V20231205002_investigation.sql b/assess-admin/src/main/resources/db/migration/V20231205002_investigation.sql
index 5963af0..f13e029 100644
--- a/assess-admin/src/main/resources/db/migration/V20231205002_investigation.sql
+++ b/assess-admin/src/main/resources/db/migration/V20231205002_investigation.sql
@@ -2,7 +2,6 @@
 -- ----------------------------
 -- 现场勘验记录表
 -- ----------------------------
-drop table if exists `smart_assess`.`ass_investigation`;
 CREATE TABLE `smart_assess`.`ass_investigation`  (
 `id` bigint NOT NULL AUTO_INCREMENT,
 `investigation_date` datetime NOT NULL COMMENT '现场勘验时间',
@@ -10,6 +9,7 @@
 `is_safety_check` tinyint(1) NULL DEFAULT 0 COMMENT '编制现场安全检查表',
 `record_data` varchar(200) NULL COMMENT '现场勘验记录(200字)',
 `project_id` bigint NOT NULL COMMENT '项目id',
+`location` varchar(60) NULL COMMENT '纬度/经度',
 `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志(0正常，1删除，默认0)',
 `version` int NULL DEFAULT 0 COMMENT '乐观锁',
 `create_by` varchar(20) NULL COMMENT '创建人',

--
Gitblit v1.9.2