max / makenotwork

794 B · 20 lines History Blame Raw

1	-- Creator tier stored as TEXT on users table
2	ALTER TABLE users ADD COLUMN creator_tier TEXT;
3
4	-- Creator tier subscription records (mirrors fan_plus_subscriptions)
5	CREATE TABLE creator_subscriptions (
6	id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
7	user_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,
8	stripe_subscription_id TEXT NOT NULL UNIQUE,
9	stripe_customer_id TEXT NOT NULL,
10	tier TEXT NOT NULL,
11	status TEXT NOT NULL DEFAULT 'active',
12	current_period_start TIMESTAMPTZ,
13	current_period_end TIMESTAMPTZ,
14	canceled_at TIMESTAMPTZ,
15	created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
16	);
17
18	CREATE UNIQUE INDEX idx_creator_subs_user ON creator_subscriptions(user_id);
19	CREATE INDEX idx_creator_subs_stripe ON creator_subscriptions(stripe_subscription_id);
20