summaryrefslogtreecommitdiff
path: root/sql-files/upgrades/rAthena-logs-upgrade.sql
diff options
context:
space:
mode:
authorpanikon <panikon@zoho.com>2014-03-22 00:07:10 -0300
committerpanikon <panikon@zoho.com>2014-03-22 00:07:10 -0300
commitaa120720cec6ba1ddf6ec8ac6098fef6377dddc0 (patch)
tree17c926639ad7107be62e88cb670eaa22167a8b96 /sql-files/upgrades/rAthena-logs-upgrade.sql
parent26f2adab3126c5b76a93c3220ccfb4aec7db07e1 (diff)
downloadhercules-aa120720cec6ba1ddf6ec8ac6098fef6377dddc0.tar.gz
hercules-aa120720cec6ba1ddf6ec8ac6098fef6377dddc0.tar.bz2
hercules-aa120720cec6ba1ddf6ec8ac6098fef6377dddc0.tar.xz
hercules-aa120720cec6ba1ddf6ec8ac6098fef6377dddc0.zip
Fixed issue 7338 (added new char configuration char_aegis_delete)
http://hercules.ws/board/tracker/issue-7338-deleting-character/ As @jaBote requested in 26f2ada, renamed "rathena-logs-database-upgrade" to "rAthena-logs-upgrade.sql" and updated 'last revision'. Added a 'FIXME' in db_obj_put
Diffstat (limited to 'sql-files/upgrades/rAthena-logs-upgrade.sql')
-rw-r--r--sql-files/upgrades/rAthena-logs-upgrade.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/sql-files/upgrades/rAthena-logs-upgrade.sql b/sql-files/upgrades/rAthena-logs-upgrade.sql
new file mode 100644
index 000000000..b523f8444
--- /dev/null
+++ b/sql-files/upgrades/rAthena-logs-upgrade.sql
@@ -0,0 +1,13 @@
+-- rAthena to Hercules log database upgrade query.
+-- This upgrades a FULLY UPGRADED rAthena to a FULLY UPGRADED Hercules
+-- Please don't use if either rAthena or Hercules launched a SQL update after last revision date of this file.
+-- Remember to make a backup before applying.
+-- We are not liable for any data loss this may cause.
+-- Apply in the same database you applied your logs.sql
+-- Last revised: March 21, 2014 20:30 GMT
+
+-- Upgrades to table `picklog`
+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';
+
+-- Drop table `cashlog` since it's not used in Hercules
+DROP TABLE IF EXISTS `cashlog`;