MySQL DB

Jump to bottom Edit New page

Matt Simerson edited this page Jun 1, 2024 · 6 revisions

2024 MySQL schema updates

Notes:

change mail_dmarc to the name of the MySQL database you are using.

USE mail_dmarc;
ALTER DATABASE mail_dmarc CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

ALTER TABLE author CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE domain CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE report_error CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;