From e782bd5f2f7cd73634dfd8616a351a1b97c2109c Mon Sep 17 00:00:00 2001
From: gepard1984 <gepard1984@54d463be-8e91-2dee-dedb-b68131a5f0ec>
Date: Wed, 11 Jan 2012 17:35:28 +0000
Subject: Picklog improvements:  - now it is finally possible to log every item
 players gain or lose  - added 3 log types: `I` for auctioned items, `B` for
 buying shop transactions and `X` for all other items transactions that don't
 fall into another category (for detailed explanation on all log types read
 `conf/log_athena.conf`)  - it also fixes items being logged as picked
 up/gained by player when in fact they were dropped on the ground due to full
 inventory

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15420 54d463be-8e91-2dee-dedb-b68131a5f0ec
---
 sql-files/upgrade_svn15420_log.sql | 3 +++
 1 file changed, 3 insertions(+)
 create mode 100644 sql-files/upgrade_svn15420_log.sql

(limited to 'sql-files/upgrade_svn15420_log.sql')

diff --git a/sql-files/upgrade_svn15420_log.sql b/sql-files/upgrade_svn15420_log.sql
new file mode 100644
index 000000000..5e6e3c9e9
--- /dev/null
+++ b/sql-files/upgrade_svn15420_log.sql
@@ -0,0 +1,3 @@
+-- Adds 'I' and 'X' to `type` in `picklog` table
+
+ALTER TABLE `picklog` MODIFY `type` ENUM('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X') NOT NULL DEFAULT 'P';
\ No newline at end of file
-- 
cgit v1.2.3-70-g09d2

