Description: ------------ Summary says it. Reproduce code: --------------- $sql = " CREATE TABLE schedules ( id int(11) NOT NULL auto_increment, target_id int(11) NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM;"; $_SQLParser = new SQL_Parser(NULL, 'MySQL'); $parseRes = $_SQLParser->parse($sql); Actual result: -------------- Parse error: Unexpected token auto_increment on line 13 id int(11) NOT NULL auto_increment, ^ found: "auto_increment"

Here's the patch: Index: Parser.php =================================================================== --- Parser.php (revision 2679) +++ Parser.php (working copy) @@ -337,6 +337,10 @@ case 'null': $haveValue = false; break; + case 'auto_increment': + $constraintOpts = array('type'=>'auto_increment', + 'value'=>true); + break; default: return $this->raiseError('Unexpected token ' .$this->lexer->tokText);

Now, we're getting into dialect-specific stuff. I applied the patch, but is there a good way to get this into Dialect_MySQL instead? There has to be a generalized way to put hooks into the various parse functions.