-- -- Add a default value for the colorScheme in the Atum template on Joomla update -- only when a value is not already set. -- New installs will have the default value set in the installation sql. -- UPDATE "#__template_styles" SET "params" = jsonb_set("params"::jsonb, '{colorScheme}', '"os"', true) WHERE "template" = 'atum' AND "params"::jsonb->>'colorScheme' IS NULL;