CREATE TABLE "items" (
	"id" serial PRIMARY KEY NOT NULL,
	"item_code" varchar(100) PRIMARY KEY NOT NULL,
	"item_name" varchar(255) NOT NULL,
	"description" text,
	"created_at" timestamp DEFAULT now() NOT NULL,
	"updated_at" timestamp DEFAULT now() NOT NULL
);
--> statement-breakpoint
ALTER TABLE "vendor_possible_items" ALTER COLUMN "item_code" SET NOT NULL;--> statement-breakpoint
ALTER TABLE "rfq_items" ADD CONSTRAINT "rfq_items_item_code_items_item_code_fk" FOREIGN KEY ("item_code") REFERENCES "public"."items"("item_code") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
ALTER TABLE "vendor_possible_items" ADD CONSTRAINT "vendor_possible_items_item_code_items_item_code_fk" FOREIGN KEY ("item_code") REFERENCES "public"."items"("item_code") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
ALTER TABLE "rfq_items" DROP COLUMN "item_name";--> statement-breakpoint
ALTER TABLE "vendor_possible_items" DROP COLUMN "item_name";