diff options
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 |