From 14372d757d5f6912d44daa61919789adec8aa2cf Mon Sep 17 00:00:00 2001
From: SnapperRy <snapperryen@gmail.com>
Date: Sat, 29 Oct 2016 02:26:07 +0200
Subject: DB/Events: update event start dates and fix some wrong event
 durations.

Note: with the current event system, start dates for all events have to be updated at least once every four years in order to be correct (thanks to leap years).
(cherry picked from commit 5c06a5e8eb108a3b60c77b10a71e846d82d410a5)
---
 .../2017_11_11_01_world_2016_10_29_00_world.sql    | 43 ++++++++++++++++++++++
 1 file changed, 43 insertions(+)
 create mode 100644 sql/updates/world/master/2017_11_11_01_world_2016_10_29_00_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/master/2017_11_11_01_world_2016_10_29_00_world.sql b/sql/updates/world/master/2017_11_11_01_world_2016_10_29_00_world.sql
new file mode 100644
index 00000000000..16f6b661ea4
--- /dev/null
+++ b/sql/updates/world/master/2017_11_11_01_world_2016_10_29_00_world.sql
@@ -0,0 +1,43 @@
+--
+UPDATE `game_event` SET `start_time`="2017-06-21 00:01:00" WHERE `eventEntry`=1;
+UPDATE `game_event` SET `start_time`="2016-12-16 06:00:00" WHERE `eventEntry`=2;
+UPDATE `game_event` SET `start_time`="2016-11-06 00:01:00" WHERE `eventEntry`=3;
+UPDATE `game_event` SET `start_time`="2016-12-04 00:01:00" WHERE `eventEntry`=4;
+UPDATE `game_event` SET `start_time`="2017-01-01 00:01:00" WHERE `eventEntry`=5;
+UPDATE `game_event` SET `start_time`="2016-12-31 06:00:00", `length`=1440 WHERE `eventEntry`=6;
+UPDATE `game_event` SET `start_time`="2017-01-21 00:01:00" WHERE `eventEntry`=7;
+UPDATE `game_event` SET `start_time`="2017-02-07 00:01:00" WHERE `eventEntry`=8;
+UPDATE `game_event` SET `start_time`="2017-03-17 00:01:00" WHERE `eventEntry`=9;
+UPDATE `game_event` SET `start_time`="2017-05-01 00:01:00" WHERE `eventEntry`=10;
+UPDATE `game_event` SET `start_time`="2017-09-29 00:01:00" WHERE `eventEntry`=11;
+UPDATE `game_event` SET `start_time`="2017-10-18 01:00:00" WHERE `eventEntry`=12;
+UPDATE `game_event` SET `start_time`="2016-10-29 00:00:00" WHERE `eventEntry`=14;
+UPDATE `game_event` SET `start_time`="2016-10-30 14:00:00" WHERE `eventEntry`=15;
+UPDATE `game_event` SET `start_time`="2016-10-29 03:00:00" WHERE `eventEntry`=16;
+UPDATE `game_event` SET `start_time`="2016-11-25 00:01:00", `length`=5760 WHERE `eventEntry`=18;
+UPDATE `game_event` SET `start_time`="2016-12-02 00:01:00", `length`=5760 WHERE `eventEntry`=19;
+UPDATE `game_event` SET `start_time`="2016-11-11 00:01:00", `length`=5760 WHERE `eventEntry`=20;
+UPDATE `game_event` SET `start_time`="2016-11-18 00:01:00", `length`=5760 WHERE `eventEntry`=21;
+UPDATE `game_event` SET `start_time`="2016-12-01 00:01:00" WHERE `eventEntry`=23;
+UPDATE `game_event` SET `start_time`="2017-09-20 00:01:00" WHERE `eventEntry`=24;
+UPDATE `game_event` SET `start_time`="2016-10-28 21:00:00" WHERE `eventEntry`=25;
+UPDATE `game_event` SET `start_time`="2017-11-21 00:01:00" WHERE `eventEntry`=26;
+UPDATE `game_event` SET `start_time`="2016-10-01 00:01:00" WHERE `eventEntry`=34;
+UPDATE `game_event` SET `start_time`="2016-11-01 00:01:00" WHERE `eventEntry`=35;
+UPDATE `game_event` SET `start_time`="2016-12-01 00:01:00" WHERE `eventEntry`=36;
+UPDATE `game_event` SET `start_time`="2017-01-01 00:01:00" WHERE `eventEntry`=37;
+UPDATE `game_event` SET `start_time`="2017-02-01 00:01:00" WHERE `eventEntry`=38;
+UPDATE `game_event` SET `start_time`="2017-03-01 00:01:00" WHERE `eventEntry`=39;
+UPDATE `game_event` SET `start_time`="2017-04-01 00:01:00" WHERE `eventEntry`=40;
+UPDATE `game_event` SET `start_time`="2017-05-01 00:01:00" WHERE `eventEntry`=41;
+UPDATE `game_event` SET `start_time`="2017-06-01 00:01:00" WHERE `eventEntry`=42;
+UPDATE `game_event` SET `start_time`="2017-07-01 00:01:00" WHERE `eventEntry`=43;
+UPDATE `game_event` SET `start_time`="2017-08-01 00:01:00" WHERE `eventEntry`=44;
+UPDATE `game_event` SET `start_time`="2017-09-01 00:01:00" WHERE `eventEntry`=45;
+UPDATE `game_event` SET `start_time`="2017-09-19 00:01:00" WHERE `eventEntry`=50;
+UPDATE `game_event` SET `start_time`="2016-11-01 00:01:00" WHERE `eventEntry`=51;
+UPDATE `game_event` SET `start_time`="2016-10-28 00:01:00" WHERE `eventEntry`=53;
+UPDATE `game_event` SET `start_time`="2016-11-04 00:01:00" WHERE `eventEntry`=54;
+UPDATE `game_event` SET `start_time`="2016-10-30 14:00:00" WHERE `eventEntry`=62;
+UPDATE `game_event` SET `start_time`="2016-10-29 13:00:00" WHERE `eventEntry`=63;
+UPDATE `game_event` SET `start_time`="2016-10-29 14:00:00" WHERE `eventEntry`=64;
-- 
cgit v1.2.3