CREATE TABLE IF NOT EXISTS `bbdNesakysiu_users` (
`user_id` mediumint(8) unsigned NOT NULL auto_increment,
`user_name` varchar(30) NOT NULL default '',
`user_algo` varchar(10) NOT NULL default 'sha256',
`user_salt` varchar(40) NOT NULL default '',
`user_password` varchar(64) NOT NULL default '',
`user_admin_algo` varchar(10) NOT NULL default 'sha256',
`user_admin_salt` varchar(40) NOT NULL default '',
`user_admin_password` varchar(64) NOT NULL default '',
`user_email` varchar(100) NOT NULL default '',
`user_hide_email` tinyint(1) unsigned NOT NULL default '1',
`user_offset` char(5) NOT NULL default '0',
`user_avatar` varchar(100) NOT NULL default '',
`user_posts` smallint(5) unsigned NOT NULL default '0',
`user_threads` text NOT NULL,
`user_joined` int(10) unsigned NOT NULL default '0',
`user_lastvisit` int(10) unsigned NOT NULL default '0',
`user_ip` varchar(45) NOT NULL default '0.0.0.0',
`user_ip_type` tinyint(1) unsigned NOT NULL default '4',
`user_rights` text NOT NULL,
`user_groups` text NOT NULL,
`user_level` tinyint(3) unsigned NOT NULL default '101',
`user_status` tinyint(1) unsigned NOT NULL default '0',
`user_actiontime` int(10) unsigned NOT NULL default '0',
`user_theme` varchar(100) NOT NULL default 'Default',
`user_location` varchar(50) NOT NULL default '',
`user_birthdate` date NOT NULL default '0000-00-00',
`user_skype` varchar(100) NOT NULL default '',
`user_aim` varchar(16) NOT NULL default '',
`user_icq` varchar(15) NOT NULL default '',
`user_msn` varchar(100) NOT NULL default '',
`user_yahoo` varchar(100) NOT NULL default '',
`user_web` varchar(200) NOT NULL default '',
`user_sig` text NOT NULL,
PRIMARY KEY (`user_id`),
KEY `user_name` (`user_name`),
KEY `user_joined` (`user_joined`),
KEY `user_lastvisit` (`user_lastvisit`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;