-- Add stripeSubscriptionId column to Subscription table
-- Run this SQL script directly on your database

ALTER TABLE "Subscription" 
ADD COLUMN "stripeSubscriptionId" TEXT;

-- Add unique constraint
CREATE UNIQUE INDEX "Subscription_stripeSubscriptionId_key" 
ON "Subscription"("stripeSubscriptionId") 
WHERE "stripeSubscriptionId" IS NOT NULL;

-- Add index for faster lookups
CREATE INDEX "Subscription_stripeSubscriptionId_idx" 
ON "Subscription"("stripeSubscriptionId");

