db/migrations_backup/0048_strange_ultimo.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

CREATE TABLE "vendor_documents" (
	"vendor_id" integer NOT NULL,
	"id" integer NOT NULL,
	"doc_number" varchar(100) NOT NULL,
	"title" varchar(255) NOT NULL,
	"contract_id" integer NOT NULL,
	"contract_no" varchar(100) NOT NULL,
	"contract_name" varchar(255) NOT NULL,
	"status" varchar(50) NOT NULL,
	"created_at" timestamp with time zone,
	"updated_at" timestamp with time zone
);
--> statement-breakpoint
ALTER TABLE "revisions" ALTER COLUMN "file_path" SET DATA TYPE varchar(1024);--> statement-breakpoint
ALTER TABLE "revisions" ALTER COLUMN "file_path" SET NOT NULL;--> statement-breakpoint
ALTER TABLE "revisions" ADD COLUMN "file_name" varchar(255) NOT NULL;