Move rAthena to Hercules

[Kichi 6]

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

Edited November 2, 2013 by Kichi

[jaBote 438]

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.

[Dastgir 1244]

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.