Account (Database Table) - Revision history

Berix: /* Table Create Script */

2010-05-09T22:06:38Z

‎Table Create Script

Snow: /* Table Structure */

2008-12-26T17:49:26Z

‎Table Structure

Snow: /* Table Structure */

2008-12-26T17:49:07Z

‎Table Structure

Snow: /* Table Structure */

2008-12-26T17:48:47Z

‎Table Structure

Snow: /* Table Describe */

2008-12-26T17:47:49Z

‎Table Describe

Snow: /* Table Create Script */

2008-12-26T17:47:14Z

‎Table Create Script

Snow: /* Table Structure */

2008-01-06T21:30:42Z

‎Table Structure

Snow at 21:29, 6 January 2008

2008-01-06T21:29:05Z

Snow: /* Table Structure */

2008-01-06T21:28:44Z

‎Table Structure

Snow: /* Table Create Script */

2008-01-06T21:28:25Z

‎Table Create Script

@@ Line 77: / Line 77: @@
    PRIMARY KEY  (`account_id`),
    UNIQUE KEY `username` (`username`)
-) ENGINE=InnoDB EFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 </pre>

@@ Line 33: / Line 33: @@
 |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"| ||YES|| || ||Authenicated with Login Server.
+|align="left"|authenticated||tinyint(1)||align="center"| ||align="center"| ||YES|| ||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.
 |- align="center" style="background-color:#F1F1F1;"
-|align="left"|session_key||varchar(32)||align="center"| ||align="center"| ||NO|| ||0||Launcher session key
+|align="left"|session_key||varchar(32)||align="center"| ||align="center"| ||NO|| || ||Launcher session key
 |-
 |}

@@ Line 33: / Line 33: @@
 |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="left"|authenticated||tinyint(1)||align="center"| ||align="center"| ||YES|| || ||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.

@@ Line 36: / Line 36: @@
 |- align="center"
 |align="left"|characters_allowed||tinyint(3)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO|| ||2||Characters allowed per galaxy.
 |-
 |}

@@ Line 84: / Line 84: @@
 | 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   |     |                     |                |
+| 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                   |                |
 +--------------------+---------------------+------+-----+---------------------+----------------+
-rows in set (0.00 sec)
+rows in set (0.01 sec)
 </pre>

@@ Line 60: / Line 60: @@
 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',
+   `username` char(32) NOT NULL default '' COMMENT 'Account username',
-   `password` char(32) character set latin1 NOT NULL default '' COMMENT 'Account password',
+   `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) character set latin1 NOT NULL default '' COMMENT 'Account - User email',
+   `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',
@@ Line 72: / Line 72: @@
    `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 AUTO_INCREMENT=710 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB EFAULT CHARSET=utf8;
 </pre>

@@ Line 9: / Line 9: @@
 {| 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

@@ Line 1: / Line 1: @@
 {{PageHeader|Database Table|Accounts}}
 {| border="0" width="90%" cellpadding=6
 |-
 |valign=top|
 ==Table Structure==
 {| align="center"