CREATE TABLE IF NOT EXISTS "pantry_settings" (
	"id" uuid PRIMARY KEY DEFAULT gen_random_uuid() NOT NULL,
	"pantry_name" varchar(255) DEFAULT 'Community Food Pantry' NOT NULL,
	"contact_phone" varchar(50),
	"address" text,
	"low_stock_threshold" integer DEFAULT 5 NOT NULL,
	"expiry_warning_days" integer DEFAULT 7 NOT NULL,
	"created_at" timestamp DEFAULT now() NOT NULL,
	"updated_at" timestamp DEFAULT now() NOT NULL
);
--> statement-breakpoint
ALTER TABLE "orders" ALTER COLUMN "priority" SET DATA TYPE varchar(50);