# $Id: upgrade4500_Beta104toRC1.sql,v 1.8 2003/12/09 03:46:30 eddieajau Exp $

# Beta 1.0.4 to RC1

ALTER TABLE `mos_users` ADD `registerDate` DATETIME NOT NULL , ADD `lastvisitDate` DATETIME NOT NULL ;

# If you are running 1.0.4.2 then use the following ONLY.

# registration control moved to configuration
UPDATE `mos_modules` SET params='' WHERE module='mod_login';

# special group not supported in the core pending ACL improvements in 4.6
DELETE FROM `mos_groups` WHERE name='Special';

# fix for bug in 103-to-104 script
UPDATE `mos_users` SET gid='25' WHERE usertype='superadministrator' AND gid='0';
UPDATE `mos_users` SET gid='24' WHERE usertype='administrator' AND gid='1';
UPDATE `mos_users` SET gid='20' WHERE usertype='editor' AND gid='2';
UPDATE `mos_users` SET gid='18' WHERE usertype NOT IN ('editor','administrator','superadministrator') AND gid='3';

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