mirror of
https://github.com/yusufipk/OpenFrame.git
synced 2026-09-11 09:36:08 +00:00
Yusuf İpek
6f22b0bf8b
- Added billing-related fields to the User model in the database. - Implemented functions for managing billing access, including trial periods and subscription statuses. - Created new billing utility functions for Stripe integration. - Updated onboarding page to include billing overview and workspace creation eligibility. - Enhanced route access checks to require billing access for certain actions. - Implemented cleanup scripts for expired billing workspaces and associated media. - Updated header component to conditionally show app navigation based on billing access. - Added new migrations for billing-related database changes.
21 lines
604 B
SQL
21 lines
604 B
SQL
CREATE TYPE "BillingSubscriptionStatus" AS ENUM (
|
|
'FREE',
|
|
'TRIALING',
|
|
'ACTIVE',
|
|
'PAST_DUE',
|
|
'CANCELED',
|
|
'UNPAID',
|
|
'INCOMPLETE',
|
|
'INCOMPLETE_EXPIRED'
|
|
);
|
|
|
|
ALTER TABLE "users"
|
|
ADD COLUMN "stripeCustomerId" TEXT,
|
|
ADD COLUMN "stripeSubscriptionId" TEXT,
|
|
ADD COLUMN "stripePriceId" TEXT,
|
|
ADD COLUMN "stripeCurrentPeriodEnd" TIMESTAMP(3),
|
|
ADD COLUMN "subscriptionStatus" "BillingSubscriptionStatus" NOT NULL DEFAULT 'FREE';
|
|
|
|
CREATE UNIQUE INDEX "users_stripeCustomerId_key" ON "users"("stripeCustomerId");
|
|
CREATE UNIQUE INDEX "users_stripeSubscriptionId_key" ON "users"("stripeSubscriptionId");
|