UPDATE seven_signs SET dawn_red_stones = dawn_red_stones + dusk_red_stones, dawn_green_stones = dawn_green_stones + dusk_green_stones, dawn_blue_stones = dawn_blue_stones + dusk_blue_stones, dawn_ancient_adena_amount = dawn_ancient_adena_amount + dusk_ancient_adena_amount, dawn_contribution_score = dawn_contribution_score + dusk_contribution_score; ALTER TABLE seven_signs CHANGE COLUMN dawn_red_stones red_stones INT(10) NOT NULL DEFAULT 0, CHANGE COLUMN dawn_green_stones green_stones INT(10) NOT NULL DEFAULT 0, CHANGE COLUMN dawn_blue_stones blue_stones INT(10) NOT NULL DEFAULT 0, CHANGE COLUMN dawn_ancient_adena_amount ancient_adena_amount INT(10) NOT NULL DEFAULT 0, CHANGE COLUMN dawn_contribution_score contribution_score INT(10) NOT NULL DEFAULT 0, DROP COLUMN dusk_red_stones, DROP COLUMN dusk_green_stones, DROP COLUMN dusk_blue_stones, DROP COLUMN dusk_ancient_adena_amount, DROP COLUMN dusk_contribution_score;