diff options
| author | gepard1984 <gepard1984@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2012-01-31 20:06:57 +0000 |
|---|---|---|
| committer | gepard1984 <gepard1984@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2012-01-31 20:06:57 +0000 |
| commit | 93c79a7017522d87e06b67af1959ecccff32cb7e (patch) | |
| tree | 1ef1ed7b4a2c27499da24c7da7ecee67a3a1d760 /sql-files/upgrade_svn15531_db.sql | |
| parent | 2a3063c4e48c78fc4f778a06349a6e87dae89f50 (diff) | |
| download | hercules-93c79a7017522d87e06b67af1959ecccff32cb7e.tar.gz hercules-93c79a7017522d87e06b67af1959ecccff32cb7e.tar.bz2 hercules-93c79a7017522d87e06b67af1959ecccff32cb7e.tar.xz hercules-93c79a7017522d87e06b67af1959ecccff32cb7e.zip | |
* Fixes and improvements related to MVP rewards (bugreport:1259):
- removed obsolete (since r1!) ExpPer column from mob_db
- official way to drop MVP rewards (always starts from first slot)
- added MAX_MVP_DROP as define for max possible MVP reward slots
* Updated mob_db SQL scripts.
* Removed some renewal only monsters from pre-RE mob_db (were commented out anyway).
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15531 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files/upgrade_svn15531_db.sql')
| -rw-r--r-- | sql-files/upgrade_svn15531_db.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql-files/upgrade_svn15531_db.sql b/sql-files/upgrade_svn15531_db.sql new file mode 100644 index 000000000..ce0e56302 --- /dev/null +++ b/sql-files/upgrade_svn15531_db.sql @@ -0,0 +1,4 @@ +-- `ExpPer` column removed from `mob_db` and `mob_db2` tables + +ALTER TABLE `mob_db` DROP COLUMN `ExpPer`; +ALTER TABLE `mob_db2` DROP COLUMN `ExpPer`; |