SQLite auto-increment non-primary key field
Is it possible to have a non-primary key to be auto-incremented with every insertion? For example, I want to have a log, where every log entry has a primary key (for internal use), and a revision ...