Hi, sql files use the inline "references" syntax, but the mysql docs say:
"Furthermore, InnoDB does not recognize or support “inline REFERENCES specifications” (as defined in the SQL standard) where the references are defined as part of the column specification. InnoDB accepts REFERENCES clauses only when specified as part of a separate FOREIGN KEY specification. For other storage engines, MySQL Server parses and ignores foreign key specifications." Quoted from: http://dev.mysql.com/doc/refman/5.1/en/create-table.html are those references just explanatory and are not intended for use by the rdbms? also, @shiny had a realization too -- http://shiny.status.net/notice/44979 :-) -- Thanks Shashi ( identi.ca/shashi ) _______________________________________________ StatusNet-dev mailing list StatusNet-dev@lists.status.net http://lists.status.net/mailman/listinfo/statusnet-dev
