CODE EXAMPLE FOR SQL

sqlite reset autoincrement

delete from your_table;    
delete from sqlite_sequence where name='your_table';