/*
 *  
 * 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 MODIFY sequence_number DECIMAL(4,1);
ALTER TABLE baseball_action_pitches MODIFY sequence_number DECIMAL(4,1);
ALTER TABLE baseball_action_substitutions MODIFY sequence_number DECIMAL(4,1);


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