Closed mark-grimes closed 6 years ago
Currently, if you run tracking off line and save to an SQLite file the row ID in the database is not set. It turns out SQLite has some idiosyncrasies when specifying the primary key in order to get the auto incrementing required behaviour.
This PR turns
"id INT AUTO_INCREMENT PRIMARY KEY"
into
"id INTEGER PRIMARY KEY AUTOINCREMENT"
if the output is to SQLite.
Currently, if you run tracking off line and save to an SQLite file the row ID in the database is not set. It turns out SQLite has some idiosyncrasies when specifying the primary key in order to get the auto incrementing required behaviour.
This PR turns
"id INT AUTO_INCREMENT PRIMARY KEY"into
"id INTEGER PRIMARY KEY AUTOINCREMENT"if the output is to SQLite.