I had to do this for a long time, sorry guys
ALTER TABLE CHANNEL_LOG MODIFY ts DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP;
ALTER TABLE RESPONDERS MODIFY responder VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY answer TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE CHANNEL MODIFY name VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
