# $Id: upgrade4500_Beta102to103.sql,v 1.12 2003/11/09 21:32:25 rcastley Exp $

# Beta 1.0.2 to 1.0.3

ALTER TABLE `mos_components` CHANGE `link` `link` varchar(255) NOT NULL default '';
ALTER TABLE `mos_components` CHANGE `admin_menu_link` `admin_menu_link` varchar(255) NOT NULL default '';
ALTER TABLE `mos_components` CHANGE `admin_menu_img` `admin_menu_img` varchar(255) NOT NULL default '';

INSERT INTO `mos_components` VALUES ('', 'Newsfeeds (Component)', 'option=com_newsfeeds', '', '', '','', '', '', '', '', '', '');

# aje :: 23/Oct/2003 

UPDATE `mos_menu` SET link='index.php?option=com_user&task=UserDetails' WHERE link='index.php?option=user&op=UserDetails';
UPDATE `mos_menu` SET link='index.php?option=com_user&task=CheckIn' WHERE link='index.php?option=user&op=CheckIn';

# rwc

ALTER TABLE `mos_newsflash` ADD `access` int (11) unsigned NOT NULL default '0'; 

# aje :: 30/Oct/2003 

UPDATE `mos_modules` SET module='mod_mainmenu' WHERE module='main_menu';
UPDATE `mos_modules` SET module='mod_mainmenu', params='menutype=usermenu' WHERE module='usermenu';

DROP TABLE `mos_footer`; 

INSERT INTO `mos_modules` VALUES ('', 'Archive', '', 8, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_archive', 0, 0, 1, '', 1);
INSERT INTO `mos_modules` VALUES ('', 'Registration', '', 9, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_registration', 0, 0, 1, '', 1);
INSERT INTO `mos_modules` VALUES ('', 'Sections', '', 10, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_sections', 0, 0, 1, '', 1);

CREATE TABLE `mos_votes` (
  `id` int(255) NOT NULL default '0',
  `content_id` int(11) NOT NULL default '0',
  `votes` varchar(255) NOT NULL default '',
  `allvotes` int(255) NOT NULL default '0',
  `rating` tinyint(1) NOT NULL default '0',
  `scope` VARCHAR( 50 ) NOT NULL default '',
  `lastip` varchar(50) NOT NULL default ''
) TYPE=MyISAM;