summaryrefslogtreecommitdiff
path: root/db/migrations/0101_past_killraven.sql
diff options
context:
space:
mode:
authorrlaks5757 <rlaks5757@gmail.com>2025-03-27 17:48:36 +0900
committerrlaks5757 <rlaks5757@gmail.com>2025-03-27 17:48:36 +0900
commit773918229ccb14c0d00798fbbf2b2be0130a8251 (patch)
treeab9e200e65cc471ec139cd8482bde70a3b0a105f /db/migrations/0101_past_killraven.sql
parent92ddb4f13d48cbf344dc2bf63df4457b3c713608 (diff)
parent34bbeb86c1a8d24b5f526710889b5e54d699cfd0 (diff)
merge complete
Diffstat (limited to 'db/migrations/0101_past_killraven.sql')
-rw-r--r--db/migrations/0101_past_killraven.sql5
1 files changed, 5 insertions, 0 deletions
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