/*
 *  
 * Script to update the sportsdb schema between version 22 and 23.
 */

ALTER TABLE affiliation_phases ADD COLUMN root_id INTEGER;

ALTER TABLE document_contents ADD COLUMN abstract_blob TEXT; 

ALTER TABLE baseball_event_states ALTER COLUMN sequence_number TYPE NUMERIC(4,1);
ALTER TABLE baseball_action_pitches ALTER COLUMN sequence_number TYPE NUMERIC(4,1);
ALTER TABLE baseball_action_substitutions ALTER COLUMN sequence_number TYPE NUMERIC(4,1);


DELETE FROM db_info;
INSERT INTO db_info (version) VALUES ('23');