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

2010-03-13T04:52:21Z

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

New page

{{PageHeader|Database Table|character_skills}}

{| 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"|id||bigint(20)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"|[[Image:Symbol OK.png|10px]]||NO||Primary||NULL||Character ID
|- align="center" style="background-color:#F1F1F1;"
|align="left"|account_id||bigint(20)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO|| ||0||Account ID
|- align="center"
|align="left"|galaxy_id||int(5)||align="center"| ||align="center"| ||YES|| ||0||Galaxy ID
|- align="center" style="background-color:#F1F1F1;"
|align="left"|firstname||char(32)||align="center"| ||align="center"| ||YES||Unique||NULL||Character First Name
|- align="center"
|align="left"|lastname||char(32)||align="center"| ||align="center"| ||YES|| ||NULL||Character Last Name
|- align="center" style="background-color:#F1F1F1;"
|align="left"|race_id||int(8)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||YES|| ||0||Race ID
|- align="center"
|align="left"|parent_id||bigint(20)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||YES|| ||0||Parent ID
|- align="center" style="background-color:#F1F1F1;"
|align="left"|planet_id||int(2)||align="center"| ||align="center"| ||NO|| ||1||Planet ID
|- align="center"
|align="left"|x||float(10,6)||align="center"| ||align="center"| ||YES|| ||NULL||
|- align="center" style="background-color:#F1F1F1;"
|align="left"|y||float(10,6)||align="center"| ||align="center"| ||YES|| ||NULL||
|- align="center"
|align="left"|z||float(10,6)||align="center"| ||align="center"| ||YES|| ||NULL||
|- align="center" style="background-color:#F1F1F1;"
|align="left"|oX||float(10,6)||align="center"| ||align="center"| ||YES|| ||NULL||
|- align="center"
|align="left"|oY||float(10,6)||align="center"| ||align="center"| ||YES|| ||NULL||
|- align="center" style="background-color:#F1F1F1;"
|align="left"|oZ||float(10,6)||align="center"| ||align="center"| ||YES|| ||NULL||
|- align="center"
|align="left"|oW||float(10,6)||align="center"| ||align="center"| ||YES|| ||NULL||
|- align="center" style="background-color:#F1F1F1;"
|align="left"|archived||tinyint(1)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO|| ||0||
|- align="center"
|align="left"|deletiondate||date||align="center"| ||align="center"| ||YES|| ||NULL||Deletion Date
|- align="center" style="background-color:#F1F1F1;"
|align="left"|jedistate||int(11)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO|| ||0||Character Jedi State
|- align="center"
|align="left"|bornyear||char(8)||align="center"| ||align="center"| ||YES|| ||NULL||Born Year
|}
|}

|valign=top|

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

==Table Create Script==
<pre>
DROP TABLE IF EXISTS `characters`;
CREATE TABLE `characters` (
`id` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Unique ID',
`account_id` bigint(20) unsigned NOT NULL default '0' COMMENT 'Ties to the ACCOUNT Table',
`galaxy_id` int(5) default '0' COMMENT 'Ties to the GALAXY Table',
`firstname` char(32) default NULL COMMENT 'Character Firstname',
`lastname` char(32) default NULL COMMENT 'Character Lastname',
`race_id` int(8) unsigned default '0' COMMENT 'Ties to the RACE Table',
`parent_id` bigint(20) unsigned default '0' COMMENT 'Ties to ... (Cell)',
`planet_id` int(2) NOT NULL default '1' COMMENT 'Current Planet - Defualt Corellia',
`x` float(10,6) default NULL COMMENT 'Character X Location',
`y` float(10,6) default NULL COMMENT 'Character Y Location',
`z` float(10,6) default NULL COMMENT 'Character Z Location',
`oX` float(10,6) default NULL COMMENT 'Character Cell X Location',
`oY` float(10,6) default NULL COMMENT 'Character Cell Y Location',
`oZ` float(10,6) default NULL COMMENT 'Character Cell Z Location',
`oW` float(10,6) default NULL COMMENT 'Character Cell Orientation',
`archived` tinyint(1) unsigned default '0' COMMENT '0 = active / 1 = scheduled to be deleted',
`deletiondate` date default NULL COMMENT 'DATE to be deleted',
`jedistate` int(11) unsigned NOT NULL default '0',
`bornyear` char(8) DEFAULT NULL COMMENT 'Year character was created.',
PRIMARY KEY (`id`),
UNIQUE KEY `pk_firstname` (`firstname`),
KEY `fk_character_acc_acc` (`account_id`),
KEY `fk_character_gal_gal` (`galaxy_id`),
KEY `fk_character_race_race` (`race_id`),
KEY `fk_character_planetid_planetid` (`planet_id`),
KEY `FK_characters_jedistate_state` (`jedistate`),
CONSTRAINT `characters_ibfk_1` FOREIGN KEY (`planet_id`) REFERENCES `planet` (`planet_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `characters_ibfk_2` FOREIGN KEY (`account_id`) REFERENCES `account` (`account_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `characters_ibfk_3` FOREIGN KEY (`galaxy_id`) REFERENCES `galaxy` (`galaxy_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `characters_ibfk_4` FOREIGN KEY (`race_id`) REFERENCES `race` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_characters_jedistate_state` FOREIGN KEY (`jedistate`) REFERENCES `skills_jedi_states` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8589935594 DEFAULT CHARSET=utf8;
</pre>

==Table Describe==
<pre>
mysql> describe characters;
+--------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+---------------------+------+-----+---------+----------------+
| id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| account_id | bigint(20) unsigned | NO | MUL | 0 | |
| galaxy_id | int(5) | YES | MUL | 0 | |
| firstname | char(32) | YES | UNI | NULL | |
| lastname | char(32) | YES | | NULL | |
| race_id | int(8) unsigned | YES | MUL | 0 | |
| parent_id | bigint(20) unsigned | YES | | 0 | |
| planet_id | int(2) | NO | MUL | 1 | |
| x | float(10,6) | YES | | NULL | |
| y | float(10,6) | YES | | NULL | |
| z | float(10,6) | YES | | NULL | |
| oX | float(10,6) | YES | | NULL | |
| oY | float(10,6) | YES | | NULL | |
| oZ | float(10,6) | YES | | NULL | |
| oW | float(10,6) | YES | | NULL | |
| archived | tinyint(1) unsigned | YES | | 0 | |
| deletiondate | date | YES | | NULL | |
| jedistate | int(11) unsigned | NO | MUL | 0 | |
| bornyear | char(8) | YES | | NULL | |
+--------------+---------------------+------+-----+---------+----------------+
19 rows in set (0.14 sec)
</pre>

Characters (Database Table) - Revision history

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