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

ALTER TABLE seasons ALTER COLUMN  league_id DROP NOT NULL;

CREATE INDEX IDX_display_names_1 ON display_names (entity_id);
CREATE INDEX IDX_display_names_2 ON display_names (entity_type);

ALTER TABLE team_american_football_stats RENAME TO american_football_team_stats;