Nemanja Corlija wrote:
I think in any other case unique index would be created as expected.
sqlite> drop table test;sqlite> create table test (ni integer, pk_name varchar(32) primary key, info integer);
sqlite> pragma index_list(test); 0|sqlite_autoindex_test_1|1 sqlite> pragma table_info(test); 0|ni|integer|0||0 1|pk_name|varchar(32)|0||1 2|info|integer|0||0 sqlite> that seems to be correct... interesting, thanks, Mario