Fix default values for database tables

[ChrisSchinnerl]

We should go through the schemas and clean up the default values of our tables where possible.
e.g. hosts have timestamps which are numbers that can be NULL right now so we need a COALSCE before scanning them when it would be easier to just default to 0.
JSON columns for hosts that haven't been scanned yet should probably also default to '{}' etc.