yEMnd4M2

1Executing SQL script in server
2ERROR: Error 1064: You have an error in your SQL syntax; check the 
3manual that corresponds to your MySQL server version for the right 
4syntax to use near ')
5    REFERENCES `project2`.`REF` ()
6    ON DELETE CASCADE
7    ON UPDATE CASCADE' at line 6
8SQL Code:
9        CREATE TABLE IF NOT EXISTS `project2`.`REF_AUTH` (
10          `REF#` INT(11) NOT NULL AUTO_INCREMENT,
11          `RAUTHOR` VARCHAR(45) NOT NULL,
12          PRIMARY KEY (`REF#`, `RAUTHOR`),
13          CONSTRAINT `REF#`
14            FOREIGN KEY ()
15            REFERENCES `project2`.`REF` ()
16            ON DELETE CASCADE
17            ON UPDATE CASCADE)
18        ENGINE = InnoDB
19        DEFAULT CHARACTER SET = big5
20
21SQL script execution finished: statements: 4 succeeded, 1 failed