ALTER TABLE `olympiad_nobles` DROP COLUMN `char_name`; ALTER TABLE `olympiad_nobles` ADD COLUMN `competitions_won` decimal(3,0) NOT NULL DEFAULT 0; ALTER TABLE `olympiad_nobles` ADD COLUMN `competitions_lost` decimal(3,0) NOT NULL DEFAULT 0; ALTER TABLE `olympiad_nobles` ADD COLUMN `competitions_drawn` decimal(3,0) NOT NULL DEFAULT 0;