From 675b4e3d8ffcb57a041db285417d81e61284d900 Mon Sep 17 00:00:00 2001 From: dujinkim 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