Can a SQLite table have more unique fields other than the primary key?

I don't want a composite primary key. All I want is 开发者_如何学Cthat another field must be also unique.

Yes, you just need to mark the column as unique.

http://www.sqlite.org/lang_createtable.html

Look under SQL Data Constraints.