I had to 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;