Move rAthena to Hercules

K

Kichi

New member
Messages
97
Points
0
Emulator
hi guys
I want to request SQL query to move safely from rAthena to Hercules.
 

This is my query, but still need for items and i don't need the logs query
 

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 enterINSERT 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 (1383167577);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', PRIMARY KEY (`account_id`)) ENGINE=MyISAM;ALTER TABLE `inventory` MODIFY `equip` int(11) unsigned NOT NULL default '0';ALTER TABLE `storage` MODIFY `equip` int(11) unsigned NOT NULL default '0';ALTER TABLE `cart_inventory` MODIFY `equip` int(11) unsigned NOT NULL default '0';ALTER TABLE `guild_storage` MODIFY `equip` int(11) unsigned NOT NULL default '0';ALTER TABLE `char` ADD `font` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0';
Thank You
default_smile.png


 
Last edited by a moderator:
I've reached a very similar SQL to yours, please compare and remember to make a backup before applying (I haven't tested them but there shouldn't be problems):

-- rAthena to Hercules main database upgrade query.-- Please don't use if too outdated.-- Remember to make a backup before applying.-- Apply in the same database you applied your main.sql-- Last revision: November 2, 2013-- Drop table `skillcooldown` since it's not used in HerculesDROP TABLE IF EXISTS `skillcooldown`;-- Upgrades for table `cart_inventory`ALTER TABLE `cart_inventory` MODIFY `equip` INT(11) UNSIGNED NOT NULL default '0', DROP COLUMN `bound`;-- 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', DROP COLUMN `bound`;-- Upgrades for table `inventory`ALTER TABLE `inventory` MODIFY `equip` INT(11) UNSIGNED NOT NULL default '0', DROP COLUMN `bound`;---- 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 enterINSERT 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 (1383167577);-- Updates to table `storage`ALTER TABLE `storage` MODIFY `equip` INT(11) UNSIGNED NOT NULL default '0', DROP COLUMN `bound`;---- 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', PRIMARY KEY (`account_id`)) ENGINE=MyISAM; uPaste.me mirror: http://upaste.me/7fbc8490ebb57a6a
Also, even if not needed, here's the log upgrade query:

-- rAthena to Hercules log database upgrade query.-- Please don't use if too outdated.-- Remember to make a backup before applying.-- Apply in the same database you applied your logs.sql-- Last revision: November 2, 2013-- Upgrades to table `picklog`ALTER TABLE `picklog` MODIFY `type` enum('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X','D','U','$') NOT NULL default 'P';-- Drop table `cashlog` since it's not used in HerculesDROP TABLE IF EXISTS `cashlog`;uPaste.me mirror: http://upaste.me/a011849121f6f38c
Hope it's useful.

 
Last edited by a moderator:
3rd time I am posting this(Updated 15th October, Will be missing 2-3 sql updates)

CREATE TABLE `account_data` ( `account_id` int(11) unsigned NOT NULL DEFAULT '0', `bank_vault` int(11) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`account_id`)) ENGINE=MyISAM;ALTER TABLE `cart_inventory` DROP COLUMN `bound`;ALTER TABLE `char` DROP COLUMN `moves` , ADD COLUMN `slotchange` smallint(3) unsigned NOT NULL DEFAULT 0 , ADD COLUMN `char_opt` int(11) unsigned NOT NULL DEFAULT '0';ALTER TABLE `guild_storage` DROP COLUMN `bound`;ALTER TABLE `inventory` DROP COLUMN `bound`;ALTER TABLE `picklog` MODIFY COLUMN `type` enum('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X','D','U') NOT NULL DEFAULT 'P';CREATE TABLE `sql_updates` ( `timestamp` int(11) unsigned NOT NULL, `ignored` enum('Yes','No') NOT NULL DEFAULT 'No', PRIMARY KEY (`timestamp`)) ENGINE=MyISAM;ALTER TABLE `storage` DROP COLUMN `bound`;DROP TABLE `cashlog`;DROP TABLE `skillcooldown`;-- Existent updates to enterINSERT 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);REPLACE INTO `interreg` (`varname`, `value`) VALUES('unique_id', '0');
1st Time: http://herc.ws/board/topic/2495-req-database-upgrades-from-rathena-to-hercules/?p=16526

2nd Time: http://herc.ws/board/topic/2619-moving-from-rathena-to-hercules/?hl=rathena

@jaBote

Can you please add one in git repo so they can directly get it from repo.

 
You must log in or register to reply here.
Back
Top