From 0f99c2feb6fb0b2df4fc58666292c4ce56b4e9fa Mon Sep 17 00:00:00 2001
From: silinoron <none@none>
Date: Fri, 30 Jul 2010 22:04:01 -0700
Subject: Some forgotten changes.

--HG--
branch : trunk
---
 sql/base/world_database.sql | 30 ++++++++++++++++++++++++++++++
 1 file changed, 30 insertions(+)

(limited to 'sql/base/world_database.sql')

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index d4af498680a..e1cba235b08 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -1714,6 +1714,36 @@ LOCK TABLES `creature_template_addon` WRITE;
 /*!40000 ALTER TABLE `creature_template_addon` ENABLE KEYS */;
 UNLOCK TABLES;
 
+--
+-- Table structure for table `creature_transport`
+--
+
+DROP TABLE IF EXISTS `creature_transport`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+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;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `creature_transport`
+--
+
+LOCK TABLES `creature_transport` WRITE;
+/*!40000 ALTER TABLE `creature_transport` DISABLE KEYS */;
+/*!40000 ALTER TABLE `creature_transport` ENABLE KEYS */;
+UNLOCK TABLES;
+
 --
 -- Table structure for table `custom_texts`
 --
-- 
cgit v1.2.3

