From 45db1591a4959ca9d58fc40ea2294936bcf4bd10 Mon Sep 17 00:00:00 2001
From: Nay <dnpd.dd@gmail.com>
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/world_database.sql')

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

