aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorclick <none@none>2010-04-22 16:22:39 +0200
committerclick <none@none>2010-04-22 16:22:39 +0200
commitab396beb56b74bc18922055d89230f0b3b19312b (patch)
treea7a7313538648fa69f070bde266d7f0cb047ccd7 /sql/updates
parentca2b52af0d4ca8d2c2d3615bac2db67778af07e7 (diff)
Add support for season-dependant gameevents
Patch by Liberate --HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/7981_world_season_linked_event.sql7
1 files changed, 7 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;