From 938ac2d9ecb8f347722f18770a9d3de8988be6db Mon Sep 17 00:00:00 2001 From: jaBote Date: Sun, 10 Nov 2013 20:54:48 +0100 Subject: 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 --- sql-files/upgrades/rathena-logs-database-upgrade | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql-files/upgrades/rathena-logs-database-upgrade 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`; -- cgit v1.2.3-60-g2f50