Difference between revisions of "Account (Database Table)"
From SWGANH Wiki
(→Table Structure) |
(→Table Structure) |
||
| Line 11: | Line 11: | ||
||account_id||bigint(20)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"|[[Image:Symbol OK.png|10px]]||NO||Primary||Null||Account ID | ||account_id||bigint(20)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"|[[Image:Symbol OK.png|10px]]||NO||Primary||Null||Account ID | ||
|- | |- | ||
| − | ||username||char(32)||align="center"| ||align="center"| ||NO||Unique|| || || | + | ||username||char(32)||align="center"| ||align="center"| ||NO||Unique|| || ||Account Username |
|- | |- | ||
| − | ||password||char(32)||align="center"| ||align="center"| ||NO|| || || | + | ||password||char(32)||align="center"| ||align="center"| ||NO|| || ||Account Password (MD5) |
|- | |- | ||
| − | ||station_id||bigint(20)||align="center"|[[Image:Symbol OK.png|10px]]|| | + | ||station_id||bigint(20)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO|| || ||Account STATION_ID |
|- | |- | ||
| − | ||csr||tinyint(1)||align="center"| ||align="center"| ||NO|| || || | + | ||csr||tinyint(1)||align="center"| ||align="center"| ||NO|| || ||Account flag (CSR) |
|- | |- | ||
| − | ||banned||tinyint(1)||align="center"| ||align="center"| ||NO|| || || | + | ||banned||tinyint(1)||align="center"| ||align="center"| ||NO|| || ||Account flag (Banned) |
|- | |- | ||
| − | ||email||char(64)||align="center"| ||align="center"| ||NO|| || || | + | ||email||char(64)||align="center"| ||align="center"| ||NO|| || ||Account email. |
|- | |- | ||
| − | ||joindate||datetime||align="center"| ||align="center"| ||NO | + | ||joindate||datetime||align="center"| ||align="center"| ||NO|| ||0000-00-00 00:00:00||Date/Time of account creation. |
|- | |- | ||
| − | ||lastlogin||timestamp||align="center"| ||align="center"| ||YES | + | ||lastlogin||timestamp||align="center"| ||align="center"| ||YES|| ||NULL||Date/Time of last login. |
|- | |- | ||
| − | ||active||tinyint(1)||align="center"| ||align="center"| ||YES | + | ||active||tinyint(1)||align="center"| ||align="center"| ||YES|| ||NULL||User account active. |
|- | |- | ||
| − | ||loggedin||int(1)||align="center"| ||align="center"| ||NO | + | ||loggedin||int(1)||align="center"| ||align="center"| ||NO|| ||0||Logged in. |
|- | |- | ||
| − | ||authenticated||tinyint(1)||align="center"| ||align="center"| ||NO|| ||0|| | + | ||authenticated||tinyint(1)||align="center"| ||align="center"| ||NO|| ||0||Authenicated with Login Server. |
|- | |- | ||
| − | ||characters_allowed||tinyint(3)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO | + | ||characters_allowed||tinyint(3)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO|| ||2||Number of characters allowed per galaxy. |
|- | |- | ||
|} | |} | ||
Revision as of 12:41, 5 June 2007
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
|
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)
