0037_contact_message_country.sql9 lines · main

1	-- 0037_contact_message_country — extra fields on public /contact intake.
2	-- The redesigned /contact page submits a free-text "subject" line and a
3	-- locked "country" auto-detected from the visitor's IP (self-hosted geo-IP
4	-- lookup, no third-party call). Both are hints for the operator and are
5	-- nullable: the topic-only flow and older clients submit without them.
6	-- Country is NEVER a gate — it's display + triage context only.
7
8	ALTER TABLE "contact_messages" ADD COLUMN IF NOT EXISTS "subject" text;
9	ALTER TABLE "contact_messages" ADD COLUMN IF NOT EXISTS "country" text;