Add support for season-dependant gameevents

Patch by Liberate

--HG--
branch : trunk

2 files changed, 31 insertions, 0 deletions

diff --git a/sql/updates/7981_world_season_linked_event.sql b/sql/updates/7981_world_season_linked_event.sql
new file mode 100644
index 00000000000..94e47e91523
--- /dev/null
+++ b/sql/updates/7981_world_season_linked_event.sql
@@ -0,0 +1,7 @@
+DROP TABLE IF EXISTS `season_linked_event`;

+CREATE TABLE `season_linked_event` (

+ `season` int(3) UNSIGNED NOT NULL default '0',

+ `event` int(8) UNSIGNED NOT NULL default '0',

+ PRIMARY KEY (`season`),

+ UNIQUE (`season`,`event`)

+) ENGINE=InnoDB DEFAULT CHARSET=utf8;

diff --git a/sql/world.sql b/sql/world.sql
index ea0074b0fcf..1129e9596e4 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -4642,6 +4642,30 @@ LOCK TABLES `script_waypoint` WRITE;
 UNLOCK TABLES;
 
 --
+-- Table structure for table `season_linked_event`
+--
+
+DROP TABLE IF EXISTS `season_linked_event`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `season_linked_event` (
+ `season` int(3) UNSIGNED NOT NULL default '0',
+ `event` int(8) UNSIGNED NOT NULL default '0',
+ PRIMARY KEY (`season`),
+ UNIQUE (`season`,`event`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `season_linked_event`
+--
+
+LOCK TABLES `season_linked_event` WRITE;
+/*!40000 ALTER TABLE `season_linked_event` DISABLE KEYS */;
+/*!40000 ALTER TABLE `season_linked_event` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
 -- Table structure for table `skill_discovery_template`
 --