模块八 - 设计消息队列存储消息数据的 MySQL 表格

CREATE TABLE $(message}(  `id` bigint primary key autoincrement not null,    `content` text,  `publish_unixtime` int default 0,    `publish_client` varchar(128) default '',   `create_unixtime` int default 0)ENGINE=InnoDB charset utf8mb4 comment 'message name';               CREATE TABLE ${message}_consume(    `id` bigint primary key autoincrement not null,    `message_id` bigint default 0,    `subscribe_group_name` varchar(128) default '',    `subscribe_client` varchar(128) default '',    `create_unixtime` int default 0,    unique key(`message_id`, `subscribe_group_name`))ENGINE=InnoDB charset utf8mb4 comment 'message consume log';