Account (Database Table)

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) NO Primary Null Account ID username char(32) NO Unique password char(32) NO station_id bigint(20) unsigned 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) unsigned 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)