Account (Database Table)
From SWGANH Wiki
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 Create Script
DROP TABLE IF EXISTS `account`; CREATE TABLE `account` ( `account_id` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Account ID', `username` char(32) NOT NULL default '' COMMENT 'Account username', `password` char(64) NOT NULL 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) 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', `session_key` varchar(32) default NULL, 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(64) | NO | | NULL | | | 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 | | | session_key | varchar(32) | YES | | NULL | | +--------------------+---------------------+------+-----+---------------------+----------------+ 14 rows in set (0.01 sec)