blob: 8bb6eb8837d6b41319aa9b65d17f1d8a93c72448 (
plain)
1
2
3
4
5
6
7
8
9
10
|
ALTER TABLE "combo_box_settings" DROP CONSTRAINT "unique_project_code_group_code";--> statement-breakpoint
ALTER TABLE "document_number_type_configs" DROP CONSTRAINT "unique_project_number_type_sdq";--> statement-breakpoint
ALTER TABLE "combo_box_settings" DROP CONSTRAINT "combo_box_settings_project_id_projects_id_fk";
--> statement-breakpoint
ALTER TABLE "document_number_type_configs" DROP CONSTRAINT "document_number_type_configs_project_id_projects_id_fk";
--> statement-breakpoint
ALTER TABLE "combo_box_settings" DROP COLUMN "project_id";--> statement-breakpoint
ALTER TABLE "document_number_type_configs" DROP COLUMN "project_id";--> statement-breakpoint
ALTER TABLE "combo_box_settings" ADD CONSTRAINT "unique_code_group_code" UNIQUE("code_group_id","code");--> statement-breakpoint
ALTER TABLE "document_number_type_configs" ADD CONSTRAINT "unique_document_number_type_sdq" UNIQUE("document_number_type_id","sdq");
|
