blob: 740223564711b2633e9aac30af045ee333b20b65 (
plain)
1
2
3
4
5
|
ALTER TABLE "vendor_data_report_temps" DROP CONSTRAINT "vendor_data_report_temps_form_code_forms_form_code_fk";
--> statement-breakpoint
ALTER TABLE "vendor_data_report_temps" ADD COLUMN "formId" integer NOT NULL;--> statement-breakpoint
ALTER TABLE "vendor_data_report_temps" ADD CONSTRAINT "vendor_data_report_temps_formId_forms_id_fk" FOREIGN KEY ("formId") REFERENCES "public"."forms"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
ALTER TABLE "vendor_data_report_temps" DROP COLUMN "form_code";
|