path: root/sql/mysql/mod_announce.sql

CREATE TABLE motd (
    username varchar(191) NOT NULL,
    server_host text NOT NULL,
    xml text,
    created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (server_host(191), username)
) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;