DROP VIEW "public"."tech_vendor_candidates_with_vendor_info";--> statement-breakpoint
ALTER TABLE "tech_vendor_possible_items" ADD COLUMN "vendor_code" varchar(100);--> statement-breakpoint
ALTER TABLE "tech_vendor_possible_items" ADD COLUMN "vendor_email" varchar(255);--> statement-breakpoint
ALTER TABLE "tech_vendor_possible_items" ADD COLUMN "work_type" varchar(100);--> statement-breakpoint
ALTER TABLE "tech_vendor_possible_items" ADD COLUMN "ship_types" varchar(255);--> statement-breakpoint
ALTER TABLE "tech_vendor_possible_items" ADD COLUMN "item_list" varchar(500);--> statement-breakpoint
ALTER TABLE "tech_vendor_possible_items" ADD COLUMN "sub_item_list" varchar(500);--> statement-breakpoint
ALTER TABLE "tech_vendors" ADD COLUMN "is_quote_comparison" boolean DEFAULT false NOT NULL;--> statement-breakpoint
ALTER TABLE "tech_vendor_candidates" DROP COLUMN "address";--> statement-breakpoint
ALTER TABLE "tech_vendor_candidates" DROP COLUMN "source";--> statement-breakpoint
ALTER TABLE "tech_vendor_candidates" DROP COLUMN "items";--> statement-breakpoint
CREATE VIEW "public"."tech_vendor_candidates_with_vendor_info" AS (select "tech_vendor_candidates"."id", "tech_vendor_candidates"."company_name", "tech_vendor_candidates"."contact_email", "tech_vendor_candidates"."contact_phone", "tech_vendor_candidates"."tax_id", "tech_vendor_candidates"."country", "tech_vendor_candidates"."status", "tech_vendor_candidates"."remark", "tech_vendor_candidates"."created_at", "tech_vendor_candidates"."updated_at", "tech_vendors"."vendor_name", "tech_vendors"."vendor_code", "tech_vendors"."created_at" as "vendor_created_at" from "tech_vendor_candidates" left join "tech_vendors" on "tech_vendor_candidates"."vendor_id" = "tech_vendors"."id");