For existing DB, altering the table may be doable with schema editing and clean up of sqlite_sequence.