CREATE TABLE "mcp_credit_purchases" (
	"id" text PRIMARY KEY NOT NULL,
	"org_id" text NOT NULL,
	"stripe_session_id" text NOT NULL,
	"credits" integer NOT NULL,
	"amount_cents" integer NOT NULL,
	"created_at" timestamp with time zone DEFAULT now() NOT NULL,
	CONSTRAINT "mcp_credit_purchases_stripe_session_id_unique" UNIQUE("stripe_session_id")
);
--> statement-breakpoint
ALTER TABLE "organization" ADD COLUMN "mcp_credit_balance" integer DEFAULT 0 NOT NULL;--> statement-breakpoint
ALTER TABLE "mcp_credit_purchases" ADD CONSTRAINT "mcp_credit_purchases_org_id_organization_id_fk" FOREIGN KEY ("org_id") REFERENCES "public"."organization"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
CREATE INDEX "mcp_credit_purchases_org_idx" ON "mcp_credit_purchases" USING btree ("org_id");