spring boot

    科技2024-11-01  15

    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);
    Processed: 0.038, SQL: 8