0037_contact_message_country.sql 582 B

123456789
  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. ALTER TABLE "contact_messages" ADD COLUMN IF NOT EXISTS "subject" text;
  8. ALTER TABLE "contact_messages" ADD COLUMN IF NOT EXISTS "country" text;