From 8f2838878c954adc839e00d92e4663c764fb3c01 Mon Sep 17 00:00:00 2001 From: jaBote Date: Sun, 10 Nov 2013 22:51:05 +0100 Subject: Update rAthena-main-upgrade.sql Now it deletes all entries on the sc_data table since it's dangerous if we port the sc data as is. WARNING, this ends all active SCs on the previous server! Even jailed state! --- sql-files/upgrades/rAthena-main-upgrade.sql | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'sql-files/upgrades') diff --git a/sql-files/upgrades/rAthena-main-upgrade.sql b/sql-files/upgrades/rAthena-main-upgrade.sql index 5da6c9446..6d543918f 100644 --- a/sql-files/upgrades/rAthena-main-upgrade.sql +++ b/sql-files/upgrades/rAthena-main-upgrade.sql @@ -6,6 +6,11 @@ -- Apply in the same database you applied your main.sql -- Last revision: November 10, 2013, 19:00 +-- Drop table contents from ´sc_data´ since we use a different status order than rAthena +-- /!\ WARNING /!\ This will remove _ALL_ of the status effects active on the server +-- This will remove even jailed status from users! +TRUNCATE TABLE `sc_data`; + -- Drop table `skillcooldown` since it's not used in Hercules DROP TABLE IF EXISTS `skillcooldown`; -- cgit v1.2.3-60-g2f50