# $Id: upgrade4500_RC1toRC2.sql,v 1.2 2003/12/10 04:22:50 eddieajau Exp $

# RC1 to RC2

ALTER TABLE `mos_components` CHANGE `admin_menu_alt` `admin_menu_alt` varchar(255) NOT NULL default '';

# Update some options so that the ACL can limit components listed in the Administrator
UPDATE `mos_components` SET `option`='com_banners' WHERE name='Banners';
UPDATE `mos_components` SET `option`='com_newsfeeds' WHERE name='Newsfeeds' OR name='News Feeds';

ALTER TABLE `mos_content_frontpage` DROP KEY `idx_contentid`;
ALTER TABLE `mos_content_frontpage` DROP `id`;
ALTER TABLE `mos_content_frontpage` ADD PRIMARY KEY (`content_id`);