From 675b4e3d8ffcb57a041db285417d81e61284d900 Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Sun, 14 Sep 2025 05:28:01 +0000
Subject: (대표님) RFQ-last, tbe-last, 기본계약 템플릿 내 견적,입찰,계약 추가,
 env.dev NAS_PATH 수정
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 db/migrations/0341_steep_sentinel.sql | 7 +++++++
 1 file changed, 7 insertions(+)
 create mode 100644 db/migrations/0341_steep_sentinel.sql

(limited to 'db/migrations/0341_steep_sentinel.sql')

diff --git a/db/migrations/0341_steep_sentinel.sql b/db/migrations/0341_steep_sentinel.sql
new file mode 100644
index 00000000..c6434985
--- /dev/null
+++ b/db/migrations/0341_steep_sentinel.sql
@@ -0,0 +1,7 @@
+ALTER TABLE "rfq_last_details" ADD COLUMN "send_version" integer DEFAULT 1;--> statement-breakpoint
+ALTER TABLE "rfq_last_details" ADD COLUMN "is_latest" boolean DEFAULT true NOT NULL;--> statement-breakpoint
+ALTER TABLE "rfq_last_details" ADD COLUMN "email_sent_at" timestamp;--> statement-breakpoint
+ALTER TABLE "rfq_last_details" ADD COLUMN "email_sent_to" text;--> statement-breakpoint
+ALTER TABLE "rfq_last_details" ADD COLUMN "email_resent_count" integer DEFAULT 0;--> statement-breakpoint
+ALTER TABLE "rfq_last_details" ADD COLUMN "last_email_sent_at" timestamp;--> statement-breakpoint
+ALTER TABLE "rfq_last_details" ADD COLUMN "email_status" varchar(30);
\ No newline at end of file
-- 
cgit v1.2.3

