Cơ dở dữ liệu trên mysql, tạo mấy bảng demo

use newjava;
create table role(
    id bigint not null primary key auto_increment,
    name varchar(255) not null,
    code varchar(255) not null,
    createddate timestamp null,
    modifieddate timestamp null,  #ngay sua
    createdby varchar(255) null,
   modifiedby nvarchar(255) null  #nguoi sua
);

create table user(
    id bigint not null primary key auto_increment,
    role_id bigint not null,
    username varchar(255) not null,
    password varchar(255) not null,
    fullname varchar(100) null,
    status int not null,
    createddate timestamp null,
    modifieddate timestamp null,  #ngay sua
    createdby varchar(255) null,
    modifiedby nvarchar(255) null  #nguoi sua
);


create table news(
    id bigint not null primary key auto_increment,
    id_category bigint not null,
    title nvarchar(250) null,
    description nvarchar(500) null,
    content text null,
    id_user bigint not null,
    status int not null,
    createddate timestamp null,
    modifieddate timestamp null,  #ngay sua
    createdby varchar(255) null,
    modifiedby nvarchar(255) null  #nguoi sua
);

create table category(
    id bigint not null primary key auto_increment,
    name varchar(255) not null,
    status int not null,
    createddate timestamp null,
    modifieddate timestamp null,  #ngay sua
    createdby varchar(255) null,
    modifiedby nvarchar(255) null  #nguoi sua
);