Account (Database Table)

From SWGANH Wiki
Revision as of 19:32, 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 Account Username
password char(32) NO Account Password (MD5)
station_id bigint(20) Symbol OK.png 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) Symbol OK.png 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)