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

ALTER TABLE positions ALTER COLUMN abbreviation TYPE VARCHAR(100);

CREATE TABLE ice_hockey_action_plays (
    id SERIAL UNIQUE NOT NULL,
    ice_hockey_event_state_id INTEGER NOT NULL,
    play_type VARCHAR(100),
    score_attempt_type VARCHAR(100),
    play_result VARCHAR(100),
    comment VARCHAR(255)
);

CREATE TABLE ice_hockey_action_participants (
    id SERIAL UNIQUE NOT NULL,
    ice_hockey_action_play_id INTEGER NOT NULL,
    person_id INTEGER NOT NULL,
    participant_role VARCHAR(100) NOT NULL,
    point_credit INTEGER
);

ALTER TABLE person_phases ADD COLUMN entry_reason VARCHAR(40); 
ALTER TABLE person_phases ADD COLUMN exit_reason VARCHAR(40); 
ALTER TABLE person_phases ADD COLUMN selection_level INTEGER; 
ALTER TABLE person_phases ADD COLUMN selection_sublevel INTEGER; 
ALTER TABLE person_phases ADD COLUMN selection_overall INTEGER; 
ALTER TABLE person_phases ALTER COLUMN  regular_position_id DROP NOT NULL;
ALTER TABLE person_phases ALTER COLUMN regular_position_depth TYPE VARCHAR(40);