blob: 907276e73599124836c512ae44bd49be4c525e07 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
ALTER TABLE "vendors" ALTER COLUMN "status" SET DEFAULT 'PENDING_REVIEW';--> statement-breakpoint
ALTER TABLE "vendor_attachments" ADD COLUMN "attachment_type" varchar(50) DEFAULT 'GENERAL';--> statement-breakpoint
ALTER TABLE "vendor_attachments" ADD COLUMN "created_at" timestamp DEFAULT now() NOT NULL;--> statement-breakpoint
ALTER TABLE "vendor_attachments" ADD COLUMN "updated_at" timestamp DEFAULT now() NOT NULL;--> statement-breakpoint
ALTER TABLE "vendors" ADD COLUMN "representative_name" varchar(255);--> statement-breakpoint
ALTER TABLE "vendors" ADD COLUMN "representative_birth" varchar(20);--> statement-breakpoint
ALTER TABLE "vendors" ADD COLUMN "representative_email" varchar(255);--> statement-breakpoint
ALTER TABLE "vendors" ADD COLUMN "representative_phone" varchar(50);--> statement-breakpoint
ALTER TABLE "vendors" ADD COLUMN "corporate_registration_number" varchar(100);--> statement-breakpoint
ALTER TABLE "vendors" ADD COLUMN "credit_agency" varchar(50);--> statement-breakpoint
ALTER TABLE "vendors" ADD COLUMN "credit_rating" varchar(50);--> statement-breakpoint
ALTER TABLE "vendors" ADD COLUMN "cash_flow_rating" varchar(50);
|
