summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorjaBote <jaBote@users.noreply.github.com>2013-11-15 20:37:53 +0100
committerjaBote <jaBote@users.noreply.github.com>2013-11-15 20:37:53 +0100
commit044332d0420e1c8d477f07be7b31358bb133fd17 (patch)
tree93341c56384dae5208b1a42a4a5f43b5d7819cbe /sql-files
parente249264cb8370c2d3143197308e0d0dca69a71a9 (diff)
downloadhercules-044332d0420e1c8d477f07be7b31358bb133fd17.tar.gz
hercules-044332d0420e1c8d477f07be7b31358bb133fd17.tar.bz2
hercules-044332d0420e1c8d477f07be7b31358bb133fd17.tar.xz
hercules-044332d0420e1c8d477f07be7b31358bb133fd17.zip
Update rAthena-main-upgrade.sql
Made the converter keep some more data (rAthena's `moves` column is equivalent to our `slotchange` in the `login` table) and made it a tidbit more efficient since with their last updates their DB is now more similar to ours :D
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/upgrades/rAthena-main-upgrade.sql20
1 files changed, 10 insertions, 10 deletions
diff --git a/sql-files/upgrades/rAthena-main-upgrade.sql b/sql-files/upgrades/rAthena-main-upgrade.sql
index 6d543918f..ac9f90342 100644
--- a/sql-files/upgrades/rAthena-main-upgrade.sql
+++ b/sql-files/upgrades/rAthena-main-upgrade.sql
@@ -16,22 +16,20 @@ TRUNCATE TABLE `sc_data`;
DROP TABLE IF EXISTS `skillcooldown`;
-- Upgrades for table `cart_inventory`
-ALTER TABLE `cart_inventory` MODIFY `equip` INT(11) UNSIGNED NOT NULL default '0',
- MODIFY `bound` tinyint(1) unsigned NOT NULL default '0';
+ALTER TABLE `cart_inventory` MODIFY `bound` tinyint(1) unsigned NOT NULL default '0';
-- Upgrades for table `char`
-ALTER TABLE `char` DROP COLUMN `moves`,
- ADD `slotchange` SMALLINT(3) UNSIGNED NOT NULL default '0',
+ALTER TABLE `char` CHANGE `moves` `slotchange` SMALLINT(3) UNSIGNED NOT NULL default '0',
ADD `char_opt` INT( 11 ) UNSIGNED NOT NULL default '0',
ADD `font` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0';
-- Upgrades for table `guild_storage`
-ALTER TABLE `guild_storage` MODIFY `equip` INT(11) UNSIGNED NOT NULL default '0',
- MODIFY `bound` tinyint(1) unsigned NOT NULL default '0';
+ALTER TABLE `guild_storage` MODIFY `bound` tinyint(1) unsigned NOT NULL default '0';
-- Upgrades for table `inventory`
-ALTER TABLE `inventory` MODIFY `equip` INT(11) UNSIGNED NOT NULL default '0',
- MODIFY `bound` tinyint(1) unsigned NOT NULL default '0';
+ALTER TABLE `inventory` MODIFY `bound` tinyint(1) unsigned NOT NULL default '0';
+
+-- Bank vault is saved later since we need to make a table rAthena doesn't have first
--
-- Table structure for table `sql_updates`
@@ -60,8 +58,7 @@ INSERT INTO `sql_updates` (`timestamp`) VALUES (1383205740);
INSERT INTO `sql_updates` (`timestamp`) VALUES (1383955424);
-- Updates to table `storage`
-ALTER TABLE `storage` MODIFY `equip` INT(11) UNSIGNED NOT NULL default '0',
- MODIFY `bound` tinyint(1) unsigned NOT NULL default '0';
+ALTER TABLE `storage` MODIFY `bound` tinyint(1) unsigned NOT NULL default '0';
--
-- Table structure for table `account_data`
@@ -83,3 +80,6 @@ INSERT INTO `account_data` (`account_id`, `bank_vault`) SELECT `account_id`, `ba
-- Dropping bank_vault column from login table
ALTER TABLE `login` DROP COLUMN `bank_vault`;
+
+-- Drop table `bonus_script` since it's not used in Hercules
+DROP TABLE IF EXISTS `bonus_script`;