# 캐릭터SET 설정
SET NAMES utf8mb4;
# DB 생성
DROP databse IF EXISTS site35;
CREATE DATABASE site35;
USE site35;
# 카테고리 생성
CREATE TABLE cateItem (
id INT(10) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
regDate DATETIME NOT NULL,
`name` CHAR(100) NOT NULL UNIQUE
);
# 카테고리 아이템 4-5개 추가.
INSERT INTO cateItem SET `name` = 'IT/JAVA', regDate = NOW();
INSERT INTO cateItem SET `name` = 'IT/자격증', regDate = NOW();
INSERT INTO cateItem SET `name` = '일상/취미', regDate = NOW();
INSERT INTO cateItem SET `name` = '여행', regDate = NOW();
# 게시물 테이블 생성
DROP TABLE IF EXISTS article;
CREATE TABLE article (
id INT(10) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
regDate DATETIME NOT NULL,
cateItemId INT(10) UNSIGNED NOT NULL,
displayStatus TINYINT(1) UNSIGNED NOT NULL,
`title` CHAR(200) NOT NULL,
`body` TEXT NOT NULL
);