From 54c250068e565793c53f5a558204c9d177456060 Mon Sep 17 00:00:00 2001 From: jaBote Date: Sun, 10 Nov 2013 20:53:00 +0100 Subject: 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 --- sql-files/upgrades/rAthena-main-upgrade.sql | 80 +++++++++++++++++++++++++++++ 1 file changed, 80 insertions(+) create mode 100644 sql-files/upgrades/rAthena-main-upgrade.sql (limited to 'sql-files') 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`; -- cgit v1.2.3-60-g2f50