summaryrefslogtreecommitdiff
path: root/db/migrations/0302_happy_expediter.sql
diff options
context:
space:
mode:
authordujinkim <dujin.kim@dtsolution.co.kr>2025-08-26 01:17:56 +0000
committerdujinkim <dujin.kim@dtsolution.co.kr>2025-08-26 01:17:56 +0000
commit12e936c0b45ffa1c8f3c02ff77961212767be9a7 (patch)
tree34f31b9a64c6d30e187c1114530c4d47b95d30a9 /db/migrations/0302_happy_expediter.sql
parent83f67ed333f0237b434a41d1eceef417c0d48313 (diff)
(대표님) 가입, 기본계약, 벤더
(최겸) 기술영업 아이템 관련
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