From 9b90c343e422009128bab2c4d1e91a1cc076e37a Mon Sep 17 00:00:00 2001
From: teacher <none@none>
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/characters.sql                          | 2 +-
 sql/updates/7919_characters_worldstates.sql | 4 ++++
 sql/updates/7919_characters_worlstates.sql  | 4 ----
 sql/updates/7921_characters_worldstates.sql | 1 +
 4 files changed, 6 insertions(+), 5 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')

diff --git a/sql/characters.sql b/sql/characters.sql
index fba3bd31656..16312e478b1 100644
--- a/sql/characters.sql
+++ b/sql/characters.sql
@@ -1936,7 +1936,7 @@ DROP TABLE IF EXISTS `worldstates`;
 CREATE TABLE `worldstates` (
   `entry` mediumint(11) UNSIGNED NOT NULL DEFAULT '0',
   `value` bigint(40) UNSIGNED NOT NULL DEFAULT '0',
-  `comment` text NOT NULL,
+  `comment` text,
   PRIMARY KEY  (`entry`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Variable Saves';
 /*!40101 SET character_set_client = @saved_cs_client */;
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