CREATE database makeboard ;

use makeboard ;

TRUNCATE menber ;

CREATE table menber (

_id INT AUTO_INCREMENT COMMENT '기본키',

name VARCHAR(32) not null COMMENT '이름',

age int COMMENT '나이',

sex INT COMMENT '성별0은 여자 1은 남자',

level int COMMENT '레벨 9는 관리자 입니다',

PRIMARY KEY(_id)

) ENGINE=INNODB DEFAULT CHARACTER set utf8 collate utf8_general_ci ;

CREATE table board (

_id INT AUTO_INCREMENT COMMENT '기본키',

title VARCHAR(100) NOT NULL COMMENT '제목',

content TEXT NOT NULL COMMENT '내용',

view_count INT NOT NULL DEFAULT 0 COMMENT '알람수',

status INT NOT NULL DEFAULT 0 COMMENT '삭제는 T',

member INT COMMENT '멤버의 기본키',

PRIMARY KEY(_id)

) ENGINE=INNODB DEFAULT CHARACTER set utf8 collate utf8_general_ci ;