Tighten MySQL settings

[mbohal]

Presently there is no check of the db settings. This has to do with issues like:

• db charset
• db collation
• strict_mode (and all the related settings)

There are collated columns all over the db and when running migration on a db that is not collated foreign keys sometimes can not be made. This particular case was fixed by this diff:

mb@mb-laptop ~/Projects/epartool/epartool (master ±1) ~> git diff
diff --git a/data/phinx-migrations/20180221091158_dbjr1358.php b/data/phinx-migrations/20180221091158_dbjr1358.php
index 3fb54e63..7352ddfa 100644
--- a/data/phinx-migrations/20180221091158_dbjr1358.php
+++ b/data/phinx-migrations/20180221091158_dbjr1358.php
@@ -10,7 +10,7 @@ class Dbjr1358 extends AbstractMigration
 CREATE TABLE `voting_button_set` (
   `id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
   `consultation_id` int(10) unsigned NOT NULL,
-  `button_type` varchar(191) NOT NULL,
+  `button_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
   `points` int NOT NULL,
   `enabled` tinyint(1) NOT NULL,
   `label` text NULL
mb@mb-laptop ~/Projects/epartool/epartool (master ±1) ~>