diff options
author | shennetsind <ind@henn.et> | 2014-03-22 17:07:13 -0300 |
---|---|---|
committer | shennetsind <ind@henn.et> | 2014-03-22 17:07:13 -0300 |
commit | 2b4d6abbc5baddc2207e73f0b84c7e6c73e271a4 (patch) | |
tree | e8d15f8f4a252cda88f3e3173f366ff9881edc4c /sql-files/upgrades/rAthena-logs-upgrade.sql | |
parent | 9ea7b143192568a259aa6e7e223420e8d5762b9e (diff) | |
parent | d097f2c4b4a31885c6b04f5868563e1f48414192 (diff) | |
download | hercules-2b4d6abbc5baddc2207e73f0b84c7e6c73e271a4.tar.gz hercules-2b4d6abbc5baddc2207e73f0b84c7e6c73e271a4.tar.bz2 hercules-2b4d6abbc5baddc2207e73f0b84c7e6c73e271a4.tar.xz hercules-2b4d6abbc5baddc2207e73f0b84c7e6c73e271a4.zip |
Merge branch 'master' of https://github.com/HerculesWS/Hercules
Diffstat (limited to 'sql-files/upgrades/rAthena-logs-upgrade.sql')
-rw-r--r-- | sql-files/upgrades/rAthena-logs-upgrade.sql | 13 |
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`; |