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'