sql syntax error 1064 in workbench-generated script
Give this a try, your issue was the syntax with the foreign key and the references.

CREATE TABLE IF NOT EXISTS `project2`.`REF_AUTH` (
  `REF#` INT(11) NOT NULL AUTO_INCREMENT,
  `RAUTHOR` VARCHAR(45) NOT NULL,
   PRIMARY KEY (`REF#`, `RAUTHOR`),
   CONSTRAINT `REF#`
      FOREIGN KEY (`REF#`) REFERENCES `REF` (`REF#`) 
      ON DELETE CASCADE
      ON UPDATE CASCADE)
   ENGINE = InnoDB
   DEFAULT CHARACTER SET = big5


Syntax link

Another helpful link