ALTER TABLE users ADD COLUMN IF NOT EXISTS preferred_city_code text;

CREATE INDEX IF NOT EXISTS users_preferred_city_code_idx
  ON users(preferred_city_code)
  WHERE preferred_city_code IS NOT NULL;
