Code:
CREATE TABLE `users` (
`id` int(10) UNSIGNED NOT NULL,
`username` varchar(40) NOT NULL DEFAULT '',
`password` varchar(255) NOT NULL DEFAULT '',
`secret` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`email` varchar(80) NOT NULL DEFAULT '',
`status` enum('pending','confirmed') NOT NULL DEFAULT 'pending',
`added` datetime DEFAULT NULL,
`last_login` datetime DEFAULT NULL,
`last_access` datetime DEFAULT NULL,
`editsecret` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
`privacy` enum('strong','normal','low') NOT NULL DEFAULT 'normal',
`stylesheet` int(10) DEFAULT '1',
`language` varchar(20) NOT NULL DEFAULT '1',
`info` text,
`acceptpms` enum('yes','no') NOT NULL DEFAULT 'yes',
`ip` varchar(39) NOT NULL DEFAULT '',
`class` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
`avatar` varchar(100) NOT NULL DEFAULT '',
`uploaded` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
`downloaded` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
`title` varchar(30) NOT NULL DEFAULT '',
`donated` int(5) UNSIGNED NOT NULL DEFAULT '0',
`country` int(10) UNSIGNED NOT NULL DEFAULT '0',
`notifs` varchar(100) NOT NULL DEFAULT '',
`enabled` varchar(10) NOT NULL DEFAULT 'yes',
`modcomment` text,
`gender` varchar(6) NOT NULL DEFAULT '',
`client` varchar(25) NOT NULL DEFAULT '',
`age` int(3) NOT NULL DEFAULT '0',
`warned` char(3) NOT NULL DEFAULT 'no',
`signature` varchar(200) NOT NULL DEFAULT '',
`last_browse` int(11) NOT NULL DEFAULT '0',
`forumbanned` char(3) NOT NULL DEFAULT 'no',
`invited_by` int(10) NOT NULL DEFAULT '0',
`invitees` varchar(100) NOT NULL DEFAULT '',
`invites` smallint(5) NOT NULL DEFAULT '0',
`invitedate` datetime DEFAULT NULL,
`commentpm` enum('yes','no') NOT NULL DEFAULT 'yes',
`passkey` varchar(32) NOT NULL DEFAULT '',
`page` text,
`team` int(10) UNSIGNED NOT NULL DEFAULT '0',
`tzoffset` int(4) DEFAULT '0',
`hideshoutbox` enum('yes','no') NOT NULL DEFAULT 'no'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=0;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `username` (`username`),
ADD KEY `status_added` (`status`,`added`),
ADD KEY `ip` (`ip`),
ADD KEY `uploaded` (`uploaded`),
ADD KEY `downloaded` (`downloaded`),
ADD KEY `country` (`country`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;