diff options
Diffstat (limited to 'db/migrations/0264_careless_namora.sql')
| -rw-r--r-- | db/migrations/0264_careless_namora.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/db/migrations/0264_careless_namora.sql b/db/migrations/0264_careless_namora.sql new file mode 100644 index 00000000..8bb6eb88 --- /dev/null +++ b/db/migrations/0264_careless_namora.sql @@ -0,0 +1,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");
\ No newline at end of file |