/*UPDATEREVISION*/
INSERT INTO site (`setting`, `value`, `updateddate` ) VALUES ('dbversion', '$Rev: 4241 $', now()) ON DUPLICATE KEY UPDATE `value` = VALUES(`value`), updateddate=now();

/*PATCHHERE*/
INSERT INTO site (`setting`, `value`, `updateddate` ) VALUES ('lookupdeezer', '0', now());
alter table musicinfo add `deezeralbumID` int(10) ;
create index ix_releases_imdbID_categoryID_postdate on releases(categoryID, imdbID, postdate desc);
create index ix_releases_musicinfoID_categoryID_postdate on releases(categoryID, musicinfoID, postdate desc);
create index ix_releases_consoleinfoID_categoryID_postdate on releases(categoryID, consoleinfoID, postdate desc);
create index ix_releases_tvinfoID_categoryID_postdate on releases(categoryID, tvinfoID, postdate desc);
create index ix_releases_groupid_adddate on releases (groupid, adddate);
create index ix_releasefiles_releaseID_extension on releasefiles(releaseID, extension);
create index ix_releasefiles_releaseID_name on releasefiles(releaseID, name);
create index ix_releasefiles_name on releasefiles (name);
create index ix_tvinfo_cover_localonly on tvinfo(cover, localonly);
create index ix_groups_name on groups (name desc);

