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