summaryrefslogtreecommitdiff
path: root/sql-files/upgrades
diff options
context:
space:
mode:
authorjaBote <jaBote@users.noreply.github.com>2013-11-10 22:51:05 +0100
committerjaBote <jaBote@users.noreply.github.com>2013-11-10 22:51:05 +0100
commit8f2838878c954adc839e00d92e4663c764fb3c01 (patch)
treea3caf4aba43d57bd85ec2f73afb538b02cbf693e /sql-files/upgrades
parent938ac2d9ecb8f347722f18770a9d3de8988be6db (diff)
downloadhercules-8f2838878c954adc839e00d92e4663c764fb3c01.tar.gz
hercules-8f2838878c954adc839e00d92e4663c764fb3c01.tar.bz2
hercules-8f2838878c954adc839e00d92e4663c764fb3c01.tar.xz
hercules-8f2838878c954adc839e00d92e4663c764fb3c01.zip
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!
Diffstat (limited to 'sql-files/upgrades')
-rw-r--r--sql-files/upgrades/rAthena-main-upgrade.sql5
1 files changed, 5 insertions, 0 deletions
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`;