diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-09-23 07:53:01 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-09-23 07:53:01 +0000 |
| commit | ee52d354c7f44052c585a27f4974a9f6512c1196 (patch) | |
| tree | 27e6956b37104a36b9ffaa6ee8c05033f61abf0e /db/migrations/0386_unique_talkback.sql | |
| parent | 4eca28c080c5afcbe71afbe53d5fdb0859cc28c9 (diff) | |
(대표님, 임수민) 도큐먼트 리스트 role 수정
Diffstat (limited to 'db/migrations/0386_unique_talkback.sql')
| -rw-r--r-- | db/migrations/0386_unique_talkback.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/db/migrations/0386_unique_talkback.sql b/db/migrations/0386_unique_talkback.sql new file mode 100644 index 00000000..12037a19 --- /dev/null +++ b/db/migrations/0386_unique_talkback.sql @@ -0,0 +1,10 @@ +ALTER TABLE "nonsap"."cmctb_cd" ALTER COLUMN "USR_DF_CHK_1" SET DATA TYPE varchar(10);--> statement-breakpoint +ALTER TABLE "nonsap"."cmctb_cd" ALTER COLUMN "USR_DF_CHK_2" SET DATA TYPE varchar(10);--> statement-breakpoint +ALTER TABLE "nonsap"."cmctb_cd" ALTER COLUMN "USR_DF_CHK_3" SET DATA TYPE varchar(10);--> statement-breakpoint +ALTER TABLE "nonsap"."cmctb_cd" ALTER COLUMN "USR_DF_CHK_4" SET DATA TYPE varchar(10);--> statement-breakpoint +ALTER TABLE "nonsap"."cmctb_cd" ALTER COLUMN "USR_DF_CHK_5" SET DATA TYPE varchar(10);--> statement-breakpoint +ALTER TABLE "nonsap"."cmctb_cd" ALTER COLUMN "USR_DF_CHK_6" SET DATA TYPE varchar(10);--> statement-breakpoint +ALTER TABLE "nonsap"."cmctb_cd" ALTER COLUMN "USR_DF_CHK_7" SET DATA TYPE varchar(10);--> statement-breakpoint +ALTER TABLE "nonsap"."cmctb_cd" ALTER COLUMN "USR_DF_CHK_8" SET DATA TYPE varchar(10);--> statement-breakpoint +CREATE UNIQUE INDEX "unique_standard_avl_material_vendor" ON "avl_vendor_info" USING btree ("construction_sector","ship_type","avl_kind","ht_division","material_group_code","vendor_name") WHERE "avl_vendor_info"."is_template" = true;--> statement-breakpoint +CREATE UNIQUE INDEX "unique_project_avl_material_vendor" ON "avl_vendor_info" USING btree ("project_code","material_group_code","vendor_name") WHERE "avl_vendor_info"."is_template" = false;
\ No newline at end of file |