SQL: 3ceam database migration to rAthena database

[xRaisen]

Hello,

We are using a 3ceam SVN til today. But we cant migrate nor upgrade it to rAthena because of due to the fact that they dont have the same SQL structures.

Im asking anyone that is willing to make a script/tools in order to migrate 3ceam to rAthena easily. If theres a manual way, I'd like to know also.

Thank you!

[Gepard]

Skill cooldown table can be deleted, because it is not needed in rAthena.

DROP TABLE `skillcooldown`;

Not sure about other differences.

[Joseph]

I saw these differences:

DROP TABLE `elemental`;
DROP TABLE `skillcooldown`;
ALTER table `login` CHANGE `level` `group_id` tinyint(3);

[Kanage]

i was planning on migrating my 3ceam to rathena too but not sure on how to migrate my sql database. thanks for the info now i will try to migrate mine. if theres any additional modification on the database kindly keep the post updated ^^ thanks again a big help

[Kirito]

Me too. I was planning migrating 3ceam to rAthena but I don't know too.

[Joseph]

Just tested it out (3ceam to rAthena).

Hope this will help.

SQL:

DROP TABLE `elemental`;
DROP TABLE `skillcooldown`;
ALTER TABLE `login` CHANGE `level` `group_id` tinyint(3);
ALTER TABLE `char` DROP `elemental_id`;
ALTER TABLE `char` ADD COLUMN `robe` smallint(6) NOT NULL default '0' AFTER `head_bottom`

[xazax]

Maybe it would worth to create a wiki page, to collect all the relevant data to help users migrate from 3CeAM and eAthena.

[Kirito]

Yea! that was a good idea for those who using 3ceam and eAthena.

[espriketic]

I want this too...

[Joseph]

Maybe it would worth to create a wiki page, to collect all the relevant data to help users migrate from 3CeAM and eAthena.

Great idea. Someone has to create a wiki page.

[mleo1]

3CeaM -> rAthena

DROP TABLE `skillcooldown`;
ALTER TABLE `login` CHANGE `level` `group_id` tinyint(3) NOT NULL default '0';
ALTER TABLE `char` CHANGE `weapon` `weapon` smallint(6)  unsigned NOT NULL default '0';
ALTER TABLE `char` ADD COLUMN `robe` smallint(6) UNSIGNED NOT NULL default '0' AFTER `head_bottom`

dunno the rest. might be wrong xD.

Edited April 25, 2012 by mleo1

[espriketic]

3CeaM -> rAthena

DROP TABLE `skillcooldown`;
ALTER TABLE `login` CHANGE `level` `group_id` tinyint(3) NOT NULL default '0';
ALTER TABLE `char` CHANGE `weapon` `weapon` smallint(6)  unsigned NOT NULL default '0';
ALTER TABLE `char` ADD COLUMN `robe` smallint(6) UNSIGNED NOT NULL default '0' AFTER `head_bottom`

dunno the rest. might be wrong xD.

is this working? have anyone tested this?