Account (Database Table)

From SWGANH Wiki
Revision as of 13:07, 5 June 2007 by Snow (Talk | contribs) (Table Structure)

Jump to: navigation, search

Database Table - Accounts

SWGANH Wiki is a repository of Star Wars Galaxies Developer information. This site is only meant to be used by SWGANH Developer team.


Table Structure

Field Type Unsigned Autoinc Null Key Default Value Description
account_id bigint(20) Symbol OK.png Symbol OK.png NO Primary Null Account ID
username char(32) NO Unique
password char(32) NO
station_id bigint(20) Symbol OK.png NO
csr tinyint(1) NO
banned tinyint(1) NO
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) Symbol OK.png NO 2

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)