summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorjaBote <jaBote@users.noreply.github.com>2014-07-22 20:49:10 +0200
committerjaBote <jaBote@users.noreply.github.com>2014-07-22 20:49:10 +0200
commit9a36b78fc3d07be4ad4d352df41e5ca5a90aa742 (patch)
treebc4ee0e4f900e9f0125e71fb6f49d1ca21b60ab2 /sql-files
parent5955d81ac5360e073c66f961c2750da4645860bb (diff)
downloadhercules-9a36b78fc3d07be4ad4d352df41e5ca5a90aa742.tar.gz
hercules-9a36b78fc3d07be4ad4d352df41e5ca5a90aa742.tar.bz2
hercules-9a36b78fc3d07be4ad4d352df41e5ca5a90aa742.tar.xz
hercules-9a36b78fc3d07be4ad4d352df41e5ca5a90aa742.zip
Update rAthena-logs-upgrade.sql
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/upgrades/rAthena-logs-upgrade.sql17
1 files changed, 13 insertions, 4 deletions
diff --git a/sql-files/upgrades/rAthena-logs-upgrade.sql b/sql-files/upgrades/rAthena-logs-upgrade.sql
index b523f8444..a286099a1 100644
--- a/sql-files/upgrades/rAthena-logs-upgrade.sql
+++ b/sql-files/upgrades/rAthena-logs-upgrade.sql
@@ -4,10 +4,19 @@
-- 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';
+-- Last revised: July 22, 2014 20:45 GMT
-- Drop table `cashlog` since it's not used in Hercules
+-- Comment it if you wish to keep the table
DROP TABLE IF EXISTS `cashlog`;
+
+-- Upgrades to table `mvplog`
+ALTER TABLE `mvplog` MODIFY `prize` INT(11) NOT NULL DEFAULT '0';
+
+-- 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';
+ALTER TABLE `picklog` MODIFY `nameid` INT(11) NOT NULL DEFAULT '0';
+ALTER TABLE `picklog` MODIFY `card0` INT(11) NOT NULL DEFAULT '0';
+ALTER TABLE `picklog` MODIFY `card1` INT(11) NOT NULL DEFAULT '0';
+ALTER TABLE `picklog` MODIFY `card2` INT(11) NOT NULL DEFAULT '0';
+ALTER TABLE `picklog` MODIFY `card3` INT(11) NOT NULL DEFAULT '0';