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

ALTER TABLE seasons MODIFY league_id INTEGER NULL;

ALTER TABLE display_names ADD INDEX IDX_display_names_1 (entity_id);
ALTER TABLE display_names ADD INDEX IDX_display_names_2 (entity_type);

ALTER TABLE team_american_football_stats RENAME TO american_football_team_stats;