On Mar 12, 2012, at 11:11 PM, Alex Queiroz wrote: > id INTEGER PRIMARY KEY, > CREATE UNIQUE INDEX IF NOT EXISTS 'userIdentityByID' ON 'user_identity' > (id ASC);
Not directly related to your problem, but… these two clauses are redundant… a primary key is unique by definition… no point adding another unique index on top of it... _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users