accounts  CREATE TABLE `accounts` (
`acct` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique ID',
`login` varchar(32) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Login username',
`password` varchar(32) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Login password',
`encrypted_password` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`gm` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Game permissions',
`banned` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Standing',
`lastlogin` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Last login timestamp',
`lastip` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Last remote address',
`email` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Contact e-mail address',
`flags` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Client flags',
`forceLanguage` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'enUS',
`muted` int(30) NOT NULL DEFAULT '0',
`banreason` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`reward_points` int(11) DEFAULT NULL,
`votes` int(20) DEFAULT NULL,
`votes2` int(20) DEFAULT NULL,
`votes3` int(20) DEFAULT NULL,
PRIMARY KEY (`acct`),
UNIQUE KEY `a` (`login`)
) ENGINE=MyISAM AUTO_INCREMENT=23002 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Account Information'