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

/*
 * injury_phases modifications
 * */

/*
 * Weather additions
 * */

ALTER TABLE american_football_action_participants ADD COLUMN score_credit INTEGER; 
ALTER TABLE american_football_action_participants ADD COLUMN yards_gained INTEGER; 

ALTER TABLE weather_conditions ADD COLUMN weather_code VARCHAR(100); 
ALTER TABLE weather_conditions ADD COLUMN temperature_units VARCHAR(100); 

ALTER TABLE core_person_stats MODIFY COLUMN position_id INTEGER DEFAULT NULL;

/*
 * NEED TO SYNCRONIZE WITH LATEST UPDATES IN POSTGRES TRANSITON FILE
 * */

ALTER TABLE baseball_action_pitches DROP FOREIGN KEY FK_bas_act_pit_bas_eve_sta_id__bas_eve_sta_id;
ALTER TABLE baseball_action_pitches CHANGE baseball_event_state_id baseball_action_play_id INTEGER NOT NULL;
ALTER TABLE baseball_action_pitches ADD CONSTRAINT FK_baseball_action_plays_baseball_action_pitches FOREIGN KEY (baseball_action_play_id) REFERENCES baseball_action_plays (id);


ALTER TABLE baseball_action_pitches ADD COLUMN ball_type VARCHAR(100);
ALTER TABLE baseball_action_pitches ADD COLUMN strike_type VARCHAR(100);
ALTER TABLE baseball_action_pitches ADD COLUMN sequence_number INTEGER;