Character bind (Database Table) - Revision history

Snow: /* Table Describe */

2007-09-07T18:27:05Z

‎Table Describe

Snow: /* Table Create Script */

2007-09-07T18:26:54Z

‎Table Create Script

Snow: /* Related Tags */

2007-09-07T18:22:24Z

‎Related Tags

Snow: /* Related Tags */

2007-09-07T17:39:47Z

‎Related Tags

Snow: /* Table Structure */

2007-09-07T17:39:35Z

‎Table Structure

Snow at 15:46, 7 September 2007

2007-09-07T15:46:41Z

Snow: New page:

 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...

2007-09-07T15:32:10Z

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...

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) NOT NULL COMMENT 'Planet ID for Bank',
`bind_oX` float(10,6) NOT NULL COMMENT 'X Location - Bind',
`bind_oY` float(10,6) NOT NULL COMMENT 'Y Location - Bind',
`bind_oZ` float(10,6) NOT NULL COMMENT 'Z Location - Bind',
`clone_city_id` int(10) unsigned NOT 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_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_2` FOREIGN KEY (`bank_planet_id`) REFERENCES `planet` (`planet_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Character Bind Data';
</pre>

@@ Line 72: / Line 72: @@
 | id             | bigint(20)          | NO   | PRI | NULL    | auto_increment |
 | character_id   | bigint(20) unsigned | NO   | MUL |         |                |
-| bank_planet_id | int(2)              | NO   | MUL |         |                |
+| bank_planet_id | int(2)              | YES  | MUL | 255     |                |
-| bind_oX        | float(10,6)         | NO   |     |         |                |
+| bind_oX        | float(10,6)         | YES  |     | NULL    |                |
-| bind_oY        | float(10,6)         | NO   |     |         |                |
+| bind_oY        | float(10,6)         | YES  |     | NULL    |                |
-| bind_oZ        | float(10,6)         | NO   |     |         |                |
+| bind_oZ        | float(10,6)         | YES  |     | NULL    |                |
-| clone_city_id  | int(10) unsigned    | NO   | MUL |         |                |
+| clone_city_id  | int(10) unsigned    | YES  | MUL | NULL    |                |
 +----------------+---------------------+------+-----+---------+----------------+
 rows in set (0.00 sec)
 </pre>

@@ Line 49: / Line 49: @@
    `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',
+   `bank_planet_id` int(2) default '255' 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',

@@ Line 35: / Line 35: @@
 {|align="center"
 |-
-||{{D75%}}
+||{{D100%}}
 |-
 ||{{Database}}

@@ Line 35: / Line 35: @@
 {|align="center"
 |-
-||{{D25%}}
+||{{D75%}}
 |-
 ||{{Database}}

@@ Line 13: / Line 13: @@
 ||'''Field'''||'''Type'''||'''Unsigned'''||'''Autoinc'''||'''Null'''||'''Key'''||'''Default Value'''||'''Description'''
 |- align="center"
-|align="left"|id||BIGINT(20)|| || || || ||[[Image:Symbol OK.png|10px]]||NULL||ID
+|align="left"|id||BIGINT(20)|| || || ||[[Image:Symbol OK.png|10px]]||NULL||ID
 |- align="center" style="background-color:#F1F1F1;"
-|| || ||align="center"| ||align="center"| || || || ||
+|align="left"|character_id||BIGINT(20)||[[Image:Symbol OK.png|10px]]||[[Image:Symbol OK.png|10px]]||[[Image:Symbol OK.png|10px]]|| || ||Character ID (swganh.characters)
 |-
 |}

@@ Line 1: / Line 1: @@
 <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) 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`),
    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_2` FOREIGN KEY (`bank_planet_id`) REFERENCES `planet` (`planet_id`) ON DELETE CASCADE ON UPDATE CASCADE,
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Character Bind Data';
 </pre>