SET @footerSorter := (
    SELECT `sorter` FROM `qs_Settings` WHERE `name` = 'footer' AND `idCategory` = 1
);

UPDATE `qs_Settings`
SET `sorter` = `sorter` + 1
WHERE `idCategory` = 1 AND `sorter` >= @footerSorter;

INSERT INTO `qs_Settings` (`name`, `idCategory`, `fieldType`, `label`, `value`, `options`, `description`, `required`, `system`, `sorter`, `added`, `changed`) VALUES
('titleSuffix', 1, 'text', 'Page Title Suffix <span class="label_description">This text will be appended to every Page Title and will be shown in the browser tab on your website.</span>', '', '', '', 'n', 'n', @footerSorter, NOW(), NOW());



-- fix for previous version:

DELETE FROM `qs_SettingsOptions` WHERE `name` = 'titleSuffix' AND `value` = 'StringTrim';

UPDATE `qs_Settings`
SET `label` = 'Page Title Suffix <span class="label_description">This text will be appended to every Page Title and will be shown in the browser tab on your website.</span>'
WHERE `name` = 'titleSuffix'
LIMIT 1;