diff options
Diffstat (limited to 'db/migrations/0210_right_madelyne_pryor.sql')
| -rw-r--r-- | db/migrations/0210_right_madelyne_pryor.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/db/migrations/0210_right_madelyne_pryor.sql b/db/migrations/0210_right_madelyne_pryor.sql new file mode 100644 index 00000000..21e2d943 --- /dev/null +++ b/db/migrations/0210_right_madelyne_pryor.sql @@ -0,0 +1,12 @@ +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");
\ No newline at end of file |