From 9b90c343e422009128bab2c4d1e91a1cc076e37a Mon Sep 17 00:00:00 2001 From: teacher Date: Thu, 15 Apr 2010 21:44:21 +0200 Subject: Changed worldstates.comment field to allow NULL values (by Spp). Proper naming for recent sql files. Who was the fool to give me push access!? --HG-- branch : trunk --- sql/updates/7919_characters_worldstates.sql | 4 ++++ sql/updates/7919_characters_worlstates.sql | 4 ---- sql/updates/7921_characters_worldstates.sql | 1 + 3 files changed, 5 insertions(+), 4 deletions(-) create mode 100644 sql/updates/7919_characters_worldstates.sql delete mode 100644 sql/updates/7919_characters_worlstates.sql create mode 100644 sql/updates/7921_characters_worldstates.sql (limited to 'sql/updates') diff --git a/sql/updates/7919_characters_worldstates.sql b/sql/updates/7919_characters_worldstates.sql new file mode 100644 index 00000000000..b265aebb92e --- /dev/null +++ b/sql/updates/7919_characters_worldstates.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'); diff --git a/sql/updates/7919_characters_worlstates.sql b/sql/updates/7919_characters_worlstates.sql deleted file mode 100644 index b265aebb92e..00000000000 --- a/sql/updates/7919_characters_worlstates.sql +++ /dev/null @@ -1,4 +0,0 @@ -DELETE FROM `worldstates` WHERE `entry` IN (20001,20002); -INSERT INTO `worldstates` (`entry`,`value`, `comment`) VALUES -(20001, 0, 'NextArenaPointDistributionTime'), -(20002, 0, 'NextWeeklyQuestResetTime'); diff --git a/sql/updates/7921_characters_worldstates.sql b/sql/updates/7921_characters_worldstates.sql new file mode 100644 index 00000000000..f2e08626b8c --- /dev/null +++ b/sql/updates/7921_characters_worldstates.sql @@ -0,0 +1 @@ +ALTER TABLE `worldstates` CHANGE COLUMN `comment` `comment` text; -- cgit v1.2.3