aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/0.10/5297_mangos.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates/0.10/5297_mangos.sql')
-rw-r--r--sql/updates/0.10/5297_mangos.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/0.10/5297_mangos.sql b/sql/updates/0.10/5297_mangos.sql
new file mode 100644
index 00000000000..e009a5b13ae
--- /dev/null
+++ b/sql/updates/0.10/5297_mangos.sql
@@ -0,0 +1,12 @@
+ALTER TABLE `game_event`
+ CHANGE COLUMN `start` `start_time` timestamp NOT NULL default '0000-00-00 00:00:00' COMMENT 'Absolute start date, the event will never start before',
+ CHANGE COLUMN `end` `end_time` timestamp NOT NULL default '0000-00-00 00:00:00' COMMENT 'Absolute end date, the event will never start afler';
+
+ALTER TABLE `pet_levelstats`
+ CHANGE COLUMN `int` `inte` smallint(5) unsigned NOT NULL;
+
+ALTER TABLE `player_levelstats`
+ CHANGE COLUMN `int` `inte` smallint(5) unsigned NOT NULL;
+
+ALTER TABLE `npc_option`
+ CHANGE COLUMN `option` `option_text` text; \ No newline at end of file