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

/*PATCHHERE*/
create index ix_releases_completion on releases (completion);

alter table releasefiles add extension varchar(255) null;
update releasefiles set extension = LOWER(SUBSTRING_INDEX(name,'.',-1));
create index ix_releasefiles_extension on releasefiles (extension);
