未命名.md 795 B

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