error in mysql syntax
- by fusion
while executing the following query, i get an error that there's an error in the syntax near line 9. since i'm using mysql workbench, i can't really figure out what could be wrong:
CREATE TABLE IF NOT EXISTS `proquotes`.`thquotes` (
`idQuotes` INT NOT NULL AUTO_INCREMENT ,
`vAuthorID` VARCHAR(8) CHARACTER SET 'utf8' NOT NULL ,
`vAuthor` VARCHAR(45) CHARACTER SET 'utf8' NOT NULL ,
`cQuotes` MEDIUMTEXT CHARACTER SET 'utf8' NOT NULL ,
`cArabic` MEDIUMTEXT CHARACTER SET 'utf8' NOT NULL ,
`vReference` VARCHAR(100) CHARACTER SET 'utf8' NOT NULL ,
PRIMARY KEY (`idQuotes`) ,
INDEX `vAuthorID` () ,
CONSTRAINT `vAuthorID`
FOREIGN KEY ()
REFERENCES `proquotes`.`author_info` ()
ON DELETE NO ACTION
ON UPDATE NO ACTION)
DEFAULT CHARACTER SET = utf8;