summaryrefslogtreecommitdiff
path: root/db/migrations/0302_happy_expediter.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrations/0302_happy_expediter.sql')
-rw-r--r--db/migrations/0302_happy_expediter.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/db/migrations/0302_happy_expediter.sql b/db/migrations/0302_happy_expediter.sql
new file mode 100644
index 00000000..90657b06
--- /dev/null
+++ b/db/migrations/0302_happy_expediter.sql
@@ -0,0 +1,4 @@
+ALTER TABLE "combo_box_settings" ADD COLUMN "sdq" integer NOT NULL;--> statement-breakpoint
+ALTER TABLE "document_class_options_new" ADD COLUMN "sdq" integer NOT NULL;--> statement-breakpoint
+ALTER TABLE "combo_box_settings" ADD CONSTRAINT "unique_code_group_sdq" UNIQUE("code_group_id","sdq");--> statement-breakpoint
+ALTER TABLE "document_class_options_new" ADD CONSTRAINT "unique_document_class_sdq" UNIQUE("document_class_id","sdq"); \ No newline at end of file