From 996e110eed6376fca158fb0136c55aea5ac819be Mon Sep 17 00:00:00 2001
From: gepard1984 <gepard1984@54d463be-8e91-2dee-dedb-b68131a5f0ec>
Date: Wed, 25 Jan 2012 14:41:32 +0000
Subject: Added two picklog types to distinguish regular monster drops (M) from
 stolen items (D) and MVP prizes (U)(bugreport:4590).

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

(limited to 'sql-files')

diff --git a/sql-files/upgrade_svn15519_log.sql b/sql-files/upgrade_svn15519_log.sql
new file mode 100644
index 000000000..623b022b8
--- /dev/null
+++ b/sql-files/upgrade_svn15519_log.sql
@@ -0,0 +1,3 @@
+-- Adds 'D' and 'U' 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','D','U') NOT NULL DEFAULT 'P';
-- 
cgit v1.2.3-60-g2f50