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

Table Structure Field Type Unsigned Autoinc Null Key Default Value Description id BIGINT(20) NULL ID character_id BIGINT(20) Character ID (swganh.characters) bank_planet_id INT(2) NULL Planet ID (swganh.planets) bind_oX FLOAT(10,6) NULL Bind Location X bind_oY FLOAT(10,6) NULL Bind Location Y bind_oZ FLOAT(10,6) NULL Bind Location Z clone_city_id INT(10) NULL Clone Location (swganh.spawn_clone)

Related Tags 100% This document is complete. 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 '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',
  `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)              | YES  | MUL | 255     |                | 
| bind_oX        | float(10,6)         | YES  |     | NULL    |                | 
| bind_oY        | float(10,6)         | YES  |     | NULL    |                | 
| bind_oZ        | float(10,6)         | YES  |     | NULL    |                | 
| clone_city_id  | int(10) unsigned    | YES  | MUL | NULL    |                | 
+----------------+---------------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)