diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/9109_world_creature_transport.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/9109_world_creature_transport.sql b/sql/updates/9109_world_creature_transport.sql new file mode 100644 index 00000000000..06798af8a16 --- /dev/null +++ b/sql/updates/9109_world_creature_transport.sql @@ -0,0 +1,12 @@ +CREATE TABLE IF NOT EXISTS `creature_transport` ( + `guid` int(16) NOT NULL AUTO_INCREMENT COMMENT 'GUID of NPC on transport - not the same as creature.guid', + `transport_entry` int(8) NOT NULL COMMENT 'Transport entry', + `npc_entry` int(8) NOT NULL COMMENT 'NPC entry', + `TransOffsetX` float NOT NULL DEFAULT '0', + `TransOffsetY` float NOT NULL DEFAULT '0', + `TransOffsetZ` float NOT NULL DEFAULT '0', + `TransOffsetO` float NOT NULL DEFAULT '0', + `emote` int(16) NOT NULL, + PRIMARY KEY (`transport_entry`,`guid`), + UNIQUE KEY `entry` (`transport_entry`,`guid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |