diff options
| author | silinoron <none@none> | 2010-07-30 22:04:01 -0700 |
|---|---|---|
| committer | silinoron <none@none> | 2010-07-30 22:04:01 -0700 |
| commit | 0f99c2feb6fb0b2df4fc58666292c4ce56b4e9fa (patch) | |
| tree | cf2e3d4c8d52e467769e19843d5ad851bc6e386a | |
| parent | 71b1c781e3d05bf208c4b0886a1c8f0f474d6a10 (diff) | |
Some forgotten changes.
--HG--
branch : trunk
| -rw-r--r-- | THANKS | 3 | ||||
| -rw-r--r-- | sql/base/world_database.sql | 30 |
2 files changed, 32 insertions, 1 deletions
@@ -64,4 +64,5 @@ footman, elron103, make_the_king, destros, MetaphysicalDrama, disassebler, Malcrom, Vladmimír Lipták, retriman, hyriuu, Smakapotatis, PainKiller, bkhorizon, n0n4m3, Chesterfield, Frankir, Wowka321, Morpheux, p0wer, Ouden, toshik, laise, yavi, Splinter, Syntec, Arthas, denyde, unholy, -Vaughner, blackmanos, edrinn, Supabad, click, silverice, SupaBad, Xanadu +Vaughner, blackmanos, edrinn, Supabad, click, silverice, SupaBad, Xanadu, +Socolin 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 @@ -1715,6 +1715,36 @@ LOCK TABLES `creature_template_addon` WRITE; 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` -- |