diff options
| author | jaBote <jaBote@users.noreply.github.com> | 2013-11-10 22:51:05 +0100 |
|---|---|---|
| committer | jaBote <jaBote@users.noreply.github.com> | 2013-11-10 22:51:05 +0100 |
| commit | 8f2838878c954adc839e00d92e4663c764fb3c01 (patch) | |
| tree | a3caf4aba43d57bd85ec2f73afb538b02cbf693e /sql-files/upgrades/rAthena-main-upgrade.sql | |
| parent | 938ac2d9ecb8f347722f18770a9d3de8988be6db (diff) | |
| download | hercules-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/rAthena-main-upgrade.sql')
| -rw-r--r-- | sql-files/upgrades/rAthena-main-upgrade.sql | 5 |
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`; |