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

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

CREATE TABLE ice_hockey_action_plays (
    id INT IDENTITY (1,1) NOT NULL PRIMARY KEY,
    ice_hockey_event_state_id INTEGER NOT NULL,
    play_type VARCHAR(100),
    score_attempt_type VARCHAR(100),
    play_result VARCHAR(100),
    comment VARCHAR(255)
);
GO


CREATE TABLE ice_hockey_action_participants (
    id INT IDENTITY (1,1) NOT NULL PRIMARY KEY,
    ice_hockey_action_play_id INTEGER NOT NULL,
    person_id INTEGER NOT NULL,
    participant_role VARCHAR(100) NOT NULL,
    point_credit INTEGER
);
GO

ALTER TABLE person_phases ADD entry_reason VARCHAR(40); 
GO

ALTER TABLE person_phases ADD exit_reason VARCHAR(40); 
GO

ALTER TABLE person_phases ADD selection_level INTEGER; 
GO

ALTER TABLE person_phases ADD selection_sublevel INTEGER; 
GO

ALTER TABLE person_phases ADD selection_overall INTEGER; 
GO

ALTER TABLE person_phases ALTER COLUMN regular_position_id INTEGER NULL;
GO

ALTER TABLE person_phases ALTER COLUMN regular_position_depth VARCHAR(40) NULL;
GO