summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorjaBote <jaBote@users.noreply.github.com>2013-11-10 20:53:00 +0100
committerjaBote <jaBote@users.noreply.github.com>2013-11-10 20:53:00 +0100
commit54c250068e565793c53f5a558204c9d177456060 (patch)
treec9a5fc7948916b01137e755646e074a92b676358 /sql-files
parent985c2fdd37bdf0771dd3ac302128f18a4867580c (diff)
downloadhercules-54c250068e565793c53f5a558204c9d177456060.tar.gz
hercules-54c250068e565793c53f5a558204c9d177456060.tar.bz2
hercules-54c250068e565793c53f5a558204c9d177456060.tar.xz
hercules-54c250068e565793c53f5a558204c9d177456060.zip
Added rAthena to Hercules main database upgrader.
This has been added because a lot of people were suggesting this on the forums. Check the news topic for more info: http://hercules.ws/board/topic/2906-introducing-rathena-to-hercules-database-converters/?p=19260
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/upgrades/rAthena-main-upgrade.sql80
1 files changed, 80 insertions, 0 deletions
diff --git a/sql-files/upgrades/rAthena-main-upgrade.sql b/sql-files/upgrades/rAthena-main-upgrade.sql
new file mode 100644
index 000000000..5da6c9446
--- /dev/null
+++ b/sql-files/upgrades/rAthena-main-upgrade.sql
@@ -0,0 +1,80 @@
+-- rAthena to Hercules main database upgrade query.
+-- This upgrades a FULLY UPGRADED rAthena to a FULLY UPGRADED Hercules
+-- Please don't use if either rAthena or Hercules launched a SQL update after last revision date of this file.
+-- 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 main.sql
+-- Last revision: November 10, 2013, 19:00
+
+
+-- Drop table `skillcooldown` since it's not used in Hercules
+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';
+
+-- Upgrades for table `char`
+ALTER TABLE `char` DROP COLUMN `moves`,
+ ADD `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';
+
+-- 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';
+
+--
+-- Table structure for table `sql_updates`
+--
+CREATE TABLE IF NOT EXISTS `sql_updates` (
+ `timestamp` int(11) unsigned NOT NULL,
+ `ignored` enum('Yes','No') NOT NULL DEFAULT 'No',
+ PRIMARY KEY (`timestamp`)
+) ENGINE=MyISAM;
+
+-- Existent updates to enter
+INSERT INTO `sql_updates` (`timestamp`) VALUES (1360858500);
+INSERT INTO `sql_updates` (`timestamp`) VALUES (1360951560);
+INSERT INTO `sql_updates` (`timestamp`) VALUES (1362445531);
+INSERT INTO `sql_updates` (`timestamp`) VALUES (1362528000);
+INSERT INTO `sql_updates` (`timestamp`) VALUES (1362794218);
+INSERT INTO `sql_updates` (`timestamp`) VALUES (1364409316);
+INSERT INTO `sql_updates` (`timestamp`) VALUES (1366075474);
+INSERT INTO `sql_updates` (`timestamp`) VALUES (1366078541);
+INSERT INTO `sql_updates` (`timestamp`) VALUES (1381354728);
+INSERT INTO `sql_updates` (`timestamp`) VALUES (1381423003);
+INSERT INTO `sql_updates` (`timestamp`) VALUES (1382892428);
+INSERT INTO `sql_updates` (`timestamp`) VALUES (1383162785);
+INSERT INTO `sql_updates` (`timestamp`) VALUES (1383167577);
+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';
+
+--
+-- Table structure for table `account_data`
+--
+
+CREATE TABLE IF NOT EXISTS `account_data` (
+ `account_id` int(11) unsigned NOT NULL default '0',
+ `bank_vault` int(11) unsigned NOT NULL default '0',
+ `base_exp` TINYINT( 4 ) UNSIGNED NOT NULL default '100',
+ `base_drop` TINYINT( 4 ) UNSIGNED NOT NULL default '100',
+ `base_death` TINYINT( 4 ) UNSIGNED NOT NULL default '100',
+ PRIMARY KEY (`account_id`)
+) ENGINE=MyISAM;
+
+-- Saving bank_vault data from rAthena's login table
+-- to our account_data table. There may be some not working cases.
+
+INSERT INTO `account_data` (`account_id`, `bank_vault`) SELECT `account_id`, `bank_vault` FROM `login` WHERE `bank_vault` > 0 ;
+
+-- Dropping bank_vault column from login table
+ALTER TABLE `login` DROP COLUMN `bank_vault`;