diff options
| -rw-r--r-- | sql/characters.sql | 3 | ||||
| -rw-r--r-- | sql/updates/7905_characters_petition.sql | 2 | ||||
| -rw-r--r-- | sql/updates/7919_characters_worlstates.sql | 4 |
3 files changed, 8 insertions, 1 deletions
diff --git a/sql/characters.sql b/sql/characters.sql index d4e4f132617..a25d471638e 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -1947,6 +1947,9 @@ CREATE TABLE `worldstates` ( LOCK TABLES `worldstates` WRITE; /*!40000 ALTER TABLE `worldstates` DISABLE KEYS */; +INSERT INTO `worldstates` (`entry`,`value`, `comment`) VALUES +(20001, 0, `='NextArenaPointDistributionTime'), +(20002, 0, 'NextWeeklyQuestResetTime'); /*!40000 ALTER TABLE `worldstates` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; diff --git a/sql/updates/7905_characters_petition.sql b/sql/updates/7905_characters_petition.sql index 07132963b56..844f2d0d89f 100644 --- a/sql/updates/7905_characters_petition.sql +++ b/sql/updates/7905_characters_petition.sql @@ -1,2 +1,2 @@ ALTER TABLE `petition_sign` ADD INDEX `Idx_playerguid`(`playerguid`); -ALTER TABLE `petition_sign` ADD INDEX `Idx_ownerguid`(`ownerguid`);
\ No newline at end of file +ALTER TABLE `petition_sign` ADD INDEX `Idx_ownerguid`(`ownerguid`); diff --git a/sql/updates/7919_characters_worlstates.sql b/sql/updates/7919_characters_worlstates.sql new file mode 100644 index 00000000000..b265aebb92e --- /dev/null +++ b/sql/updates/7919_characters_worlstates.sql @@ -0,0 +1,4 @@ +DELETE FROM `worldstates` WHERE `entry` IN (20001,20002); +INSERT INTO `worldstates` (`entry`,`value`, `comment`) VALUES +(20001, 0, 'NextArenaPointDistributionTime'), +(20002, 0, 'NextWeeklyQuestResetTime'); |