CREATE TABLE m_user(
id BIGINT(20) not null AUTO_INCREMENT,
username VARCHAR(64) DEFAULT null,
avatar VARCHAR(255) DEFAULT null,
email VARCHAR(64) DEFAULT null,
PASSWORD VARCHAR(64) DEFAULT null,
status int(5) NOT NULL,
created datetime DEFAULT NULL,
last_login datetime DEFAULT NULL,
PRIMARY KEY (id),
KEY UK_USERNAME (username) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `m_blog` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) NOT NULL,
`title` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
`content` longtext,
`created` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP,
`status` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;
INSERT INTO `vueblog`.`m_user` (`id`, `username`, `avatar`, `email`, `password`, `status`, `created`, `last_login`) VALUES ('1', 'markerhub', 'https://image-1300566513.cos.ap-guangzhou.myqcloud.com/upload/images/5a9f48118166308daba8b6da7e466aab.jpg', NULL, '96e79218965eb72c92a549dd5a330112', '0', '2020-04-20 10:44:01', NULL);
转载请注明原文地址:https://blackberry.8miu.com/read-34324.html