SQL base from non-vitality to vitality Releases ?

[ksmxbg]

how to transfer SQL database(dump and backup saved), from crashed server

L2J Revision 3349: - no vitality system
L2JDP Revision 6457:

to new revisions with vitality system like:

L2J Revision 3425: - with vitality system
L2JDP Revision 6519:

to avoid errors like " Unknown column 'vitality_points' in 'field list' . Thanks in advise.

[janiii]

http://www.l2jdp.com/trac/browser/trunk ... l?rev=6515

Code: Select all

ALTER TABLE `characters` ADD `vitality_points` SMALLINT UNSIGNED NOT NULL DEFAULT 0 AFTER `bookmarkslot`;

[ksmxbg]

janii you are like a flash - it works prefect

super big thanks, gl