summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorjaBote <jaBote@users.noreply.github.com>2013-11-10 20:54:48 +0100
committerjaBote <jaBote@users.noreply.github.com>2013-11-10 20:54:48 +0100
commit938ac2d9ecb8f347722f18770a9d3de8988be6db (patch)
tree584585b85a561c5b2824c809da5da1d9a7932fe8 /sql-files
parent54c250068e565793c53f5a558204c9d177456060 (diff)
downloadhercules-938ac2d9ecb8f347722f18770a9d3de8988be6db.tar.gz
hercules-938ac2d9ecb8f347722f18770a9d3de8988be6db.tar.bz2
hercules-938ac2d9ecb8f347722f18770a9d3de8988be6db.tar.xz
hercules-938ac2d9ecb8f347722f18770a9d3de8988be6db.zip
Added rAthena to Hercules logs database upgrader
This has been added because a lot of people were suggesting this on the forums. Check the news topic for more info: http://hercules.ws/board/topic/2906-introducing-rathena-to-hercules-database-converters/?p=19260
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/upgrades/rathena-logs-database-upgrade13
1 files changed, 13 insertions, 0 deletions
diff --git a/sql-files/upgrades/rathena-logs-database-upgrade b/sql-files/upgrades/rathena-logs-database-upgrade
new file mode 100644
index 000000000..7cdf58992
--- /dev/null
+++ b/sql-files/upgrades/rathena-logs-database-upgrade
@@ -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 revision: November 10, 2013, 19:00
+
+-- 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`;