CREATE TABLE "seranking_sync_purchases" (
	"id" text PRIMARY KEY NOT NULL,
	"org_id" text NOT NULL,
	"stripe_session_id" text NOT NULL,
	"syncs" integer NOT NULL,
	"amount_cents" integer NOT NULL,
	"created_at" timestamp with time zone DEFAULT now() NOT NULL,
	CONSTRAINT "seranking_sync_purchases_stripe_session_id_unique" UNIQUE("stripe_session_id")
);
--> statement-breakpoint
ALTER TABLE "organization" ADD COLUMN "seranking_sync_balance" integer DEFAULT 0 NOT NULL;--> statement-breakpoint
ALTER TABLE "organization" ADD COLUMN "seranking_unlimited" boolean DEFAULT false NOT NULL;--> statement-breakpoint
ALTER TABLE "organization" ADD COLUMN "seranking_api_key" text;--> statement-breakpoint
ALTER TABLE "seranking_sync_purchases" ADD CONSTRAINT "seranking_sync_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 "seranking_sync_purchases_org_idx" ON "seranking_sync_purchases" USING btree ("org_id");