From 7cd9dbf45e8e29f3bb0c00ac4f14d5588029c3ba Mon Sep 17 00:00:00 2001
From: maven <2163098428@qq.com>
Date: 星期六, 11 十月 2025 17:45:02 +0800
Subject: [PATCH] yys 新增车牌字段
---
main-business/src/main/resources/db/migration/postgresql/V20250630153900__create_table_timing_task.sql | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diff --git a/main-business/src/main/resources/db/migration/postgresql/V20250630153900__create_table_timing_task.sql b/main-business/src/main/resources/db/migration/postgresql/V20250630153900__create_table_timing_task.sql
index d5c2107..d2ef480 100644
--- a/main-business/src/main/resources/db/migration/postgresql/V20250630153900__create_table_timing_task.sql
+++ b/main-business/src/main/resources/db/migration/postgresql/V20250630153900__create_table_timing_task.sql
@@ -18,8 +18,9 @@
is_active BOOLEAN DEFAULT TRUE, -- 鏄惁婵�娲�
remarks TEXT, -- 澶囨敞
registrant_id BIGINT, -- 鐧昏浜篿d锛屼笉鍏佽涓虹┖
- registrant VARCHAR(255) NOT NULL, -- 鐧昏浜猴紝涓嶅厑璁镐负绌�
+ registrant VARCHAR(255), -- 鐧昏浜猴紝涓嶅厑璁镐负绌�
registration_date DATE NOT NULL, -- 鐧昏鏃ユ湡锛屼笉鍏佽涓虹┖
+ status VARCHAR(255), -- 鐘舵��
deleted INT NOT NULL DEFAULT 0, -- 杞垹闄ゆ爣蹇楋細0=鏈垹闄わ紝1=宸插垹闄�
create_by VARCHAR(255), -- 鍒涘缓浜虹敤鎴峰悕
@@ -42,7 +43,7 @@
COMMENT
ON COLUMN timing_task.inspection_location IS '宸℃鍦扮偣';
COMMENT
-ON COLUMN timing_task.frequency IS '棰戞';
+ON COLUMN timing_task.frequency_type IS '棰戞';
COMMENT
ON COLUMN timing_task.remarks IS '澶囨敞';
COMMENT
--
Gitblit v1.9.3