-- Preparations
SET SESSION group_concat_max_len=4294967295;
SET SESSION foreign_key_checks=0;
 
-- Set default character sets and collations
ALTER DATABASE dwdata CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER DATABASE dwnotification CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER DATABASE dwsystem CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER DATABASE dwworkflowengine CHARACTER SET utf8 COLLATE utf8_general_ci;
 
-- Create statement that adjusts collations for tables in dwdata
SELECT GROUP_CONCAT(CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME,
                         ' CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;')
                  SEPARATOR '\n') AS "Prepared statement"
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA='dwdata' AND TABLE_TYPE='BASE TABLE';
 
-- Adjust collations for tables in all remaining databases
ALTER TABLE dwnotification.eventsforsubscribtion CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwnotification.eventstorage CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwnotification.noslock CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwanalytics CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwbpsmonitoring CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwbusinessusecasehistory CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwclientlicense CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwconnectionlicense CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwexpiredtasks CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwfcdoctypes CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwfcnotificationrules CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwfcprofile CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwfcprofiletorole CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwfcprofiletouser CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwfcsettings CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwfcsettingstofcprofile CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwfcsettingstorole CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwfcsettingstouser CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwfilecabinet CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwgeneralprofile CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwgeneralprofiletorole CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwgeneralprofiletouser CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwglobaldoctypes CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwgroup CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwgrouptorole CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwjobs CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwkeys CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwleaderelection CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwlicense CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwlocktable CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwmfpdevice CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwmfpworkflows CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwmfpworkflowtodevice CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwnotificationsettings CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dworganization CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dworganizationdb CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dworganizationsettings CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dworgdbversion CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dworgsettingsaudit CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwrelationships CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwroles CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwschedule CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwsequence CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwserver CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwserverlicense CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwservertoorganizationdb CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwsettings CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwsettingstogeneralprofile CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwsmartconnect CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwsyssettingtoorganizationdb CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwsystemsettings CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwsystemsettingsaudit CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwsystemuser CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwsystemworkflows CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwtasks CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwtaskswfe CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwtrackchanges CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwtrusteduser CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwuser CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwusersettings CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwusersettingstowebinstance CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwusertogroup CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwusertokenidentity CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwusertokentoorganization CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwusertorole CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwwebinstance CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwworkflow CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwsystem.dwworkflowstatus CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwworkflowengine.aggregateevents CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwworkflowengine.changesets CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwworkflowengine.mytasks CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwworkflowengine.otherstasks CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwworkflowengine.permissions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwworkflowengine.simpledefinitions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwworkflowengine.snapshots CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwworkflowengine.usertaskscount CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwworkflowengine.workflowdefinitions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwworkflowengine.workflows CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE dwworkflowengine.workflowversions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
 
SET SESSION foreign_key_checks=1;