13 lines
504 B
SQL
13 lines
504 B
SQL
-- Podnapisi.net no longer has a reachable public service. Existing settings
|
|
-- must not keep selecting it or preserve a budget for a provider arr no
|
|
-- longer ships.
|
|
UPDATE subtitle_settings
|
|
SET providers_enabled = COALESCE(
|
|
(SELECT json_group_array(value)
|
|
FROM json_each(providers_enabled)
|
|
WHERE value != 'podnapisi'),
|
|
'[]'
|
|
),
|
|
provider_daily_budgets = json_remove(provider_daily_budgets, '$.podnapisi'),
|
|
updated_at = strftime('%Y-%m-%dT%H:%M:%fZ', 'now');
|