Difference between revisions of "Account (Database Table)"

Table Structure

Field Type Unsigned Autoinc Null Key Default Value Description account_id bigint(20) NO Primary Null Account ID username char(32) NO Unique Account Username password char(32) NO Account Password (MD5) station_id bigint(20) NO Account STATION_ID csr tinyint(1) NO Account flag (CSR) banned tinyint(1) NO Account flag (Banned) email char(64) NO Account email. joindate datetime NO 0000-00-00 00:00:00 Date/Time of account creation. lastlogin timestamp YES NULL Date/Time of last login. active tinyint(1) YES NULL User account active. loggedin int(1) NO 0 Logged in. authenticated tinyint(1) NO 0 Authenicated with Login Server. characters_allowed tinyint(3) NO 2 Characters allowed per galaxy.

Table Create Script

--
-- Definition of table `account`
--

DROP TABLE IF EXISTS `account`;
CREATE TABLE `account` (
  `account_id` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Account ID',
  `username` char(32) character set latin1 NOT NULL default '' COMMENT 'Account username',
  `password` char(32) character set latin1 NOT NULL default '' COMMENT 'Account password',
  `station_id` bigint(20) unsigned NOT NULL default '0' COMMENT 'Account STATION_ID',
  `csr` tinyint(1) NOT NULL default '0' COMMENT 'Account - CSR Flag',
  `banned` tinyint(1) NOT NULL default '0' COMMENT 'Account - Banned Status',
  `email` char(64) character set latin1 NOT NULL default '' COMMENT 'Account - User email',
  `joindate` datetime NOT NULL default '0000-00-00 00:00:00' COMMENT 'Account - Join Date',
  `lastlogin` timestamp NULL default NULL COMMENT 'Account - Last Login Timestamp',
  `active` tinyint(1) default NULL COMMENT 'Account - Active Flag',
  `loggedin` int(1) NOT NULL default '0' COMMENT 'Account - Cluster id account is logged into',
  `authenticated` tinyint(1) NOT NULL default '0' COMMENT 'Account - Authenticated Status',
  `characters_allowed` tinyint(3) unsigned NOT NULL default '2',
  PRIMARY KEY  (`account_id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Table Describe

mysql> describe account;
+--------------------+---------------------+------+-----+---------------------+----------------+
| Field              | Type                | Null | Key | Default             | Extra          |
+--------------------+---------------------+------+-----+---------------------+----------------+
| account_id         | bigint(20) unsigned | NO   | PRI | NULL                | auto_increment | 
| username           | char(32)            | NO   | UNI |                     |                | 
| password           | char(32)            | NO   |     |                     |                | 
| station_id         | bigint(20) unsigned | NO   |     | 0                   |                | 
| csr                | tinyint(1)          | NO   |     | 0                   |                | 
| banned             | tinyint(1)          | NO   |     | 0                   |                | 
| email              | char(64)            | NO   |     |                     |                | 
| joindate           | datetime            | NO   |     | 0000-00-00 00:00:00 |                | 
| lastlogin          | timestamp           | YES  |     | NULL                |                | 
| active             | tinyint(1)          | YES  |     | NULL                |                | 
| loggedin           | int(1)              | NO   |     | 0                   |                | 
| authenticated      | tinyint(1)          | NO   |     | 0                   |                | 
| characters_allowed | tinyint(3) unsigned | NO   |     | 2                   |                | 
+--------------------+---------------------+------+-----+---------------------+----------------+
13 rows in set (0.00 sec)