aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/world_database.sql1
-rw-r--r--sql/updates/9195_world_game_weather.sql1
2 files changed, 2 insertions, 0 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 2f2fb86997e..100a578f60b 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -2372,6 +2372,7 @@ CREATE TABLE `game_weather` (
`winter_rain_chance` tinyint(3) unsigned NOT NULL DEFAULT '25',
`winter_snow_chance` tinyint(3) unsigned NOT NULL DEFAULT '25',
`winter_storm_chance` tinyint(3) unsigned NOT NULL DEFAULT '25',
+ `ScriptName` char(64) NOT NULL DEFAULT '',
PRIMARY KEY (`zone`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Weather System';
/*!40101 SET character_set_client = @saved_cs_client */;
diff --git a/sql/updates/9195_world_game_weather.sql b/sql/updates/9195_world_game_weather.sql
new file mode 100644
index 00000000000..355c49e7640
--- /dev/null
+++ b/sql/updates/9195_world_game_weather.sql
@@ -0,0 +1 @@
+ALTER TABLE `game_weather` ADD `ScriptName` char(64) NOT NULL DEFAULT '' AFTER `winter_storm_chance`;