AAAAhome/academiac/www/administrator/components/com_admin/sql/updates/mysql/2.5.4-2012-03-19.sql000064400000000534151374612750025050 0ustar00ALTER TABLE `#__languages` ADD COLUMN `access` integer unsigned NOT NULL default 0 AFTER `published`; ALTER TABLE `#__languages` ADD KEY `idx_access` (`access`); UPDATE `#__categories` SET `extension` = 'com_users.notes' WHERE `extension` = 'com_users'; UPDATE `#__extensions` SET `enabled` = '1' WHERE `protected` = '1' AND `type` <> 'plugin'; home/academiac/www/administrator/components/com_admin/sql/updates/sqlazure/2.5.4-2012-03-19.sql000064400000000522151374650370025546 0ustar00ALTER TABLE [#__languages] ADD [access] INTEGER CONSTRAINT DF_languages_access DEFAULT '' NOT NULL CREATE UNIQUE INDEX idx_access ON [jos_languages] (access); UPDATE [#__categories] SET extension = 'com_users.notes' WHERE extension = 'com_users'; UPDATE [#__extensions] SET enabled = '1' WHERE protected = '1' AND [type] <> 'plugin';