diff options
| author | Rat <none@none> | 2010-09-25 18:47:03 +0200 |
|---|---|---|
| committer | Rat <none@none> | 2010-09-25 18:47:03 +0200 |
| commit | 28e90bbb605ce95ec51c2c5cea9980473a4dbb05 (patch) | |
| tree | 0c19970109f4df03fa36f90f1d4b1f484e0cbf76 /sql/updates | |
| parent | 562e3955a9a4e0f2643b1002005b5a6d3244084c (diff) | |
Core/Scripts/SmartAI: added SmartAI files
Core/DBLayer/Texts: added CreatureTextMgr files
BuildSystem: added cmake for above files
Note: these are still under development and NOT USABLE
should not effect anything now
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/10060_world_creature_text.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/10060_world_creature_text.sql b/sql/updates/10060_world_creature_text.sql new file mode 100644 index 00000000000..665de9f67ad --- /dev/null +++ b/sql/updates/10060_world_creature_text.sql @@ -0,0 +1,15 @@ +DROP TABLE IF EXISTS `creature_text`; +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; |