Two solutions, either of which will (likely) work: 1. Say 'integer' rather than 'bigint'. You will still get an integer primary key up to 64 bits (as needed for its actual value.) 2. Do not say 'AUTOINCREMENT'. That is useless except in special cases which yours is probably not. Unless you require strictly ascending key values or must permanently retire key values, AUTOINCREMENT can be eliminated without adversely impacting the automatic selection of new key values.