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 Number of characters allowed per galaxy.

Table Create Script

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)