Character bind (Database Table)

From SWGANH Wiki
Revision as of 10:32, 7 September 2007 by Snow (Talk | contribs) (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...)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
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';