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

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');