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

/*PATCHHERE*/
CREATE TABLE `roleexcat` (
  `ID` INT(16) UNSIGNED NOT NULL AUTO_INCREMENT,
  `role` INT NOT NULL ,
  `categoryID` INT NOT NULL,
  `createddate` DATETIME NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MYISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE UNIQUE INDEX ix_roleexcat_rolecat ON roleexcat (`role`, categoryID);

