From 34d8f5cbf9069eda86315af0cc03c1f94306b463 Mon Sep 17 00:00:00 2001 From: teacher Date: Thu, 15 Apr 2010 21:14:24 +0200 Subject: Added worldstates values in characters.sql and re-dumped to prevent any issues. The first time there was no insert statement in the sql update. --HG-- branch : trunk --- sql/characters.sql | 3 +++ sql/updates/7905_characters_petition.sql | 2 +- sql/updates/7919_characters_worlstates.sql | 4 ++++ 3 files changed, 8 insertions(+), 1 deletion(-) create mode 100644 sql/updates/7919_characters_worlstates.sql (limited to 'sql') 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'); -- cgit v1.2.3