From 45db1591a4959ca9d58fc40ea2294936bcf4bd10 Mon Sep 17 00:00:00 2001 From: Nay Date: Sun, 20 Feb 2011 19:11:42 +0000 Subject: DB/Schema: Properly use field types in smart_script table Thanks Shauren --- sql/base/world_database.sql | 48 ++++++++++++++++++++++----------------------- 1 file changed, 24 insertions(+), 24 deletions(-) (limited to 'sql/base') diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index f9689f9a1d8..9aa2cc087b3 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -16737,34 +16737,34 @@ DROP TABLE IF EXISTS `smart_scripts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `smart_scripts` ( - `entryorguid` mediumint(11) NOT NULL, - `source_type` mediumint(5) unsigned NOT NULL DEFAULT '0', - `id` mediumint(11) unsigned NOT NULL DEFAULT '0', - `link` mediumint(11) unsigned NOT NULL DEFAULT '0', - `event_type` mediumint(5) unsigned NOT NULL DEFAULT '0', - `event_phase_mask` mediumint(11) unsigned NOT NULL DEFAULT '0', - `event_chance` mediumint(5) unsigned NOT NULL DEFAULT '100', - `event_flags` mediumint(11) unsigned NOT NULL DEFAULT '0', - `event_param1` mediumint(11) unsigned NOT NULL DEFAULT '0', - `event_param2` mediumint(11) unsigned NOT NULL DEFAULT '0', - `event_param3` mediumint(11) unsigned NOT NULL DEFAULT '0', - `event_param4` mediumint(11) unsigned NOT NULL DEFAULT '0', - `action_type` mediumint(5) unsigned NOT NULL DEFAULT '0', - `action_param1` mediumint(11) unsigned NOT NULL DEFAULT '0', - `action_param2` mediumint(11) unsigned NOT NULL DEFAULT '0', - `action_param3` mediumint(11) unsigned NOT NULL DEFAULT '0', - `action_param4` mediumint(11) unsigned NOT NULL DEFAULT '0', - `action_param5` mediumint(11) unsigned NOT NULL DEFAULT '0', - `action_param6` mediumint(11) unsigned NOT NULL DEFAULT '0', - `target_type` mediumint(11) unsigned NOT NULL DEFAULT '0', - `target_param1` mediumint(11) unsigned NOT NULL DEFAULT '0', - `target_param2` mediumint(11) unsigned NOT NULL DEFAULT '0', - `target_param3` mediumint(11) unsigned NOT NULL DEFAULT '0', + `entryorguid` int(11) NOT NULL, + `source_type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `id` smallint(5) unsigned NOT NULL DEFAULT '0', + `link` smallint(5) unsigned NOT NULL DEFAULT '0', + `event_type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `event_phase_mask` tinyint(3) unsigned NOT NULL DEFAULT '0', + `event_chance` tinyint(3) unsigned NOT NULL DEFAULT '100', + `event_flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `event_param1` int(10) unsigned NOT NULL DEFAULT '0', + `event_param2` int(10) unsigned NOT NULL DEFAULT '0', + `event_param3` int(10) unsigned NOT NULL DEFAULT '0', + `event_param4` int(10) unsigned NOT NULL DEFAULT '0', + `action_type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `action_param1` int(10) unsigned NOT NULL DEFAULT '0', + `action_param2` int(10) unsigned NOT NULL DEFAULT '0', + `action_param3` int(10) unsigned NOT NULL DEFAULT '0', + `action_param4` int(10) unsigned NOT NULL DEFAULT '0', + `action_param5` int(10) unsigned NOT NULL DEFAULT '0', + `action_param6` int(10) unsigned NOT NULL DEFAULT '0', + `target_type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `target_param1` int(10) unsigned NOT NULL DEFAULT '0', + `target_param2` int(10) unsigned NOT NULL DEFAULT '0', + `target_param3` int(10) unsigned NOT NULL DEFAULT '0', `target_x` float NOT NULL DEFAULT '0', `target_y` float NOT NULL DEFAULT '0', `target_z` float NOT NULL DEFAULT '0', `target_o` float NOT NULL DEFAULT '0', - `comment` varchar(255) NOT NULL DEFAULT '' COMMENT 'Event Comment', + `comment` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'Event Comment', PRIMARY KEY (`entryorguid`,`source_type`,`id`,`link`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; /*!40101 SET character_set_client = @saved_cs_client */; -- cgit v1.2.3