댓글형 게시판

댓글형 게시판

— 댓글 게시판
DROP TABLE mvcReply;
DROP TABLE mvcBoard;
CREATE TABLE mvcBoard(
 no NUMBER,
 name VARCHAR2(20) CONSTRAINT mvcb_nn_name NOT NULL,
 subject VARCHAR2(1000) CONSTRAINT mvcb_nn_sub NOT NULL,
 content CLOB CONSTRAINT mvcb_nn_cont NOT NULL,
 pwd VARCHAR2(20) CONSTRAINT mvcb_nn_pwd NOT NULL,
 regdate DATE DEFAULT SYSDATE,
 hit NUMBER DEFAULT 0,
 CONSTRAINT mvcb_pk_no PRIMARY KEY(no));

CREATE TABLE mvcReply(
 no NUMBER,
 bno NUMBER,
 id VARCHAR2(20) CONSTRAINT mvcr_nn_id NOT NULL,
 name VARCHAR2(20) CONSTRAINT mvcr_nn_name NOT NULL,
 msg VARCHAR2(1000) CONSTRAINT mvcr_nn_msg NOT NULL,
 regdate DATE DEFAULT SYSDATE,
 group_id NUMBER,
 group_step NUMBER,
 group_tab NUMBER,
 root NUMBER,
 depth NUMBER,
 CONSTRAINT mvcr_pk_no PRIMARY KEY(no),
 CONSTRAINT mvcr_fk_bno FOREIGN KEY(bno) REFERENCES mvcBoard(no));

INSERT INTO mvcBoard(no,name,subject,content,pwd)
VALUES ((SELECT NVL(MAX(no)+1,1) FROM mvcBoard),’김’,’댓글형 게시판’,’댓글형 게시판 만들기 내용’,’1234′);

INSERT INTO mvcBoard(no,name,subject,content,pwd)
VALUES ((SELECT NVL(MAX(no)+1,1) FROM mvcBoard),’박’,’댓글형 게시판’,’댓글형 게시판 만들기 내용’,’1234′);