blob: 6c40f36181bd036e1429f203d2dac5efedeb2dc7 (
plain)
1
2
3
4
5
6
7
8
|
ALTER TABLE "avl_vendor_info" DROP CONSTRAINT "avl_vendor_info_avl_list_id_avl_list_id_fk";
--> statement-breakpoint
ALTER TABLE "avl_list" ADD COLUMN "vendor_info_snapshot" json;--> statement-breakpoint
ALTER TABLE "avl_vendor_info" ADD COLUMN "is_template" boolean DEFAULT false;--> statement-breakpoint
ALTER TABLE "avl_vendor_info" ADD COLUMN "construction_sector" varchar(10);--> statement-breakpoint
ALTER TABLE "avl_vendor_info" ADD COLUMN "ship_type" varchar(50);--> statement-breakpoint
ALTER TABLE "avl_vendor_info" ADD COLUMN "avl_kind" varchar(50);--> statement-breakpoint
ALTER TABLE "avl_vendor_info" ADD COLUMN "ht_division" varchar(10);
|