Use of db default values for UUID / GUID

As part of 6.x this project has started using uuid fields to generate globally unique identifier for records in multiple tables. In case anyone wants to reduce the load on server during upgrade or normal operations, MySQL/MariaDB installations with modest database admin skills may want to try using DB engine to set the values with following change for MySQL 8.0+ / Mariadb 10.2+ :

ALTER TABLE patient_data ALTER uuid BINARY(16) DEFAULT uuid_to_bin(uuid());

Unfortunately standard project does not project does not support db specific changes but here is modified upgrade script which will apply ordered list of patches.