0030_user_profile_dob_tz.sql11 lines · main

1	-- 0030_user_profile_dob_tz — add date_of_birth, country_of_birth, and
2	-- timezone to users so the Profile & Billing details form on the
3	-- dashboard can collect the full KYC block. country_of_birth is
4	-- ISO 3166-1 alpha-2 (separate from address_country / residency).
5	-- timezone is an IANA zone name (e.g. 'Europe/Brussels'); used to
6	-- render timestamps + schedule weekly digests at the user's local time.
7
8	ALTER TABLE "users"
9	ADD COLUMN IF NOT EXISTS "date_of_birth" date,
10	ADD COLUMN IF NOT EXISTS "country_of_birth" text,
11	ADD COLUMN IF NOT EXISTS "timezone" text;