/*
 *  
 * 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;
GO

ALTER TABLE injury_phases ALTER COLUMN season_id INT NULL;
GO

ALTER TABLE injury_phases ADD phase_type VARCHAR(100);
GO

ALTER TABLE injury_phases ADD injury_side VARCHAR(100);
GO

ALTER TABLE american_football_action_participants ADD score_credit INT; 
GO

ALTER TABLE american_football_action_participants ADD yards_gained INT;
GO

ALTER TABLE american_football_event_states ADD context VARCHAR(40); 
GO

ALTER TABLE baseball_event_states ADD context VARCHAR(40);
GO

ALTER TABLE basketball_event_states ADD context VARCHAR(40);
GO

ALTER TABLE ice_hockey_event_states ADD context VARCHAR(40); 
GO

ALTER TABLE motor_racing_event_states ADD context VARCHAR(40); 
GO

ALTER TABLE soccer_event_states ADD context VARCHAR(40); 
GO

ALTER TABLE tennis_event_states ADD context VARCHAR(40); 
GO

ALTER TABLE american_football_action_plays ALTER COLUMN comment VARCHAR(255);
GO

ALTER TABLE baseball_action_plays ALTER COLUMN comment VARCHAR(255);
GO

ALTER TABLE baseball_action_substitutions ALTER COLUMN person_original_id INT NULL;
GO

ALTER TABLE baseball_action_substitutions ALTER COLUMN person_original_position_id INT NULL;
GO