ALTER TABLE `accounts`  
ADD COLUMN `token` varchar(64) NOT NULL default '', 
ADD COLUMN `last_load` int(32) NOT NULL default '0',  
ADD COLUMN `act_history` longtext NOT NULL, 
ADD COLUMN `last_login` int(32) NOT NULL default '0', 
ADD COLUMN `email_verified` tinyint(1) NOT NULL default '0', 
ADD COLUMN `city` varchar(64) NOT NULL default '',
ADD COLUMN `state` varchar(64) NOT NULL default '', 
ADD COLUMN `country` varchar(64) NOT NULL default '',
ADD COLUMN `zipcode` varchar(32) NOT NULL default '',
ADD COLUMN `latitude` float NOT NULL default '0',
ADD COLUMN `longitude` float NOT NULL default '0',
ADD COLUMN `timezone` varchar(32) NOT NULL default '',
ADD COLUMN `birthdate` varchar(32) NOT NULL default '',
ADD COLUMN `astrologic_sign` varchar(32) NOT NULL default '',
ADD COLUMN `horoscope` longtext NOT NULL, 
ADD COLUMN `horoscope_date` int(64) NOT NULL default '0', 
ADD COLUMN `age` int(3) NOT NULL default '0',
ADD COLUMN `gender` varchar(32) NOT NULL default '',
ADD COLUMN `language` varchar(100) NOT NULL default '', 
ADD COLUMN `use_theme` varchar(250) NOT NULL default '',
ADD COLUMN `description` longtext NOT NULL,  
ADD COLUMN `quote` varchar(250) NOT NULL default '',
ADD COLUMN `header` longtext NOT NULL,
ADD COLUMN `notepad_body` longtext NOT NULL, 
ADD COLUMN `profile_data` longtext NOT NULL,
ADD COLUMN `mailboxes` longtext NOT NULL,
ADD COLUMN `pictures` longtext NOT NULL,
ADD COLUMN `mainpicture` varchar(100) NOT NULL default '',
ADD COLUMN `contacts` longtext NOT NULL, 
ADD COLUMN `relationship_requests` longtext NOT NULL, 
ADD COLUMN `block` longtext NOT NULL,  
ADD COLUMN `profile_views` longtext NOT NULL, 
ADD COLUMN `profile_votes` longtext NOT  NULL,  
ADD COLUMN `pictures_votes` longtext NOT NULL,
ADD COLUMN `favorites` longtext NOT NULL, 
ADD COLUMN `nudges` longtext NOT NULL,
ADD COLUMN `settings` longtext NOT NULL,
ADD COLUMN `spam_reports` longtext NOT NULL,
ADD COLUMN `abuse_reports` longtext NOT NULL,
ADD COLUMN `account_type` int(32) NOT NULL default '0',
ADD COLUMN `account_expire` int(64) NOT NULL default '0',
ADD COLUMN `registration_date` int(64) NOT NULL default '0',
ADD COLUMN `registration_reference` varchar(250) NOT NULL default '',
ADD COLUMN `active` tinyint(1) NOT NULL default '0', 
ADD COLUMN `disable_until` int(64) NOT NULL default '0', 
ADD COLUMN `is_moderator` tinyint(1) NOT NULL default '0',
ADD COLUMN `is_administrator` tinyint(1) NOT NULL default '0',
ADD COLUMN `is_superadministrator` tinyint(1) NOT NULL default '0',
ADD FULLTEXT KEY `login` (`login`,`city`,`state`,`country`,`zipcode`,`gender`,`quote`,`header`,`profile_data`);