summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorgepard1984 <gepard1984@54d463be-8e91-2dee-dedb-b68131a5f0ec>2012-01-25 14:41:32 +0000
committergepard1984 <gepard1984@54d463be-8e91-2dee-dedb-b68131a5f0ec>2012-01-25 14:41:32 +0000
commit996e110eed6376fca158fb0136c55aea5ac819be (patch)
treec1785869e8249116ed0fe6e38c18d716498460d0 /sql-files
parent3e77d310d328a98814df15ba80913833421cdae9 (diff)
downloadhercules-996e110eed6376fca158fb0136c55aea5ac819be.tar.gz
hercules-996e110eed6376fca158fb0136c55aea5ac819be.tar.bz2
hercules-996e110eed6376fca158fb0136c55aea5ac819be.tar.xz
hercules-996e110eed6376fca158fb0136c55aea5ac819be.zip
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
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/upgrade_svn15519_log.sql3
1 files changed, 3 insertions, 0 deletions
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';