Database Layout

I have started creating a minimal web interface (in python/web2py) that contains only the most important information. I tried accessing the database but I get an error on the table clients because of a field type mismatch.
The clients tables contains lastbackup,lastseen,lastbackup_image with the type date, but the content seems DATETIME or TIMESTAMP .

Is the wrong type intended or should I create a bugreport?


As you are saying, it is wrong. SQLite does not take the data types seriously. Can you somehow work around your problems?

Changing the data type would not be easy as the whole table would have to be recreated.


Yes we will work around without changing the database.