PHP Code:
CREATE TABLE IF NOT EXISTS `users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`old_password` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`passhash` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`secret` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`email` varchar(80) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`status` enum('pending','confirmed') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'pending',
`added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_login` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_access` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_catchup` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`editsecret` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`privacy` enum('normal','strong') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'normal',
`stylesheet` int(10) DEFAULT '1',
`info` text CHARACTER SET latin1 COLLATE latin1_general_ci,
`acceptpms` enum('yes','friends','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`ip` varchar(15) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`class` tinyint(2) unsigned NOT NULL DEFAULT '1',
`avatar` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`uploaded` bigint(20) unsigned NOT NULL DEFAULT '0',
`downloaded` bigint(20) unsigned NOT NULL DEFAULT '0',
`title` varchar(60) CHARACTER SET latin1 COLLATE latin1_general_ci default NULL,
`country` bigint(20) unsigned NOT NULL DEFAULT '0',
`notifs` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`modcomment` text CHARACTER SET latin1 COLLATE latin1_general_ci default NULL,
`enabled` enum('yes','no') NOT NULL DEFAULT 'yes',
`disable_reason` text default NULL,
`imunity` enum('yes','no') NOT NULL DEFAULT 'no',
`avatars` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`donor` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no',
`warned` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no',
`warneduntil` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`torrentsperpage` int(3) unsigned NOT NULL DEFAULT '0',
`topicsperpage` int(3) unsigned NOT NULL DEFAULT '0',
`postsperpage` int(3) unsigned NOT NULL DEFAULT '0',
`deletepms` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`savepms` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no',
`parked` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no',
`announce` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`passkey` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`last_browse` int(11) NOT NULL DEFAULT '0',
`last_browsex` int(11) NOT NULL DEFAULT '0',
`last_browsem` int(11) NOT NULL DEFAULT '0',
`fader` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`fadecolor` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'FF0000',
`support` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no',
`supportfor` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`supportlang` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`invited_by` int(10) NOT NULL DEFAULT '0',
`invitees` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`invites` int(1) NOT NULL DEFAULT '0',
`gender` enum('Male','Female','N/A') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'N/A',
`invitedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`view_adult` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`view_music` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`view_adult_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`view_music_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`view_musiclo_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`view_musicvi_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`view_musicpks_browse` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`advertisename` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'no',
`signatures` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'yes',
`signature` varchar(225) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`uploadpos` enum('yes','no') NOT NULL DEFAULT 'no',
`downloadpos` enum('yes','no') NOT NULL DEFAULT 'yes',
`forumpost` enum('yes','no') NOT NULL DEFAULT 'yes',
`chatpost` enum('yes','no') NOT NULL DEFAULT 'no',
`chatdisable` enum('yes','no') NOT NULL DEFAULT 'no',
`donated` decimal(8,2) NOT NULL DEFAULT '0.00',
`last_pm` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_comment` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_post` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`forum_access` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_staffmsg` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`timezone` smallint(3) NOT NULL DEFAULT '120',
`dst` tinyint(2) NOT NULL DEFAULT '0',
`commentpm` enum('yes','no') NOT NULL DEFAULT 'yes',
`staff_chat_access` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`groups` int(10) unsigned NOT NULL DEFAULT '0',
`rangclass` int(10) unsigned NOT NULL DEFAULT '0',
`zodiac` int(10) unsigned NOT NULL DEFAULT '0',
`donoruntil` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`total_donated` decimal(8,2) NOT NULL DEFAULT '0.00',
`last_check` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`leechwarn` enum('yes','no') NOT NULL DEFAULT 'no',
`timeswarned` int(10) NOT NULL DEFAULT '0',
`seedbonus` decimal(5,1) NOT NULL DEFAULT '0.0',
`bonuscomment` longtext character set utf8 collate utf8_bin NULL,
`vip_added` enum('yes','no') NOT NULL DEFAULT 'no',
`vip_until` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`smile_until` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`parola` varchar(40) NOT NULL DEFAULT '',
`passhint` text default NULL,
`hintanswer` varchar(40) NOT NULL DEFAULT '',
`upped` enum('yes','no') NOT NULL DEFAULT 'no',
`lastup` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`upwarn` enum('yes','no') NOT NULL DEFAULT 'no',
`hit_run_total` int(9) DEFAULT '0',
`sendmailnotif` enum('yes','no') NOT NULL DEFAULT 'no',
`mod_added` enum('yes','no') NOT NULL DEFAULT 'no',
`mod_until` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`trial` enum('yes','no') NOT NULL DEFAULT 'no',
`bjwins` int(10) NOT NULL DEFAULT '0',
`bjlosses` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
KEY `status_added` (`status`,`added`),
KEY `ip` (`ip`),
KEY `uploaded` (`uploaded`),
KEY `downloaded` (`downloaded`),
KEY `country` (`country`),
KEY `last_access` (`last_access`),
KEY `warned` (`warned`),
KEY `passkey` (`passkey`),
KEY `id` (`id`,`username`,`old_password`,`passhash`,`secret`),
KEY `stylesheet` (`stylesheet`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=453 ;