Difference between revisions of "Character bind (Database Table)"

From SWGANH Wiki
Jump to: navigation, search
(New page: <pre> CREATE TABLE `character_bind` ( `id` bigint(20) NOT NULL auto_increment COMMENT 'ID', `character_id` bigint(20) unsigned NOT NULL COMMENT 'Character ID', `bank_planet_id` int(2...)
 
Line 1: Line 1:
 +
{{PageHeader|Database Table|biography_faction}}
 +
 +
{| 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)|| || || || ||[[Image:Symbol OK.png|10px]]||NULL||ID
 +
|- align="center" style="background-color:#F1F1F1;"
 +
|| || ||align="center"| ||align="center"| || || || ||
 +
|-
 +
|}
 +
|}
 +
 +
|valign=top|
 +
 +
== Related Tags ==
 +
{|align="center"
 +
|-
 +
||{{D25%}}
 +
|-
 +
||{{Database}}
 +
|-
 +
||{{DatabaseTable}}
 +
|-
 +
|}
 +
|}
 +
 +
==Table Create Script==
 
<pre>
 
<pre>
 
CREATE TABLE `character_bind` (
 
CREATE TABLE `character_bind` (
 
   `id` bigint(20) NOT NULL auto_increment COMMENT 'ID',
 
   `id` bigint(20) NOT NULL auto_increment COMMENT 'ID',
 
   `character_id` bigint(20) unsigned NOT NULL COMMENT 'Character ID',
 
   `character_id` bigint(20) unsigned NOT NULL COMMENT 'Character ID',
−
   `bank_planet_id` int(2) NOT NULL COMMENT 'Planet ID for Bank',
+
   `bank_planet_id` int(2) default NULL COMMENT 'Planet ID for Bank',
−
   `bind_oX` float(10,6) NOT NULL COMMENT 'X Location - Bind',
+
   `bind_oX` float(10,6) default NULL COMMENT 'X Location - Bind',
−
   `bind_oY` float(10,6) NOT NULL COMMENT 'Y Location - Bind',
+
   `bind_oY` float(10,6) default NULL COMMENT 'Y Location - Bind',
−
   `bind_oZ` float(10,6) NOT NULL COMMENT 'Z Location - Bind',
+
   `bind_oZ` float(10,6) default NULL COMMENT 'Z Location - Bind',
−
   `clone_city_id` int(10) unsigned NOT NULL COMMENT 'Clone City ID',
+
   `clone_city_id` int(10) unsigned default NULL COMMENT 'Clone City ID',
 
   PRIMARY KEY  (`id`),
 
   PRIMARY KEY  (`id`),
 
   KEY `FK_character_bind_1` (`character_id`),
 
   KEY `FK_character_bind_1` (`character_id`),
 
   KEY `FK_character_bind_2` (`bank_planet_id`),
 
   KEY `FK_character_bind_2` (`bank_planet_id`),
 
   KEY `FK_character_bind_3` (`clone_city_id`),
 
   KEY `FK_character_bind_3` (`clone_city_id`),
−
  CONSTRAINT `FK_character_bind_3` FOREIGN KEY (`clone_city_id`) REFERENCES `spawn_clone` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
 
 
   CONSTRAINT `FK_character_bind_1` FOREIGN KEY (`character_id`) REFERENCES `characters` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
 
   CONSTRAINT `FK_character_bind_1` FOREIGN KEY (`character_id`) REFERENCES `characters` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
−
   CONSTRAINT `FK_character_bind_2` FOREIGN KEY (`bank_planet_id`) REFERENCES `planet` (`planet_id`) ON DELETE CASCADE ON UPDATE CASCADE
+
   CONSTRAINT `FK_character_bind_2` FOREIGN KEY (`bank_planet_id`) REFERENCES `planet` (`planet_id`) ON DELETE CASCADE ON UPDATE CASCADE,
 +
  CONSTRAINT `FK_character_bind_3` FOREIGN KEY (`clone_city_id`) REFERENCES `spawn_clone` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Character Bind Data';
 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Character Bind Data';
 +
</pre>
 +
 +
==Table Describe==
 +
<pre>
 +
mysql> desc character_bind;
 +
+----------------+---------------------+------+-----+---------+----------------+
 +
| Field          | Type                | Null | Key | Default | Extra          |
 +
+----------------+---------------------+------+-----+---------+----------------+
 +
| id            | bigint(20)          | NO  | PRI | NULL    | auto_increment |
 +
| character_id  | bigint(20) unsigned | NO  | MUL |        |                |
 +
| bank_planet_id | int(2)              | NO  | MUL |        |                |
 +
| bind_oX        | float(10,6)        | NO  |    |        |                |
 +
| bind_oY        | float(10,6)        | NO  |    |        |                |
 +
| bind_oZ        | float(10,6)        | NO  |    |        |                |
 +
| clone_city_id  | int(10) unsigned    | NO  | MUL |        |                |
 +
+----------------+---------------------+------+-----+---------+----------------+
 +
7 rows in set (0.00 sec)
 
</pre>
 
</pre>

Revision as of 11:46, 7 September 2007

Database Table - biography_faction

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
id BIGINT(20) Symbol OK.png NULL ID

Related Tags

25% This document has been partially completed.

Database This document relates to the SWGANH Database Schema.

DB Table This document relates to the SWGANH Database Schema.

Table Create Script

CREATE TABLE `character_bind` (
  `id` bigint(20) NOT NULL auto_increment COMMENT 'ID',
  `character_id` bigint(20) unsigned NOT NULL COMMENT 'Character ID',
  `bank_planet_id` int(2) default NULL COMMENT 'Planet ID for Bank',
  `bind_oX` float(10,6) default NULL COMMENT 'X Location - Bind',
  `bind_oY` float(10,6) default NULL COMMENT 'Y Location - Bind',
  `bind_oZ` float(10,6) default NULL COMMENT 'Z Location - Bind',
  `clone_city_id` int(10) unsigned default NULL COMMENT 'Clone City ID',
  PRIMARY KEY  (`id`),
  KEY `FK_character_bind_1` (`character_id`),
  KEY `FK_character_bind_2` (`bank_planet_id`),
  KEY `FK_character_bind_3` (`clone_city_id`),
  CONSTRAINT `FK_character_bind_1` FOREIGN KEY (`character_id`) REFERENCES `characters` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_character_bind_2` FOREIGN KEY (`bank_planet_id`) REFERENCES `planet` (`planet_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_character_bind_3` FOREIGN KEY (`clone_city_id`) REFERENCES `spawn_clone` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Character Bind Data';

Table Describe

mysql> desc character_bind;
+----------------+---------------------+------+-----+---------+----------------+
| Field          | Type                | Null | Key | Default | Extra          |
+----------------+---------------------+------+-----+---------+----------------+
| id             | bigint(20)          | NO   | PRI | NULL    | auto_increment | 
| character_id   | bigint(20) unsigned | NO   | MUL |         |                | 
| bank_planet_id | int(2)              | NO   | MUL |         |                | 
| bind_oX        | float(10,6)         | NO   |     |         |                | 
| bind_oY        | float(10,6)         | NO   |     |         |                | 
| bind_oZ        | float(10,6)         | NO   |     |         |                | 
| clone_city_id  | int(10) unsigned    | NO   | MUL |         |                | 
+----------------+---------------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)
Retrieved from "http://wiki.swganh.org/index.php?title=Character_bind_(Database_Table)&oldid=15654"