refactor(server): set an appropriate default timestamp precision for datetime/timestamp DB columns

refactor(server): set an appropriate default timestamp precision for datetime/timestamp DB columns #384