########################################################################
# task 10384. Sites that should have branded STS link
########################################################################

INSERT INTO `pc_zz_Settings` (`name`, `idCategory`, `fieldType`, `label`, `value`, `options`, `description`, `required`, `system`, `sorter`, `added`, `changed`) VALUES
('stsAuthLink', 1, 'htmlEditor', 'STS Link Text', '<p>Not sure how to make the change you want or considering adding extra  functionality to your site? Let us help you. Post your question or  comment in our <a target="_blank" href="{url}">online support system</a>.</p>', '', 'Constants: {url}', 'y', 'y', 25, '2010-08-25 00:00:00', '2010-09-30 17:42:59');

INSERT INTO `pc_zz_SettingsOptions` (`name`, `variable`, `value`, `type`) VALUES
('stsAuthLink', 'toolbarSet', 'Basic', 'string'),
('stsAuthLink', 'mode', 'view', 'string');

ALTER TABLE `pc_zz_Admin` ADD `stsLoginCode` CHAR( 32 ) NULL DEFAULT NULL AFTER `firstName`;

ALTER TABLE `pc_zz_Admin` ADD `stsLoginEnabled` ENUM( 'n', 'y' ) NOT NULL AFTER `firstName` ,
ADD INDEX ( `stsLoginEnabled` );

UPDATE `pc_zz_Admin` SET `stsLoginEnabled` = 'y' WHERE `pc_zz_Admin`.`login` = 'admin' LIMIT 1 ;