SQLite: Add after delete trigger to existing database that is using AUTOINCREMENT to set the docs table sequence to the largest doc_id in use. #63
Description
When PDFKeeper is using SQLite database a docs_after_delete trigger will be added to the database if AUTOINCREMENT is being used and the trigger does not exist.
The trigger will perform the following after a delete:
create trigger docs_after_delete after delete on docs begin
update sqlite_sequence set seq = (select max(doc_id) from docs) where name='docs';
end;