CREATE TYPE "public"."subscription_status" AS ENUM('active', 'trialing', 'past_due', 'canceled', 'incomplete');--> statement-breakpoint
ALTER TABLE "users" ADD COLUMN "stripe_subscription_id" text;--> statement-breakpoint
ALTER TABLE "users" ADD COLUMN "subscription_status" "subscription_status";--> statement-breakpoint
ALTER TABLE "users" ADD COLUMN "current_period_end" timestamp;--> statement-breakpoint
ALTER TABLE "tier_definitions" ADD COLUMN "stripe_product_id" text;--> statement-breakpoint
ALTER TABLE "tier_definitions" ADD COLUMN "stripe_price_id_monthly" text;--> statement-breakpoint
ALTER TABLE "tier_definitions" ADD COLUMN "stripe_price_id_yearly" text;