/*Column Information For - logon.accounts*/
-------------------------------------------

FIELD               TYPE                 Collation        NULL    KEY     DEFAULT              Extra           Privileges                       Comment
------------------  -------------------  ---------------  ------  ------  -------------------  --------------  -------------------------------  ----------------------
acct                INT(10) UNSIGNED     (NULL)           NO      PRI     (NULL)               AUTO_INCREMENT  SELECT,INSERT,UPDATE,REFERENCES  UNIQUE ID
login               VARCHAR(32)          utf8_unicode_ci  NO      UNI     (NULL)                               SELECT,INSERT,UPDATE,REFERENCES  Login username
password            VARCHAR(32)          utf8_unicode_ci  NO              (NULL)                               SELECT,INSERT,UPDATE,REFERENCES  Login password
encrypted_password  VARCHAR(64)          utf8_unicode_ci  NO              (NULL)                               SELECT,INSERT,UPDATE,REFERENCES
gm                  VARCHAR(32)          utf8_unicode_ci  NO                                                   SELECT,INSERT,UPDATE,REFERENCES  Game permissions
banned              tinyint(3) UNSIGNED  (NULL)           NO              0                                    SELECT,INSERT,UPDATE,REFERENCES  Account Standing
lastlogin           TIMESTAMP            (NULL)           NO              0000-00-00 00:00:00                  SELECT,INSERT,UPDATE,REFERENCES  LAST login TIMESTAMP
lastip              VARCHAR(16)          utf8_unicode_ci  NO                                                   SELECT,INSERT,UPDATE,REFERENCES  LAST remote address
email               VARCHAR(64)          utf8_unicode_ci  NO                                                   SELECT,INSERT,UPDATE,REFERENCES  Contact e-mail address
flags               tinyint(3) UNSIGNED  (NULL)           NO              0                                    SELECT,INSERT,UPDATE,REFERENCES  Client flags
forceLanguage       VARCHAR(5)           utf8_unicode_ci  NO              enUS                                 SELECT,INSERT,UPDATE,REFERENCES
muted               INT(30)              (NULL)           NO              0                                    SELECT,INSERT,UPDATE,REFERENCES
banreason           VARCHAR(255)         utf8_unicode_ci  YES             (NULL)                               SELECT,INSERT,UPDATE,REFERENCES
reward_points       INT(11)              (NULL)           YES             (NULL)                               SELECT,INSERT,UPDATE,REFERENCES
votes               INT(20)              (NULL)           YES             (NULL)                               SELECT,INSERT,UPDATE,REFERENCES
votes2              INT(20)              (NULL)           YES             (NULL)                               SELECT,INSERT,UPDATE,REFERENCES
votes3              INT(20)              (NULL)           YES             (NULL)                               SELECT,INSERT,UPDATE,REFERENCES

/*Index Information For - logon.accounts*/
------------------------------------------

TABLE     Non_unique  Key_name  Seq_in_index  Column_name  Collation  Cardinality  Sub_part  Packed  NULL    Index_type  Comment
--------  ----------  --------  ------------  -----------  ---------  -----------  --------  ------  ------  ----------  -------
accounts           0  PRIMARY              1  acct         A                22991    (NULL)  (NULL)          BTREE
accounts           0  a                    1  login        A                22991    (NULL)  (NULL)          BTREE

/*DDL Information For - logon.accounts*/
----------------------------------------

TABLE     CREATE TABLE
--------  -----------------------------------------------------------------------------------------------------------------
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'