Release / update-version (push) Has been cancelled
Release / build-frontend (push) Has been cancelled
Release / release (push) Has been cancelled
Release / sync-version-file (push) Has been cancelled
CI / shell (push) Canceled after 0s
CI / test (push) Canceled after 0s
CI / frontend (push) Canceled after 0s
CI / golangci-lint (push) Canceled after 0s
Security Scan / backend-security (push) Canceled after 0s
Security Scan / frontend-security (push) Canceled after 0s
12 lines
475 B
SQL
12 lines
475 B
SQL
-- Convert old boolean web_search_emulation to tri-state string
|
|
-- true → "enabled", false → remove key (becomes "default")
|
|
UPDATE accounts
|
|
SET extra = (extra - 'web_search_emulation') || jsonb_build_object('web_search_emulation', 'enabled')
|
|
WHERE extra ? 'web_search_emulation'
|
|
AND extra->>'web_search_emulation' = 'true';
|
|
|
|
UPDATE accounts
|
|
SET extra = extra - 'web_search_emulation'
|
|
WHERE extra ? 'web_search_emulation'
|
|
AND extra->>'web_search_emulation' = 'false';
|