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

/*PATCHHERE*/
alter table releasefiles add crc32 varchar(255) null;
create index ix_releasefiles_crc32 on releasefiles (crc32);

DELETE a
FROM releasefiles as a, releasefiles as b
WHERE a.releaseID = b.releaseID AND a.name = b.name
AND a.ID < b.ID;

drop index ix_releasefiles_releaseID on releasefiles;
drop index ix_releasefiles_name on releasefiles;
CREATE UNIQUE INDEX ix_releasefiles_releaseID ON releasefiles (releaseID, name);

alter table releaseregex add poster varchar(255) NULL;