105_migrate_websearch_emulation_to_tristate.sql 475 B

1234567891011
  1. -- Convert old boolean web_search_emulation to tri-state string
  2. -- true → "enabled", false → remove key (becomes "default")
  3. UPDATE accounts
  4. SET extra = (extra - 'web_search_emulation') || jsonb_build_object('web_search_emulation', 'enabled')
  5. WHERE extra ? 'web_search_emulation'
  6. AND extra->>'web_search_emulation' = 'true';
  7. UPDATE accounts
  8. SET extra = extra - 'web_search_emulation'
  9. WHERE extra ? 'web_search_emulation'
  10. AND extra->>'web_search_emulation' = 'false';