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

/*
 * injury_phases modifications
 * */

ALTER TABLE injury_phases DROP CONSTRAINT FK_inj_pha_sea_id__sea_id;
ALTER TABLE injury_phases ALTER COLUMN season_id DROP NOT 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 ALTER COLUMN comment TYPE VARCHAR(255);
ALTER TABLE baseball_action_plays ALTER COLUMN comment TYPE VARCHAR(255);

ALTER TABLE baseball_action_substitutions ALTER COLUMN person_original_id DROP NOT NULL;
ALTER TABLE baseball_action_substitutions ALTER COLUMN person_original_position_id DROP NOT NULL;

ALTER TABLE baseball_action_substitutions ALTER COLUMN person_original_id DROP NOT NULL;
ALTER TABLE baseball_action_substitutions ALTER COLUMN person_original_position_id DROP NOT NULL;