diff options
| author | Shocker <none@none> | 2010-09-25 19:53:08 +0300 |
|---|---|---|
| committer | Shocker <none@none> | 2010-09-25 19:53:08 +0300 |
| commit | e3648f01049495a758b7be6c430b3508ad8526cd (patch) | |
| tree | 076102d9dc31b0200490d1c7831636a825f90036 | |
| parent | 28e90bbb605ce95ec51c2c5cea9980473a4dbb05 (diff) | |
SQL: Add SQL data from previous commit to world base
--HG--
branch : trunk
| -rw-r--r-- | sql/base/world_database.sql | 32 |
1 files changed, 32 insertions, 0 deletions
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 @@ -1732,6 +1732,38 @@ LOCK TABLES `creature_template_addon` WRITE; 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` -- |