Snow at 00:08, 17 June 2008

2008-06-17T00:08:11Z

Snow at 00:07, 17 June 2008

2008-06-17T00:07:44Z

Ready at 05:59, 24 February 2008

2008-02-24T05:59:20Z

Snow: New page: {{PageHeader|Database Table|Accounts}} {| border="0" width="90%" cellpadding=6 |- |valign=top| ==Table Structure== {| align="center" |- || {| class = "wikitable" |- align="center" style...

2007-09-03T05:46:27Z

New page: {{PageHeader|Database Table|Accounts}} {| border="0" width="90%" cellpadding=6 |- |valign=top| ==Table Structure== {| align="center" |- || {| class = "wikitable" |- align="center" style...

New page

{{PageHeader|Database Table|Accounts}}

{| border="0" width="90%" cellpadding=6
|-
|valign=top|

==Table Structure==
{| align="center"
|-
||
{| class = "wikitable"
|- align="center" style="background-color:#ffffcc;"
||'''Field'''||'''Type'''||'''Unsigned'''||'''Autoinc'''||'''Null'''||'''Key'''||'''Default Value'''||'''Description'''
|- align="center"
|align="left"|account_id||bigint(20)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"|[[Image:Symbol OK.png|10px]]||NO||Primary||Null||Account ID
|- align="center" style="background-color:#F1F1F1;"
|align="left"|username||char(32)||align="center"| ||align="center"| ||NO||Unique|| ||Account Username
|- align="center"
|align="left"|password||char(32)||align="center"| ||align="center"| ||NO|| || ||Account Password (MD5)
|- align="center" style="background-color:#F1F1F1;"
|align="left"|station_id||bigint(20)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO|| || ||Account STATION_ID
|- align="center"
|align="left"|csr||tinyint(1)||align="center"| ||align="center"| ||NO|| || ||Account flag (CSR)
|- align="center" style="background-color:#F1F1F1;"
|align="left"|banned||tinyint(1)||align="center"| ||align="center"| ||NO|| || ||Account flag (Banned)
|- align="center"
|align="left"|email||char(64)||align="center"| ||align="center"| ||NO|| || ||Account email.
|- align="center" style="background-color:#F1F1F1;"
|align="left"|joindate||datetime||align="center"| ||align="center"| ||NO|| ||0000-00-00 00:00:00||Date/Time of account creation.
|- align="center"
|align="left"|lastlogin||timestamp||align="center"| ||align="center"| ||YES|| ||NULL||Date/Time of last login.
|- align="center" style="background-color:#F1F1F1;"
|align="left"|active||tinyint(1)||align="center"| ||align="center"| ||YES|| ||NULL||User account active.
|- align="center"
|align="left"|loggedin||int(1)||align="center"| ||align="center"| ||NO|| ||0||Logged in.
|- align="center" style="background-color:#F1F1F1;"
|align="left"|authenticated||tinyint(1)||align="center"| ||align="center"| ||NO|| ||0||Authenicated with Login Server.
|- align="center"
|align="left"|characters_allowed||tinyint(3)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO|| ||2||Characters allowed per galaxy.
|-
|}
|}
|valign=top|

== Related Tags ==
{|align="center"
|-
||{{D75%}}
|-
||{{Database}}
|-
||{{DatabaseTable}}
|-
|}
|}

==Table Create Script==
<pre>
--
-- 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;

</pre>

==Table Describe==
<pre>
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)
</pre>

← Older revision		Revision as of 05:59, 24 February 2008
Line 1:		Line 1:
		+	{{PageCleanup}}
	{{PageHeader\|Database Table\|Accounts}}		{{PageHeader\|Database Table\|Accounts}}

@@ Line 12: / Line 12: @@
 {| class = "anhsmalltable"
 |-  align="center" style="background-color:#ffffcc;"
-||'''Field'''||'''Type'''||'''Unsigned'''||'''Autoinc'''||'''Null'''||'''Key'''||'''Default Value'''||'''Description'''
+|width="100px"|'''Field'''||width="60px"|'''Type'''||width="60px"|'''Unsigned'''||width="60px"|'''Autoinc'''||width="40px"|'''Null'''||width="40px"|'''Key'''||width="100px"|'''Default Value'''||width="200px"|'''Description'''
 |- align="center"
 |align="left"|account_id||bigint(20)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"|[[Image:Symbol OK.png|10px]]||NO||Primary||Null||Account ID

Database Table Template - Revision history

Snow at 00:08, 17 June 2008

Snow at 00:07, 17 June 2008

Ready at 05:59, 24 February 2008

Snow: New page: {{PageHeader|Database Table|Accounts}} {| border="0" width="90%" cellpadding=6 |- |valign=top| ==Table Structure== {| align="center" |- || {| class = "wikitable" |- align="center" style...