diff options
| author | Pide <57730677+wowpide@users.noreply.github.com> | 2019-11-21 17:50:32 +1100 |
|---|---|---|
| committer | Stoabrogga <38475780+Stoabrogga@users.noreply.github.com> | 2019-11-21 07:50:32 +0100 |
| commit | 2fe934aedc66da431e78c75c35e44db2f923e468 (patch) | |
| tree | 6f1140e3b2dfef12c36927cb1b2d4c775deb787b | |
| parent | aa574714aff8334bfe5d3c1f84f72f5733e2f9f4 (diff) | |
fix(DB/game_event): use another default minimum date to avoid import errors (#2462)
| -rw-r--r-- | data/sql/updates/db_world/2019_11_09_00.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/data/sql/updates/db_world/2019_11_09_00.sql b/data/sql/updates/db_world/2019_11_09_00.sql index 76f67f8f57..7c7681dd74 100644 --- a/data/sql/updates/db_world/2019_11_09_00.sql +++ b/data/sql/updates/db_world/2019_11_09_00.sql @@ -16,10 +16,10 @@ SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '157167293368191681 INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1571672933681916812'); -ALTER TABLE `game_event` ALTER COLUMN `start_time` SET DEFAULT '1970-01-01 08:00:00', - ALTER COLUMN `end_time` SET DEFAULT '1970-01-01 08:00:00'; +ALTER TABLE `game_event` ALTER COLUMN `start_time` SET DEFAULT '2000-01-01 08:00:00', + ALTER COLUMN `end_time` SET DEFAULT '2000-01-01 08:00:00'; -UPDATE `game_event` SET `start_time` = '1970-01-01 08:00:00', `end_time` = '1970-01-01 08:00:00' WHERE `eventEntry` IN +UPDATE `game_event` SET `start_time` = '2000-01-01 08:00:00', `end_time` = '2000-01-01 08:00:00' WHERE `eventEntry` IN (13, 17, 22, 31, 48, 49, 55, 56, 57, 58, 59, 60, 65, 66); UPDATE `game_event` SET `end_time` = NULL WHERE `eventEntry` IN |