diff options
| author | Vincent-Michael <Vincent_Michael@gmx.de> | 2013-06-11 21:46:09 +0200 |
|---|---|---|
| committer | Vincent-Michael <Vincent_Michael@gmx.de> | 2013-06-11 21:48:24 +0200 |
| commit | 93c86b0c52a99d69fd14f4904a000b6c86759c69 (patch) | |
| tree | edcc8165971ff6b3a46f5ac083528bbc5c221cac | |
| parent | 2a62e7079573db8a28b9843da33de6786a28665d (diff) | |
SQL: Add missing sql in old 3.3.5a file
| -rw-r--r-- | sql/old/3.3.5a/2012_08_06_00_world_command.sql | 4 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2012_08_07_00_characters_characters.sql | 2 |
2 files changed, 6 insertions, 0 deletions
diff --git a/sql/old/3.3.5a/2012_08_06_00_world_command.sql b/sql/old/3.3.5a/2012_08_06_00_world_command.sql new file mode 100644 index 00000000000..50628aaa589 --- /dev/null +++ b/sql/old/3.3.5a/2012_08_06_00_world_command.sql @@ -0,0 +1,4 @@ +DELETE FROM `command` WHERE `name` IN ('server togglequerylog', 'server set loglevel'); + +INSERT INTO `command` (`name`,`security`,`help`) VALUES +('server set loglevel',4,'Syntax: .server set loglevel $facility $name $loglevel. $facility can take the values: appender (a) or logger (l). $loglevel can take the values: disabled (0), trace (1), debug (2), info (3), warn (4), error (5) or fatal (6)'); diff --git a/sql/old/3.3.5a/2012_08_07_00_characters_characters.sql b/sql/old/3.3.5a/2012_08_07_00_characters_characters.sql new file mode 100644 index 00000000000..e9bea82ad4b --- /dev/null +++ b/sql/old/3.3.5a/2012_08_07_00_characters_characters.sql @@ -0,0 +1,2 @@ +UPDATE characters SET drunk = (drunk / 256) & 0xFF; +ALTER TABLE characters CHANGE drunk drunk tinyint(3) unsigned NOT NULL DEFAULT '0'; |