CREATE TABLE `message` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `title` varchar(255) DEFAULT NULL COMMENT 'message title',
  `message` varchar(255) DEFAULT NULL COMMENT 'message body',
  `userId` int NOT NULL COMMENT 'message to user',
  `readAlready` tinyint NOT NULL DEFAULT '0' COMMENT 'read it already ?',
  `create_at` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  KEY `IDX_1eab63be14adf5c1ef75e0d26e` (`createTime`),
  KEY `IDX_e66579574506ef14a3ef840521` (`updateTime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

