-- Built-in content modules (News, Products, ...) are now licensed per website like custom ones.
-- Existing websites keep everything they had: add every built-in key they do not list yet. Idempotent.
UPDATE `Site` SET `enabledModules` = JSON_ARRAY_APPEND(`enabledModules`, '$', 'news') WHERE JSON_SEARCH(`enabledModules`, 'one', 'news') IS NULL;
UPDATE `Site` SET `enabledModules` = JSON_ARRAY_APPEND(`enabledModules`, '$', 'products') WHERE JSON_SEARCH(`enabledModules`, 'one', 'products') IS NULL;
UPDATE `Site` SET `enabledModules` = JSON_ARRAY_APPEND(`enabledModules`, '$', 'sponsors') WHERE JSON_SEARCH(`enabledModules`, 'one', 'sponsors') IS NULL;
UPDATE `Site` SET `enabledModules` = JSON_ARRAY_APPEND(`enabledModules`, '$', 'exhibitors') WHERE JSON_SEARCH(`enabledModules`, 'one', 'exhibitors') IS NULL;
UPDATE `Site` SET `enabledModules` = JSON_ARRAY_APPEND(`enabledModules`, '$', 'speakers') WHERE JSON_SEARCH(`enabledModules`, 'one', 'speakers') IS NULL;
UPDATE `Site` SET `enabledModules` = JSON_ARRAY_APPEND(`enabledModules`, '$', 'videos') WHERE JSON_SEARCH(`enabledModules`, 'one', 'videos') IS NULL;
UPDATE `Site` SET `enabledModules` = JSON_ARRAY_APPEND(`enabledModules`, '$', 'resources') WHERE JSON_SEARCH(`enabledModules`, 'one', 'resources') IS NULL;
UPDATE `Site` SET `enabledModules` = JSON_ARRAY_APPEND(`enabledModules`, '$', 'testimonials') WHERE JSON_SEARCH(`enabledModules`, 'one', 'testimonials') IS NULL;
UPDATE `Site` SET `enabledModules` = JSON_ARRAY_APPEND(`enabledModules`, '$', 'galleries') WHERE JSON_SEARCH(`enabledModules`, 'one', 'galleries') IS NULL;
UPDATE `Site` SET `enabledModules` = JSON_ARRAY_APPEND(`enabledModules`, '$', 'faqs') WHERE JSON_SEARCH(`enabledModules`, 'one', 'faqs') IS NULL;
