You are supposing that INT PRIMARY KEY == INTEGER PRIMARY KEY. Which, clearly, is not true. http://stackoverflow.com/questions/20289410/difference-between-int-primary-key-and-integer-primary-key-sqlite see this link for more on the subject.
2014-11-16 13:56 GMT-02:00 Igor Tandetnik <i...@tandetnik.org>: > On 11/16/2014 10:51 AM, Paul Sanderson wrote: > >> AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY >> > > No it's not a bug. AUTOINCREMENT is only allowed on INTEGER PRIMARY KEY. > Which part of the error message do you find unclear? > > For details, see http://www.sqlite.org/autoinc.html > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Bernardo Sulzbach _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users