keyhan
5239e8aa94
When users delete an app before plan expiry, remaining resources become credits for a new deploy. The deploy calculator shows covered vs additional charges, prices optional services correctly, and prorates extras to days left on the credit. Co-authored-by: Cursor <cursoragent@cursor.com>
25 lines
873 B
SQL
25 lines
873 B
SQL
CREATE TABLE IF NOT EXISTS resource_credits (
|
|
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
|
|
"userId" UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,
|
|
"sourceAppName" VARCHAR,
|
|
runtime VARCHAR NOT NULL,
|
|
"databaseType" VARCHAR NOT NULL,
|
|
"cpuLimit" VARCHAR NOT NULL,
|
|
"memoryLimit" VARCHAR NOT NULL,
|
|
replicas INT NOT NULL DEFAULT 1,
|
|
"dbStorageSize" VARCHAR,
|
|
"appStorageSize" VARCHAR,
|
|
"enableRedis" BOOLEAN NOT NULL DEFAULT false,
|
|
"enableRabbitmq" BOOLEAN NOT NULL DEFAULT false,
|
|
"enableElasticsearch" BOOLEAN NOT NULL DEFAULT false,
|
|
"billingCycle" VARCHAR,
|
|
"expiresAt" TIMESTAMPTZ NOT NULL,
|
|
"consumedAt" TIMESTAMPTZ,
|
|
"appliedApplicationId" VARCHAR,
|
|
"createdAt" TIMESTAMPTZ NOT NULL DEFAULT NOW()
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_resource_credits_user_active
|
|
ON resource_credits ("userId", "expiresAt")
|
|
WHERE "consumedAt" IS NULL;
|