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;