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

/*PATCHHERE*/
create index ix_releases_bookinfoID on releases (bookinfoID);
create index ix_releases_musicinfoID on releases (musicinfoID);
create index ix_bookinfo_title on bookinfo (title);
create index ix_movieinfo_title on movieinfo (title);
create index ix_musicinfo_title on musicinfo (title);
create index ix_consoleinfo_title on consoleinfo (title);