diff options
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/world_database.sql | 48 |
1 files changed, 24 insertions, 24 deletions
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 */; |