In SQLite3 sequence table created automatically and store AI informations for all tables in only one sequence table, if AUTOINCREMENT is selected in a table.
Maybe create_sequence, drop_sequence, and sequence_name are not needed anymore, and nextId has to be changed to the new sequence table, or to work without sequence table.
Maybe AUTOINCREMENT is needed, because AI works if PRIMARY KEY is present, too.
Maybe AUTOINCREMENT is obsolet, because the field has to be PRIMARY KEY to select AUTOINCREMENT.

In SQLite3 sequence table created automatically and store AI informations for all tables in only one sequence table, if
AUTOINCREMENTis selected in a table.Maybe
create_sequence,drop_sequence, andsequence_nameare not needed anymore, andnextIdhas to be changed to the new sequence table, or to work without sequence table.Maybe
AUTOINCREMENTis needed, because AI works ifPRIMARY KEYis present, too.Maybe
AUTOINCREMENTis obsolet, because the field has to bePRIMARY KEYto selectAUTOINCREMENT.