(05.04.2009, 20:17)milos Wrote: Yes i have an error in the SQL! I think that will be right:

Code:

ALTER TABLE `villages` ADD `statue` INT( 15 ) NULL DEFAULT '0' AFTER `place`  ;
ALTER TABLE `villages` ADD `all_unit_knight` INT( 6 ) NULL DEFAULT '0' AFTER `all_unit_catapult` ;
ALTER TABLE `unit_place` ADD `unit_knight` INT( 11 ) NULL DEFAULT '0' AFTER `unit_catapult` ;
ALTER TABLE `villages` ADD `unit_knight_tec_level` INT( 11 ) NULL DEFAULT '1' AFTER `unit_catapult_tec_level` ;