And what exactly, pray tell, does that have to do with anything? AUTOINCREMENT can only be used with INTEGER PRIMARY KEY as it modifies the INTEGER PRIMARY KEY (rowid) selection algorithm for rowid tables. BIGINT PRIMARY KEY is not an explicit declaration of the rowid so therefore the AUTOINCREMENT keyword cannot be used in that context.