USE [% pp3 %];

UPDATE `[% table_prefix %]_config`
    SET `config_value` = '3.0.8'
    WHERE `config_name` = 'version';

INSERT IGNORE INTO `[% table_prefix %]_config`
    SET `config_name` = 'load_unreads_search',
        `config_value` = '1',
        `is_dynamic` = 0;

UPDATE `[% table_prefix %]_extension_groups`
    SET `group_name` = CONCAT( 'EXT_GROUP_', UPPER( REPLACE( `group_name`, ' ', '_' ) ) )
    WHERE `group_name` NOT LIKE 'EXT_GROUP_%';
