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...)
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';