1ALTER TABLE `tiki_modules` MODIFY COLUMN `position` VARCHAR(20); 2ALTER TABLE `tiki_user_assigned_modules` MODIFY COLUMN `position` VARCHAR(20); 3 4UPDATE `tiki_modules` SET `position` = 'top' WHERE `position` = 't'; 5UPDATE `tiki_modules` SET `position` = 'topbar' WHERE `position` = 'o'; 6UPDATE `tiki_modules` SET `position` = 'pagetop' WHERE `position` = 'p'; 7UPDATE `tiki_modules` SET `position` = 'left' WHERE `position` = 'l'; 8UPDATE `tiki_modules` SET `position` = 'right' WHERE `position` = 'r'; 9UPDATE `tiki_modules` SET `position` = 'pagebottom' WHERE `position` = 'q'; 10UPDATE `tiki_modules` SET `position` = 'bottom' WHERE `position` = 'b'; 11 12ALTER TABLE `tiki_modules` ADD INDEX `namePosOrdParam` (`name`(100), `position`, `ord`, `params`(120)); 13 14UPDATE `tiki_user_assigned_modules` SET `position` = 'top' WHERE `position` = 't'; 15UPDATE `tiki_user_assigned_modules` SET `position` = 'topbar' WHERE `position` = 'o'; 16UPDATE `tiki_user_assigned_modules` SET `position` = 'pagetop' WHERE `position` = 'p'; 17UPDATE `tiki_user_assigned_modules` SET `position` = 'left' WHERE `position` = 'l'; 18UPDATE `tiki_user_assigned_modules` SET `position` = 'right' WHERE `position` = 'r'; 19UPDATE `tiki_user_assigned_modules` SET `position` = 'pagebottom' WHERE `position` = 'q'; 20UPDATE `tiki_user_assigned_modules` SET `position` = 'bottom' WHERE `position` = 'b'; 21