[schapplm]

Actually for this the API for mysql and mariadb will be identical and type issues I faced would also happen with mysql as the types used for id's when using sqlite are integers but you use text with a full sql database. That's why I was suggesting the correction.

I still do not get the MySQL / MariaDB issue. The SQL code you posted is identical to the queries I use in the source code to initially create the database. According to your statement, "that did it". So no need to change anything?
In your first post, you replace the types timestamp, tinyint, smallint and int with INTEGER.
Does this mean some versions of MariaDB/MySQL do not support these types? My intention when writing the code was that timestamp is much easier to read in manually inspection (e.g. using phpMyAdmin).
Using tinyint and smallint eventually reduces the space of the database (although perhaps not significantly). Generally, I would take the type with the least size that is able to contain the data.