summaryrefslogtreecommitdiff
path: root/db/migrations/0308_futuristic_toxin.sql
diff options
context:
space:
mode:
authordujinkim <dujin.kim@dtsolution.co.kr>2025-08-27 12:06:26 +0000
committerdujinkim <dujin.kim@dtsolution.co.kr>2025-08-27 12:06:26 +0000
commit7548e2ad6948f1c6aa102fcac408bc6c9c0f9796 (patch)
tree8e66703ec821888ad51dcc242a508813a027bf71 /db/migrations/0308_futuristic_toxin.sql
parent7eac558470ef179dad626a8e82db5784fe86a556 (diff)
(대표님, 최겸) 기본계약, 입찰, 파일라우트, 계약서명라우트, 인포메이션, 메뉴설정, PQ(메일템플릿 관련)
Diffstat (limited to 'db/migrations/0308_futuristic_toxin.sql')
-rw-r--r--db/migrations/0308_futuristic_toxin.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/db/migrations/0308_futuristic_toxin.sql b/db/migrations/0308_futuristic_toxin.sql
new file mode 100644
index 00000000..5970379c
--- /dev/null
+++ b/db/migrations/0308_futuristic_toxin.sql
@@ -0,0 +1,5 @@
+ALTER TABLE "bidding_conditions" DROP CONSTRAINT "bidding_conditions_bidding_id_biddings_id_fk";
+--> statement-breakpoint
+ALTER TABLE "bidding_conditions" ADD COLUMN "bidding_company_id" integer NOT NULL;--> statement-breakpoint
+ALTER TABLE "bidding_conditions" ADD CONSTRAINT "bidding_conditions_bidding_company_id_bidding_companies_id_fk" FOREIGN KEY ("bidding_company_id") REFERENCES "public"."bidding_companies"("id") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
+ALTER TABLE "bidding_conditions" DROP COLUMN "bidding_id"; \ No newline at end of file