Event-Time-Zone-Implementation-Planning.md

@@ -131,22 +131,28 @@ CiviCRM is an application/framework/platform that integrates with several other
 
 ## Appendix: MySQL survey
 
-There is a substantive question about the quantity/quality of MySQL environments which do/can/cannot enable timezone support. Some references:
-
-* __Environments which enable timezones by default__
-  * Digital Ocean (Managed MySQL) (`r-run`: yes)
-  * Docker (https://hub.docker.com/_/mysql) (`r-run`: yes)
-  * Google Cloud (Cloud SQL for MySQL) (`r-run`: yes; but ["not guaranteed to provide up-to-date time settings"](https://cloud.google.com/sql/docs/mysql/known-issues))
-  * (_Probably_) Amazon RDS-MySQL (There are old-google-cached forum posts which imply gradual evolution toward support. The current ["Local time zone" page](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_MySQL.html#MySQL.Concepts.LocalTimeZone) seems to affirm, but it doesn't specifically mention session-scoped timezones.)
-  * CiviHosting
-* __Environments which have the ability to load timezones - but don't by default__
-  * Azure MySQL (https://docs.microsoft.com/en-us/azure/mysql/howto-server-parameters#working-with-the-time-zone-parameter)
-  * CentOS MySQL Packages (`mysql_tzinfo_to_sql`) (`r-run`: yes)
-  * cPanel hosts with root access
-  * Debian/Ubuntu MySQL Packages (`mysql_tzinfo_to_sql`) (`r-run`: yes)
-  * Nix MySQL Packages (`mysql_tzinfo_to_sql`) (`r-run`: yes)
-* __Environments which cannot load timezones__
-  * (_Probably_) cPanel hosts without root access
+There is a substantive question about the quantity/quality of MySQL environments which:
+
+* Already support MySQL timezones (:white_check_mark:)
+* Can support MySQL timezones, with extra setup (:tools:)
+* Cannot support MySQL timezones (:octagonal_sign:)
+* Status is not certain (:question:)
+
+Sorted by `Status,Environment`:
+
+| Status | Environment | Comment |
+| -- |  -- |  -- |
+| :white_check_mark: | CiviHosting | |
+| :white_check_mark: | Digital Ocean | Specifically tested w/[managed MySQL 8.0](https://www.digitalocean.com/products/managed-databases-mysql) |
+| :white_check_mark: | Docker `mysql` | Specifically tested w/[8.0, 8.0-oracle, and 5.7](https://hub.docker.com/_/mysql) |
+| :white_check_mark: | Google Cloud SQL | Specifically tested w/5.6. Warning from docs: ["not guaranteed to provide up-to-date time settings"](https://cloud.google.com/sql/docs/mysql/known-issues) |
+| :white_check_mark: :question: | Amazon RDS | Not tested. There are old-google-cached forum posts which imply gradual evolution toward support. The current ["Local time zone" page](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_MySQL.html#MySQL.Concepts.LocalTimeZone) seems to affirm, but it doesn't specifically mention session-scoped timezones. |
+| :tools: | Azure Database | Use [`az_load_timezone()`](https://docs.microsoft.com/en-us/azure/mysql/howto-server-parameters#working-with-the-time-zone-parameter)  |
+| :tools: | CentOS MariaDB/MySQL | Use `mysql_tzinfo_to_sql` |
+| :tools: | cPanel (with root access) | Use `mysql_tzinfo_to_sql` |
+| :tools: | Debian/Ubuntu MariaDB/MySQL | Use `mysql_tzinfo_to_sql` |
+| :tools: | Nix MariaDB/MySQL | Use `mysql_tzinfo_to_sql` |
+| :octagonal_sign: :question: | cPanel (without root access) | Not tested. If you have MySQL admin rights, you might use `mysql_tzinfo_sql` locally and send to server. Still requires MySQL admin. |
 
 ## Related Tasks