diff options
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; |