account table

gistfile1.txt

delimiter $$

CREATE TABLE `accounts` (
  `account_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Account ID',
  `account_username` char(32) NOT NULL DEFAULT '' COMMENT 'Account username',
  `account_password` char(64) NOT NULL COMMENT 'Account password',
  `account_station_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Account STATION_ID',
  `account_level` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Account - CSR Flag',
  `account_banned` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Account - Banned Status',
  `account_email` char(64) NOT NULL DEFAULT '' COMMENT 'Account - User email',
  `account_joindate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Account - Join Date',
  `account_lastlogin` timestamp NULL DEFAULT NULL COMMENT 'Account - Last Login Timestamp',
  `account_active` tinyint(1) DEFAULT NULL COMMENT 'Account - Active Flag',
  `account_loggedin` int(1) NOT NULL DEFAULT '0' COMMENT 'Account - Cluster id account is logged into',
  `account_authenticated` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Account - Authenticated Status',
  `account_characters_allowed` tinyint(3) unsigned NOT NULL DEFAULT '2' COMMENT 'Number of characters allowed',
  `account_session_key` varchar(32) DEFAULT NULL COMMENT 'Client Launcher - Session Key',
  `account_lastcreate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Account - Last Character Create TimeStamp',
  PRIMARY KEY (`account_id`),
  UNIQUE KEY `account_username` (`account_username`)
) ENGINE=InnoDB AUTO_INCREMENT=1036 DEFAULT CHARSET=utf8$$