In https://www.sqlite.org/lang_createtable.html the diagram for create-table-stmt contains a parenthesized list of column-def and table-constraint, which I'll represent in a pseudo-grammar here:
"(" <column-def> ("," <column-def>)* (<table-constraint> ",")* ")" However, that would forbid (foo, bar, PRIMARY_KEY foo) and require instead something like (foo, bar PRIMARY_KEY foo,). The fix is to change the <table-constraint> "," loop to instead be "," <table-constraint>. - Tim McCormack _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users