From 7548e2ad6948f1c6aa102fcac408bc6c9c0f9796 Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Wed, 27 Aug 2025 12:06:26 +0000
Subject: (대표님, 최겸) 기본계약, 입찰, 파일라우트, 계약서명라우트,
 인포메이션, 메뉴설정, PQ(메일템플릿 관련)
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 db/migrations/0304_faulty_wrecking_crew.sql | 24 ++++++++++++++++++++++++
 1 file changed, 24 insertions(+)
 create mode 100644 db/migrations/0304_faulty_wrecking_crew.sql

(limited to 'db/migrations/0304_faulty_wrecking_crew.sql')

diff --git a/db/migrations/0304_faulty_wrecking_crew.sql b/db/migrations/0304_faulty_wrecking_crew.sql
new file mode 100644
index 00000000..c5b10720
--- /dev/null
+++ b/db/migrations/0304_faulty_wrecking_crew.sql
@@ -0,0 +1,24 @@
+ALTER TABLE "contracts" ADD COLUMN "shippment_place" varchar(255);--> statement-breakpoint
+ALTER TABLE "contracts" ADD COLUMN "po_version" integer;--> statement-breakpoint
+ALTER TABLE "contracts" ADD COLUMN "purchase_doc_type" varchar(10);--> statement-breakpoint
+ALTER TABLE "contracts" ADD COLUMN "purchase_org" varchar(10);--> statement-breakpoint
+ALTER TABLE "contracts" ADD COLUMN "purchase_group" varchar(10);--> statement-breakpoint
+ALTER TABLE "contracts" ADD COLUMN "exchange_rate" numeric(9, 5);--> statement-breakpoint
+ALTER TABLE "contracts" ADD COLUMN "po_confirm_status" varchar(10);--> statement-breakpoint
+ALTER TABLE "contracts" ADD COLUMN "contract_guarantee_code" varchar(2);--> statement-breakpoint
+ALTER TABLE "contracts" ADD COLUMN "defect_guarantee_code" varchar(2);--> statement-breakpoint
+ALTER TABLE "contracts" ADD COLUMN "guarantee_period_code" varchar(2);--> statement-breakpoint
+ALTER TABLE "contracts" ADD COLUMN "advance_payment_yn" varchar(1);--> statement-breakpoint
+ALTER TABLE "contracts" ADD COLUMN "budget_amount" numeric(17, 2);--> statement-breakpoint
+ALTER TABLE "contracts" ADD COLUMN "budget_currency" varchar(5);--> statement-breakpoint
+ALTER TABLE "contracts" ADD COLUMN "total_amount_krw" numeric(17, 2);--> statement-breakpoint
+ALTER TABLE "contracts" ADD COLUMN "electronic_contract_yn" varchar(1);--> statement-breakpoint
+ALTER TABLE "contracts" ADD COLUMN "electronic_approval_date" date;--> statement-breakpoint
+ALTER TABLE "contracts" ADD COLUMN "electronic_approval_time" varchar(6);--> statement-breakpoint
+ALTER TABLE "contracts" ADD COLUMN "owner_approval_yn" varchar(1);--> statement-breakpoint
+ALTER TABLE "contracts" ADD COLUMN "planned_in_out_flag" varchar(1);--> statement-breakpoint
+ALTER TABLE "contracts" ADD COLUMN "settlement_standard" varchar(1);--> statement-breakpoint
+ALTER TABLE "contracts" ADD COLUMN "weight_settlement_flag" varchar(1);--> statement-breakpoint
+ALTER TABLE "contracts" ADD COLUMN "price_index_yn" varchar(1);--> statement-breakpoint
+ALTER TABLE "contracts" ADD COLUMN "written_contract_no" varchar(20);--> statement-breakpoint
+ALTER TABLE "contracts" ADD COLUMN "contract_version" integer;
\ No newline at end of file
-- 
cgit v1.2.3

