samsour.de
eny.space Landingpage
1-- Additional security: Add a check constraint to ensure data integrity
2-- Note: RLS policies already prevent users from updating, but this adds an extra layer
3
4-- Ensure status is one of the valid Stripe subscription statuses
5ALTER TABLE subscriptions
6 DROP CONSTRAINT IF EXISTS valid_subscription_status;
7
8ALTER TABLE subscriptions
9 ADD CONSTRAINT valid_subscription_status
10 CHECK (status IN (
11 'incomplete',
12 'incomplete_expired',
13 'trialing',
14 'active',
15 'past_due',
16 'canceled',
17 'unpaid',
18 'paused'
19 ));