Difference between revisions of "Account (Database Table)"
From SWGANH Wiki
(New page: {{PageHeader|Database Table|Accounts}} ==Table Structure== {| class = "wikitable" |- ||'''Field'''||'''Type'''||'''unsigned'''||'''autoinc'''||'''Null'''||'''Key'''||'''Default Value'''|...) |
|||
| Line 2: | Line 2: | ||
==Table Structure== | ==Table Structure== | ||
| − | + | {| align="center" | |
| + | |- | ||
{| class = "wikitable" | {| class = "wikitable" | ||
|- | |- | ||
| Line 10: | Line 11: | ||
|- | |- | ||
|} | |} | ||
| − | + | |} | |
==Table Create Script== | ==Table Create Script== | ||
Revision as of 11:36, 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
| Field | Type | unsigned | autoinc | Null | Key | Default Value | Description |
| account_id | bigint(20) | X | X | NO | Primary | Null | Account ID |
Table Create Script
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)
