`db/migrations/020_restaurant_phone.sql`

54 lines
-- Add phone numbers to restaurants.
--
-- Hand-curated 2026-05-02 from each restaurant's official website / Google
-- business profile. Closed restaurants left NULL — phone is only meaningful
-- for currently-operating venues, and showing a dead number on a defunct
-- spot would be confusing.
--
-- A note on a few we deliberately left NULL even though the venue had a
-- well-known number:
--   cole-s             — original Cole's closed Aug 2024
--   nate-n-al-s        — Beverly Hills location closed 2023
--   taix-french-restaurant — original Echo Park building demolished 2024
--   pacific-dining-car — closed 2020
--
-- The display layer treats NULL phones as "closed / no current line".

ALTER TABLE restaurant ADD COLUMN IF NOT EXISTS phone text;

-- Bulk update via VALUES list keyed on slug. Slugs match the slugify()
-- output used by the seed scripts: lower, non-alnum→`-`, trim.
UPDATE restaurant AS r
SET phone = v.phone
FROM (VALUES
  ('musso-frank-grill',          '+1-323-467-7788'),
  ('dan-tana-s',                 '+1-310-275-9444'),
  ('the-ivy',                    '+1-310-274-8303'),
  ('craig-s',                    '+1-310-276-1900'),
  ('chateau-marmont',            '+1-323-656-1010'),
  ('spago',                      '+1-310-385-0880'),
  ('polo-lounge',                '+1-310-887-2777'),
  ('mr-chow-beverly-hills',      '+1-310-278-9911'),
  ('sunset-tower-hotel',         '+1-323-654-7100'),
  ('nobu-malibu',                '+1-310-317-9140'),
  ('catch-la',                   '+1-323-347-6060'),
  ('cecconi-s-west-hollywood',   '+1-310-432-2000'),
  ('philippe-the-original',      '+1-213-628-3781'),
  ('tito-s-tacos',               '+1-310-391-5780'),
  ('canters-deli',               '+1-323-651-2030'),
  ('langers-deli',               '+1-213-483-8050'),
  ('lawrys-the-prime-rib',       '+1-310-652-2827'),
  ('yamashiro-hollywood',        '+1-323-466-5125'),
  ('magic-castle',               '+1-323-851-3313'),
  ('beverly-hills-hotel',        '+1-310-276-2251'),
  ('hotel-bel-air',              '+1-310-472-1211'),
  ('el-coyote-cafe',             '+1-323-939-2255'),
  ('patrick-s-roadhouse',        '+1-310-459-4544'),
  ('lucy-s-el-adobe',            '+1-323-462-9421'),
  ('matsuhisa-beverly-hills',    '+1-310-659-9639'),
  ('pinks-hot-dogs',             '+1-323-931-7594'),
  ('apple-pan',                  '+1-310-475-3585'),
  ('the-ivy-at-the-shore',       '+1-310-393-3113')
) AS v(slug, phone)
WHERE r.slug = v.slug;