database improvements

This pull request adds some default values for several columns and adjusts the formatting.

Notice: All changes to other files then the `install.sql` are made by github due to your `.gitattributes` file.