The truncate method is does different things on different databases and depending if in a transation

Problem/Motivation

MySQL will reset a table sequence if a table is truncated SQLite and postgres will not.

Proposed resolution

Make everything behave the same.

Remaining tasks

User interface changes

API changes

Data model changes

For the committer

Please give commit credit to danblack → for his work on the closed duplicate issue → .