use [% e107 %];

-- Corrects on omission from the previous upgrade.  This update
-- was in the 0.7.26 -> 1.0.0 upgrade, but the 1.0.0 -> 1.0.2
-- upgrade reintroduced the 'reline' option.
UPDATE [% table_prefix %]_core SET e107_value=replace(e107_value,"'reline'", "'core'") WHERE e107_name = "SitePrefs";

-- From function update_10x_to_103
DELIMITER @@

CREATE PROCEDURE BecauseMySQLDoesNotAcceptIfStatementsOutsideOfAProcedure()
BEGIN
    SHOW INDEX FROM `[% table_prefix %]_news` WHERE `Key_name` IN ('news_sticky', 'news_datestamp');
    SELECT FOUND_ROWS() INTO @num_found;

    IF @num_found = 0 THEN
        ALTER TABLE `[% table_prefix %]_news` ADD INDEX `news_sticky` (`news_sticky`);
        ALTER TABLE `[% table_prefix %]_news` ADD INDEX `news_datestamp` (`news_datestamp`);
        ALTER TABLE `[% table_prefix %]_news` ADD INDEX `news_start` (`news_start`);
    END IF;
END @@

DELIMITER ;

CALL BecauseMySQLDoesNotAcceptIfStatementsOutsideOfAProcedure();
DROP PROCEDURE BecauseMySQLDoesNotAcceptIfStatementsOutsideOfAProcedure;

-- From function update_103_to_104
UPDATE `[% table_prefix %]_core`
    SET `e107_value` =
        replace(
            replace(
                replace(
                    replace(`e107_value`, 'amp;', ''),
                    '[sanitised]', ''),
                '[/sanitised]', ''),
            '##xss##', '')
    WHERE `e107_name` = "SitePrefs" AND `e107_value` LIKE '%amp;amp;%'
        LIMIT 1;
