Tabellenstruktur für Tabelle `user`
--
CREATE TABLE IF NOT EXISTS `user` (
`user_id` int(10) unsigned NOT NULL auto_increment,
`username` varchar(50) NOT NULL,
`email` varchar(120) NOT NULL,
`gender` enum('','male','female') NOT NULL default '' COMMENT 'Leave empty for ''unspecified''',
`custom_title` varchar(50) NOT NULL default '',
`language_id` int(10) unsigned NOT NULL,
`style_id` int(10) unsigned NOT NULL COMMENT '0 = use system default',
`timezone` varchar(50) NOT NULL COMMENT 'Example: ''Europe/London''',
`visible` tinyint(3) unsigned NOT NULL default '1' COMMENT 'Show browsing activity to others',
`user_group_id` int(10) unsigned NOT NULL,
`secondary_group_ids` varbinary(255) NOT NULL,
`display_style_group_id` int(10) unsigned NOT NULL default '0' COMMENT 'User group ID that provides user styling',
`permission_combination_id` int(10) unsigned NOT NULL,
`message_count` int(10) unsigned NOT NULL default '0',
`conversations_unread` smallint(5) unsigned NOT NULL default '0',
`register_date` int(10) unsigned NOT NULL default '0',
`last_activity` int(10) unsigned NOT NULL default '0',
`trophy_points` int(10) unsigned NOT NULL default '0',
`alerts_unread` smallint(5) unsigned NOT NULL default '0',
`avatar_date` int(10) unsigned NOT NULL default '0',
`avatar_width` smallint(5) unsigned NOT NULL default '0',
`avatar_height` smallint(5) unsigned NOT NULL default '0',
`gravatar` varchar(120) NOT NULL default '' COMMENT 'If specified, this is an email address corresponding to the user''s ''Gravatar''',
`user_state` enum('valid','email_confirm','email_confirm_edit','moderated') NOT NULL default 'valid',
`is_moderator` tinyint(3) unsigned NOT NULL default '0',
`is_admin` tinyint(3) unsigned NOT NULL default '0',
`is_banned` tinyint(3) unsigned NOT NULL default '0',
`like_count` int(10) unsigned NOT NULL default '0',
`warning_points` int(10) unsigned NOT NULL default '0',
`advanced_rules` smallint(5) default NULL,
`friend_count` int(10) unsigned NOT NULL default '0',
`personal_friend_count` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`user_id`),
UNIQUE KEY `username` (`username`),
KEY `email` (`email`),
KEY `user_state` (`user_state`),
KEY `last_activity` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6383 ;