From 6f4110be95c83b18e223c8d662d68c675364c74e Mon Sep 17 00:00:00 2001 From: dujinkim Date: Wed, 26 Mar 2025 06:33:14 +0000 Subject: 2025.3.26.1533 --- db/migrations/0101_past_killraven.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 db/migrations/0101_past_killraven.sql (limited to 'db/migrations/0101_past_killraven.sql') diff --git a/db/migrations/0101_past_killraven.sql b/db/migrations/0101_past_killraven.sql new file mode 100644 index 00000000..afb8370c --- /dev/null +++ b/db/migrations/0101_past_killraven.sql @@ -0,0 +1,5 @@ +ALTER TABLE "vendor_data_report_temps" DROP CONSTRAINT "vendor_data_report_temps_formId_forms_id_fk"; +--> statement-breakpoint +ALTER TABLE "vendor_data_report_temps" ADD COLUMN "form_id" integer NOT NULL;--> statement-breakpoint +ALTER TABLE "vendor_data_report_temps" ADD CONSTRAINT "vendor_data_report_temps_form_id_forms_id_fk" FOREIGN KEY ("form_id") REFERENCES "public"."forms"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint +ALTER TABLE "vendor_data_report_temps" DROP COLUMN "formId"; \ No newline at end of file -- cgit v1.2.3