blob: 7121801773724161d014834b63611ae94b58277a (
plain)
1
2
3
4
5
6
|
ALTER TABLE "vendor_candidates" ADD COLUMN "tax_id" varchar(100) NOT NULL;--> statement-breakpoint
ALTER TABLE "vendor_candidates" ADD COLUMN "address" text;--> statement-breakpoint
ALTER TABLE "vendor_candidates" ADD COLUMN "remark" text;--> statement-breakpoint
ALTER TABLE "vendor_candidates" ADD COLUMN "items" text NOT NULL;--> statement-breakpoint
ALTER TABLE "vendor_candidates" ADD COLUMN "vendor_id" integer;--> statement-breakpoint
ALTER TABLE "vendor_candidates" ADD CONSTRAINT "vendor_candidates_vendor_id_vendors_id_fk" FOREIGN KEY ("vendor_id") REFERENCES "public"."vendors"("id") ON DELETE cascade ON UPDATE no action;
|
