From e3648f01049495a758b7be6c430b3508ad8526cd Mon Sep 17 00:00:00 2001
From: Shocker <none@none>
Date: Sat, 25 Sep 2010 19:53:08 +0300
Subject: SQL: Add SQL data from previous commit to world base

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

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

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 43ec1457c75..e81d0c0df52 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -1731,6 +1731,38 @@ LOCK TABLES `creature_template_addon` WRITE;
 /*!40000 ALTER TABLE `creature_template_addon` ENABLE KEYS */;
 UNLOCK TABLES;
 
+--
+-- Table structure for table `creature_text`
+--
+
+DROP TABLE IF EXISTS `creature_text`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `creature_text` (
+  `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `id` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `text` longtext,
+  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `language` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `probability` float NOT NULL DEFAULT '0',
+  `emote` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `duration` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `sound` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `comment` varchar(255) DEFAULT '',
+  PRIMARY KEY (`entry`,`groupid`,`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `creature_text`
+--
+
+LOCK TABLES `creature_text` WRITE;
+/*!40000 ALTER TABLE `creature_text` DISABLE KEYS */;
+/*!40000 ALTER TABLE `creature_text` ENABLE KEYS */;
+UNLOCK TABLES;
+
 --
 -- Table structure for table `creature_transport`
 --
-- 
cgit v1.2.3

