From 9a36b78fc3d07be4ad4d352df41e5ca5a90aa742 Mon Sep 17 00:00:00 2001 From: jaBote Date: Tue, 22 Jul 2014 20:49:10 +0200 Subject: Update rAthena-logs-upgrade.sql --- sql-files/upgrades/rAthena-logs-upgrade.sql | 17 +++++++++++++---- 1 file changed, 13 insertions(+), 4 deletions(-) (limited to 'sql-files/upgrades/rAthena-logs-upgrade.sql') 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'; -- cgit v1.2.3-60-g2f50