From 983bdb5b89932b38d08a11ad1eed6ea89d1597e1 Mon Sep 17 00:00:00 2001
From: kongzy <kongzy>
Date: 星期一, 29 一月 2024 10:07:31 +0800
Subject: [PATCH] 更新

---
 assess-admin/src/main/resources/db/migration/V20231205004_face_record.sql |    7 ++++---
 1 files changed, 4 insertions(+), 3 deletions(-)

diff --git a/assess-admin/src/main/resources/db/migration/V20231205004_face_record.sql b/assess-admin/src/main/resources/db/migration/V20231205004_face_record.sql
index cf246a4..3ce8472 100644
--- a/assess-admin/src/main/resources/db/migration/V20231205004_face_record.sql
+++ b/assess-admin/src/main/resources/db/migration/V20231205004_face_record.sql
@@ -2,12 +2,13 @@
 -- ----------------------------
 -- 现场勘验人员人脸识别记录表
 -- ----------------------------
-drop table if exists `smart_assess`.`sys_face_record`;
-CREATE TABLE `smart_assess`.`sys_face_record`  (
+CREATE TABLE `smart_assess`.`ass_face_record`  (
 `id` bigint NOT NULL AUTO_INCREMENT,
 `person_id` bigint NOT NULL COMMENT '用户id',
-`file_id` bigint NOT NULL COMMENT '评估文件id(图片id)',
 `project_id` bigint NOT NULL COMMENT '项目id',
+`location` varchar(60) NULL COMMENT '纬度/经度',
+`face_path` varchar(100) NULL COMMENT '人脸图片路径',
+`scene` tinyint NULL DEFAULT 0 COMMENT '是否是现场勘验人脸识别(0否 1是，默认0)',
 `version` int NULL DEFAULT 0 COMMENT '乐观锁',
 `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志(0正常，1删除，默认0)',
 `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人',

--
Gitblit v1.9.2