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

ALTER TABLE seasons ALTER COLUMN league_id INTEGER NULL;
GO

CREATE INDEX IDX_display_names_1 ON display_names (entity_id)
GO

CREATE INDEX IDX_display_names_2 ON display_names (entity_type)
GO

/*
 * Should be safe, as nothing is referencing this table presently
 * */
EXEC sp_rename 'team_american_football_stats', 'american_football_team_stats'
GO