编辑代码

SELECT * FROM users;
create database blogsystem;
use blogsystem;
create table users(
    userid int auto_increment primary key,
    username varchar(50) not null unique,
    password varchar(100) not null, 
    nickname varchar(50) not null,
    email varchar(100) not null unique,
    registration_time datetime not null default current-timestamp,
    user_type varchar(20) default '普通'
);
create table articles(
article_id int auto_increment primary key,
userid int not null,
category_id int,
title varchar(100) not null,
content text not null,
summary varchar(200) not null,
publish_time datetime not null default current-timestamp,
views int not  null default 0,
status varchar(20) default '草稿',
foreign key (userid) references users(useid)
);
 

 insert into users( username,password,nickname,email,user_type)
 values('test_user','123456','测试昵称','test@example.com','普通',);