/*
 *  
 * Script to update the xtoss schema between version 14 and 15.
 */

/*
 * injury_phases modifications
 * */

ALTER TABLE injury_phases DROP FOREIGN KEY FK_inj_pha_sea_id__sea_id;
ALTER TABLE injury_phases MODIFY COLUMN season_id INTEGER DEFAULT NULL;
ALTER TABLE injury_phases ADD COLUMN phase_type VARCHAR(100);
ALTER TABLE injury_phases ADD COLUMN injury_side VARCHAR(100);
ALTER TABLE american_football_action_participants ADD COLUMN score_credit INTEGER;
ALTER TABLE american_football_action_participants ADD COLUMN yards_gained INTEGER;

ALTER TABLE american_football_event_states ADD COLUMN context VARCHAR(40); 
ALTER TABLE baseball_event_states ADD COLUMN context VARCHAR(40);
ALTER TABLE basketball_event_states ADD COLUMN context VARCHAR(40);
ALTER TABLE ice_hockey_event_states ADD COLUMN context VARCHAR(40); 
ALTER TABLE motor_racing_event_states ADD COLUMN context VARCHAR(40); 
ALTER TABLE soccer_event_states ADD COLUMN context VARCHAR(40); 
ALTER TABLE tennis_event_states ADD COLUMN context VARCHAR(40); 

ALTER TABLE american_football_action_plays MODIFY COLUMN comment VARCHAR(255);
ALTER TABLE baseball_action_plays MODIFY COLUMN comment VARCHAR(255);

ALTER TABLE baseball_action_substitutions MODIFY COLUMN person_original_id INTEGER DEFAULT NULL;
ALTER TABLE baseball_action_substitutions MODIFY COLUMN person_original_position_id INTEGER DEFAULT NULL;