DB/Schema: Properly use field types in smart_script table

Thanks Shauren

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 */;