35 lines
1.0 KiB
Plaintext
35 lines
1.0 KiB
Plaintext
MySQL 데이터베이스 생성 및 사용자 생성
|
|
create user 'bloguser'@'%' identified by 'bitc5600';
|
|
GRANT ALL PRIVILEGES ON *.* TO 'bloguser'@'%';
|
|
create database blog;
|
|
|
|
|
|
CREATE TABLE user(
|
|
id int primary key auto_increment,
|
|
username varchar(100) not null unique,
|
|
password varchar(100) not null,
|
|
email varchar(100) not null,
|
|
address varchar(100),
|
|
userRole varchar(20),
|
|
createDate timestamp
|
|
) engine=InnoDB default charset=utf8;
|
|
|
|
CREATE TABLE board(
|
|
id int primary key auto_increment,
|
|
userId int,
|
|
title varchar(100) not null,
|
|
content longtext,
|
|
readCount int default 0,
|
|
createDate timestamp,
|
|
foreign key (userId) references user (id)
|
|
) engine=InnoDB default charset=utf8;
|
|
|
|
CREATE TABLE reply(
|
|
id int primary key auto_increment,
|
|
userId int,
|
|
boardId int,
|
|
content varchar(300) not null,
|
|
createDate timestamp,
|
|
foreign key (userId) references user (id) on delete set null,
|
|
foreign key (boardId) references board (id) on delete cascade
|
|
) engine=InnoDB default charset=utf8; |