I have a little SQLite database on a website, when I set up the tables using the CREATE directive, the ENTRY_ID was set up with the following.

CREATE TABLE visitors(ENTRY_ID INTEGER PRIMARY KEY AUTOINCREMENT, REQUEST_TIME INTEGER, USER_IP... ... ...

However... the table is not "Auto Incrementing" and the ENTRY_ID fields are empty...

My query is how is it best to move forward with altering the primary key to actually auto increment keeping in mind that the table has nearly 34,000 entries in it.