if (iVersion < 51)
{
// Add iOrder fields to actorlink* tables to be able to list
// actors by importance
m_pDS->exec("ALTER TABLE actorlinkmovie ADD iOrder integer");
m_pDS->exec("ALTER TABLE actorlinktvshow ADD iOrder integer");
m_pDS->exec("ALTER TABLE actorlinkepisode ADD iOrder integer");
}
if (iVersion < 52)
{ // Add basepath link to path table for faster content retrieval, and indicies
m_pDS->exec("ALTER TABLE movie ADD c23 text");
m_pDS->exec("ALTER TABLE episode ADD c23 text");
m_pDS->exec("ALTER TABLE musicvideo ADD c23 text");
m_pDS->exec("ALTER TABLE tvshow ADD c23 text");
m_pDS->dropIndex("movie", "ixMovieBasePath");
m_pDS->dropIndex("musicvideo", "ixMusicVideoBasePath");
m_pDS->dropIndex("episode", "ixEpisodeBasePath");
m_pDS->dropIndex("tvshow", "ixTVShowBasePath");
m_pDS->exec("CREATE INDEX ixMovieBasePath ON movie ( c23(12) )");
m_pDS->exec("CREATE INDEX ixMusicVideoBasePath ON musicvideo ( c14(12) )");
m_pDS->exec("CREATE INDEX ixEpisodeBasePath ON episode ( c19(12) )");
m_pDS->exec("CREATE INDEX ixTVShowBasePath ON tvshow ( c17(12) )");
// now update the base path links
UpdateBasePathID("movie", "idMovie", VIDEODB_ID_BASEPATH, VIDEODB_ID_PARENTPATHID);
UpdateBasePathID("musicvideo", "idMVideo", VIDEODB_ID_MUSICVIDEO_BASEPATH, VIDEODB_ID_MUSICVIDEO_PARENTPATHID);
UpdateBasePathID("episode", "idEpisode", VIDEODB_ID_EPISODE_BASEPATH, VIDEODB_ID_EPISODE_PARENTPATHID);
UpdateBasePathID("tvshow", "idShow", VIDEODB_ID_TV_BASEPATH, VIDEODB_ID_TV_PARENTPATHID);
}
