Fix bad use of worldstates table in last commit

--HG--
branch : trunk

2 files changed, 2 insertions, 1 deletions

diff --git a/sql/characters.sql b/sql/characters.sql
index c6dafbe533d..d4e4f132617 100644
--- a/sql/characters.sql
+++ b/sql/characters.sql
@@ -1936,7 +1936,6 @@ DROP TABLE IF EXISTS `worldstates`;
 CREATE TABLE `worldstates` (
   `entry` mediumint(11) UNSIGNED NOT NULL DEFAULT '0',
   `value` bigint(40) UNSIGNED NOT NULL DEFAULT '0',
-  `NextWeeklyQuestResetTime` bigint(40) unsigned NOT NULL default '0',
   `comment` text NOT NULL,
   PRIMARY KEY  (`entry`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Variable Saves';
diff --git a/sql/updates/7915_characters_worldstates.sql b/sql/updates/7915_characters_worldstates.sql
new file mode 100644
index 00000000000..cad658e6606
--- /dev/null
+++ b/sql/updates/7915_characters_worldstates.sql
@@ -0,0 +1,2 @@
+ALTER TABLE `worldstates` DROP COLOMUN `NextWeeklyQuestResetTime`;
+INSERT INTO `worldstates` (`entry`,`value`, `comment`) VALUES (20002, 0, 'NextWeeklyQuestResetTime');