With the commit of HIVE-17983 to master there are now tests for install and upgrade scripts for the metastore database for all 4 of the database types (mysql, postgres, oracle, and sql server). These are not run by default as they take a bit and require docker to be installed on the box. For instructions on how to run them see standalone-metastore/DEV-README.
If you are making changes to the database scripts, please run these before commit. Alan.