   CONSTRAINT `category`
     FOREIGN KEY (`catid` , `catevid`)
     REFERENCES `judo`.`categories` (`catid` , `evid`)
-    ON DELETE NO ACTION
+    ON DELETE CASCADE
     ON UPDATE NO ACTION,
   CONSTRAINT `person`
     FOREIGN KEY (`id`)

  CONSTRAINT `event_id`
    FOREIGN KEY (`evid`)
    REFERENCES `judo`.`events` (`evid`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
AUTO_INCREMENT = 4
DEFAULT CHARACTER SET = latin1;



  `organization` VARCHAR(45) NULL DEFAULT NULL,
  `date` DATETIME NOT NULL,
  `pic` VARCHAR(45) NULL DEFAULT NULL,
  `description` VARCHAR(90) NULL DEFAULT NULL,
  PRIMARY KEY (`evid`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
