From 28e90bbb605ce95ec51c2c5cea9980473a4dbb05 Mon Sep 17 00:00:00 2001 From: Rat Date: Sat, 25 Sep 2010 18:47:03 +0200 Subject: 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 --- sql/updates/10060_world_creature_text.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 sql/updates/10060_world_creature_text.sql (limited to 'sql/updates') 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; -- cgit v1.2.3