Migrate of rAthena to Hercules (MySQL Modifications)

[tmav94]

What changes I need to do to migrate of rAthena to Hercules...

I have a database with more than 4k accounts and i don't want wipe him out.

@edit

https://github.com/HerculesWS/Hercules/blob/master/sql-files/upgrades/rAthena-logs-upgrade.sql

https://github.com/HerculesWS/Hercules/blob/master/sql-files/upgrades/rAthena-main-upgrade.sql

It's work with the latest rAthena update?

@EDIT


ERROR while use main-upgrade
 

Erro

Query SQL:

-- Upgrades for table `char`
ALTER TABLE `char` CHANGE `moves` `slotchange` SMALLINT( 3 ) UNSIGNED NOT NULL DEFAULT '0',
ADD `char_opt` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `slotchange` ,
MODIFY `font` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `char_opt` ,
ADD `uniqueitem_counter` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `unban_time` ;
 

Mensagem do MySQL: 

#1060 - Duplicate column name 'uniqueitem_counter' 

@EDIT

Have so many erros in this upgrades... Can someone help me?

Bump?

 

[Dastgir]

Those SQL files have got outdated