sqlite when deleting row autoincrement keeps growing code example
Example: flutter sqlite auto incrementing id primary key
db.execSQL("create table " + TABLE__WORK + " (ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,Name TEXT, Title TEXT, Time TEXT, Date TEXT)");