diff options
| author | teacher <none@none> | 2010-04-15 21:44:21 +0200 |
|---|---|---|
| committer | teacher <none@none> | 2010-04-15 21:44:21 +0200 |
| commit | 9b90c343e422009128bab2c4d1e91a1cc076e37a (patch) | |
| tree | ad1df0300bc3aca3f4fc04e43ec9203a3ffadf19 | |
| parent | c5f0e94966d14b1bc56cb82b71f06ad23de0bf2f (diff) | |
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
| -rw-r--r-- | sql/characters.sql | 2 | ||||
| -rw-r--r-- | sql/updates/7919_characters_worldstates.sql (renamed from sql/updates/7919_characters_worlstates.sql) | 0 | ||||
| -rw-r--r-- | sql/updates/7921_characters_worldstates.sql | 1 |
3 files changed, 2 insertions, 1 deletions
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_worlstates.sql b/sql/updates/7919_characters_worldstates.sql index b265aebb92e..b265aebb92e 100644 --- a/sql/updates/7919_characters_worlstates.sql +++ b/sql/updates/7919_characters_worldstates.sql 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; |