diff options
author | gepard1984 <gepard1984@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2012-01-25 14:41:32 +0000 |
---|---|---|
committer | gepard1984 <gepard1984@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2012-01-25 14:41:32 +0000 |
commit | 996e110eed6376fca158fb0136c55aea5ac819be (patch) | |
tree | c1785869e8249116ed0fe6e38c18d716498460d0 /sql-files/upgrade_svn15519_log.sql | |
parent | 3e77d310d328a98814df15ba80913833421cdae9 (diff) | |
download | hercules-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/upgrade_svn15519_log.sql')
-rw-r--r-- | sql-files/upgrade_svn15519_log.sql | 3 |
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'; |