From fd34134a455314dcd404fd928453b816554bfb3f Mon Sep 17 00:00:00 2001 From: XTZGZoReX Date: Fri, 6 Aug 2010 16:28:17 +0200 Subject: * Add ScriptName to game_weather. --HG-- branch : trunk --- sql/base/world_database.sql | 1 + sql/updates/9195_world_game_weather.sql | 1 + 2 files changed, 2 insertions(+) create mode 100644 sql/updates/9195_world_game_weather.sql (limited to 'sql') 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`; -- cgit v1.2.3