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

/*PATCHHERE*/
CREATE TABLE releaseregextesting (
  ID int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
  fromname varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `date` datetime NOT NULL,
  binaryhash varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  groupname varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  regexID int(11) unsigned DEFAULT NULL,
  categoryID int(11) unsigned DEFAULT NULL,
  reqID varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  blacklistID int(11) NOT NULL,
  size bigint(20) NOT NULL,
  dateadded timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (ID),
  UNIQUE KEY ix_releaseregextesting_binaryhash (binaryhash)
) ENGINE=MYISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci AUTO_INCREMENT=1;
