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

/*PATCHHERE*/
create index ix_releases_releasenfoID on releases(releasenfoID);
create index ix_releases_passwordstatus on releases(passwordstatus);
create index ix_releases_haspreview on releases(haspreview);
create index ix_category_parentID on category(parentID);
create index ix_releases_bookinfoID_category on releases(bookinfoID, categoryID);
create index ix_releases_tvinfoID_category on releases(tvinfoID, categoryID);