Add multikeys to SQL Items

DELETE FROM evolutions WHERE evolution_id IN (SELECT * FROM (SELECT e1.evolution_id FROM evolutions e1 JOIN evolutions e2 USING (to_id) WHERE e1.tstamp < e2.tstamp) t);
ALTER TABLE evolutions MODIFY COLUMN evolution_id int(11);
ALTER TABLE evolutions DROP PRIMARY KEY;
ALTER TABLE evolutions ADD CONSTRAINT PRIMARY KEY (to_id);
ALTER TABLE evolutions DROP COLUMN evolution_id;

DELETE FROM evolutions_na WHERE evolution_id IN (SELECT * FROM (SELECT e1.evolution_id FROM evolutions_na e1 JOIN evolutions_na e2 USING (to_id) WHERE e1.tstamp < e2.tstamp) t);
ALTER TABLE evolutions_na MODIFY COLUMN evolution_id int(11);
ALTER TABLE evolutions_na DROP PRIMARY KEY;
ALTER TABLE evolutions_na ADD CONSTRAINT PRIMARY KEY (to_id);
ALTER TABLE evolutions_na DROP COLUMN evolution_id;

ALTER TABLE transformations MODIFY COLUMN transformation_id int(11);
ALTER TABLE transformations DROP PRIMARY KEY;
ALTER TABLE transformations ADD CONSTRAINT PRIMARY KEY (from_monster_id, to_monster_id);
ALTER TABLE transformations DROP COLUMN transformation_id;

ALTER TABLE transformations_na MODIFY COLUMN transformation_id int(11);
ALTER TABLE transformations_na DROP PRIMARY KEY;
ALTER TABLE transformations_na ADD CONSTRAINT PRIMARY KEY (from_monster_id, to_monster_id);
ALTER TABLE transformations_na DROP COLUMN transformation_id;

ALTER TABLE awakenings MODIFY COLUMN awakening_id int(11);
ALTER TABLE awakenings DROP PRIMARY KEY;
ALTER TABLE awakenings ADD CONSTRAINT PRIMARY KEY (monster_id, order_idx);
ALTER TABLE awakenings DROP COLUMN awakening_id;

ALTER TABLE awakenings_na MODIFY COLUMN awakening_id int(11);
ALTER TABLE awakenings_na DROP PRIMARY KEY;
ALTER TABLE awakenings_na ADD CONSTRAINT PRIMARY KEY (monster_id, order_idx);
ALTER TABLE awakenings_na DROP COLUMN awakening_id;

ALTER TABLE purchases MODIFY COLUMN purchase_id int(11);
ALTER TABLE purchases DROP PRIMARY KEY;
ALTER TABLE purchases ADD CONSTRAINT PRIMARY KEY (server_id, target_monster_id, start_timestamp, end_timestamp);
ALTER TABLE purchases DROP INDEX pid;
ALTER TABLE purchases DROP COLUMN purchase_id;

ALTER TABLE fixed_team_monsters MODIFY COLUMN fixed_team_monster_id int(11);
ALTER TABLE fixed_team_monsters DROP PRIMARY KEY;
ALTER TABLE fixed_team_monsters ADD CONSTRAINT PRIMARY KEY (fixed_team_id, order_idx);
ALTER TABLE fixed_team_monsters DROP COLUMN fixed_team_monster_id;

ALTER TABLE active_skills_subskills MODIFY COLUMN active_skills_subskills_id int(11);
ALTER TABLE active_skills_subskills DROP PRIMARY KEY;
ALTER TABLE active_skills_subskills ADD CONSTRAINT PRIMARY KEY (active_skill_id, active_subskill_id, order_idx);
ALTER TABLE active_skills_subskills DROP COLUMN active_skills_subskills_id;

ALTER TABLE active_skills_subskills_na MODIFY COLUMN active_skills_subskills_id int(11);
ALTER TABLE active_skills_subskills_na DROP PRIMARY KEY;
ALTER TABLE active_skills_subskills_na ADD CONSTRAINT PRIMARY KEY (active_skill_id, active_subskill_id, order_idx);
ALTER TABLE active_skills_subskills_na DROP COLUMN active_skills_subskills_id;

ALTER TABLE active_subskills_parts MODIFY COLUMN active_subskills_parts_id int(11);
ALTER TABLE active_subskills_parts DROP PRIMARY KEY;
ALTER TABLE active_subskills_parts ADD CONSTRAINT PRIMARY KEY (active_subskill_id, active_part_id, order_idx);
ALTER TABLE active_subskills_parts DROP COLUMN active_subskills_parts_id;

ALTER TABLE active_subskills_parts_na MODIFY COLUMN active_subskills_parts_id int(11);
ALTER TABLE active_subskills_parts_na DROP PRIMARY KEY;
ALTER TABLE active_subskills_parts_na ADD CONSTRAINT PRIMARY KEY (active_subskill_id, active_part_id, order_idx);
ALTER TABLE active_subskills_parts_na DROP COLUMN active_subskills_parts_id;

ALTER TABLE exchanges MODIFY COLUMN exchange_id int(11);
ALTER TABLE exchanges DROP PRIMARY KEY;
ALTER TABLE exchanges ADD CONSTRAINT PRIMARY KEY (trade_id, server_id);
ALTER TABLE exchanges DROP COLUMN exchange_id;

ALTER TABLE egg_machines_monsters MODIFY COLUMN egg_machine_monster_id int(11);
ALTER TABLE egg_machines_monsters DROP PRIMARY KEY;
ALTER TABLE egg_machines_monsters ADD COLUMN server_id int(11);
ALTER TABLE egg_machines_monsters ADD COLUMN machine_row int(11);
ALTER TABLE egg_machines_monsters ADD COLUMN machine_type int(11);
UPDATE egg_machines_monsters LEFT JOIN egg_machines USING (egg_machine_id) SET egg_machines_monsters.server_id=egg_machines.server_id, egg_machines_monsters.machine_row=egg_machines.machine_row, egg_machines_monsters.machine_type=egg_machines.machine_type;
ALTER TABLE egg_machines_monsters MODIFY COLUMN server_id int(11) NOT NULL;
ALTER TABLE egg_machines_monsters MODIFY COLUMN machine_row int(11) NOT NULL;
ALTER TABLE egg_machines_monsters MODIFY COLUMN machine_type int(11) NOT NULL;
ALTER TABLE egg_machines_monsters ADD CONSTRAINT PRIMARY KEY (server_id, machine_row, machine_type, monster_id);
ALTER TABLE egg_machines_monsters DROP COLUMN egg_machine_monster_id;

ALTER TABLE egg_machines MODIFY COLUMN egg_machine_id int(11);
ALTER TABLE egg_machines DROP PRIMARY KEY;
ALTER TABLE egg_machines ADD CONSTRAINT PRIMARY KEY (server_id, machine_row, machine_type);
ALTER TABLE egg_machines DROP COLUMN egg_machine_id;
TsubakiBotPad / pad-data-pipeline

Add multikeys to SQL Items #449
