SQLite database wrong datatype and best practice

[JimToupet]

Currently, the STHS output SQLite database and table with column type that are not standard for SQLite :

Ex. :
string
currency
currrency (with 3 r)
timestamp
and maybe more

Ref.:
https://www.tutorialspoint.com/sqlite/s ... _types.htm
https://www.sqlite.org/datatype3.html

That should be corrected to prevent any future behavior.

Also, all tables should have an primary key. Many have already primary key but many others not.

This are not big issues (and probably not big to solve too) but would help to provide a more standard database with best practice.

[SimonT]

This is not an issue for me.