-- Add Stripe subscription tracking fields to User

ALTER TABLE "User" ADD COLUMN "stripeSubscriptionId" TEXT;
ALTER TABLE "User" ADD COLUMN "subscriptionStatus" TEXT;
ALTER TABLE "User" ADD COLUMN "subscriptionPriceId" TEXT;
ALTER TABLE "User" ADD COLUMN "subscriptionCurrentPeriodEnd" DATETIME;

CREATE UNIQUE INDEX "User_stripeSubscriptionId_key" ON "User"("stripeSubscriptionId");
