- Normalized the mapname in guild get/set castle data, should fix guild flags.

- Added log options 0x800/0x1000 to log storage moves ('R') and guild storage moves ('G')
- Added upgrade_svn9976.sql to include 'R'/'G' on the picklog type column set.
- Updated the logs_athena description to include the letter of each type (512 - M, 32 - N, etc)


git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9976 54d463be-8e91-2dee-dedb-b68131a5f0ec

2 files changed, 2 insertions, 1 deletions

diff --git a/sql-files/logs.sql b/sql-files/logs.sql
index 597e9e0ed..aa0ead7d8 100644
--- a/sql-files/logs.sql
+++ b/sql-files/logs.sql
@@ -8,7 +8,7 @@ CREATE TABLE `picklog` (
   `id` int(11) NOT NULL auto_increment,
   `time` datetime NOT NULL default '0000-00-00 00:00:00',
   `char_id` int(11) NOT NULL default '0',
-  `type` set('M','P','L','T','V','S','N','C','A') NOT NULL default 'P',
+  `type` set('M','P','L','T','V','S','N','C','A','R','G') NOT NULL default 'P',
   `nameid` int(11) NOT NULL default '0',
   `amount` int(11) NOT NULL default '1',
   `refine` tinyint(3) unsigned NOT NULL default '0',
diff --git a/sql-files/upgrade_svn9976.sql b/sql-files/upgrade_svn9976.sql
new file mode 100644
index 000000000..82902bff6
--- /dev/null
+++ b/sql-files/upgrade_svn9976.sql
@@ -0,0 +1 @@
+ALTER TABLE `picklog` MODIFY `type` set('M','P','L','T','V','S','N','C','A','R','G') NOT NULL default 'P';