Error
SQL query:
CREATE TABLE `auth` (
`id` INTEGER NOT NULL AUTO_INCREMENT ,
`modlist_name` VARCHAR( 20 ) NOT NULL ,
`lookup` INTEGER NOT NULL ,
`user_id` INTEGER NOT NULL ,
`created_at` DATETIME,
`outcome_type` VARCHAR,
PRIMARY KEY ( `id` ) ,
INDEX `auth_FI_1` ( `modlist_name` ) ,
CONSTRAINT `auth_FK_1` FOREIGN KEY ( `modlist_name` ) REFERENCES `modlist` ( `name` ) ,
INDEX `auth_FI_2` ( `user_id` ) ,
CONSTRAINT `auth_FK_2` FOREIGN KEY ( `user_id` ) REFERENCES `user` ( `id` ) ,
INDEX `auth_FI_3` ( `outcome_type` ) ,
CONSTRAINT `auth_FK_3` FOREIGN KEY ( `outcome_type` ) REFERENCES `outcome` ( `type` )
) TYPE = InnoDB COMMENT = 'User responses to mods'
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
PRIMARY KEY (`id`),
INDEX `auth_FI_1` (`modlist_name`),
CONSTRAINT `auth_' at line 8