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 /sql | |
parent | 2a62e7079573db8a28b9843da33de6786a28665d (diff) |
SQL: Add missing sql in old 3.3.5a file
Diffstat (limited to 'sql')
-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'; |