CREATE TABLE board0803(
bidx int NOT NULL PRIMARY key AUTO_INCREMENT,
subject VARCHAR(20) NOT null,
CONTENTS VARCHAR(2000) null,
writer VARCHAR(20) NOT null,
viewcnt int default 0,
writeday datetime DEFAULT now(),
ip VARCHAR(25) null,
delyn CHAR(1) DEFAULT 'N',
midx int NOT NULL,
constraint midx_fk0915 foreign key(midx) references member0803(midx)
);
alter table board0803
add pwd varchar(50) null;
alter table board0803
add modifyday datetime null;
alter table board0803
add filename varchar(100) null;
INSERT INTO board0803(SUBJECT,CONTENTS,WRITER,midx)
VALUES('샘플제목','샘플내용','홍길동',1);
INSERT INTO board0803(SUBJECT,CONTENTS,WRITER,midx)
VALUES('샘플제목2','샘플내용2','홍길동2',1);
INSERT INTO board0803(SUBJECT,CONTENTS,WRITER,midx)
VALUES('샘플제목3','샘플내용3','홍길동3',2);
INSERT INTO board0803(SUBJECT,CONTENTS,WRITER,midx)
VALUES('샘플제목4','샘플내용4','홍길동4',3);
INSERT INTO board0803(SUBJECT,CONTENTS,WRITER,midx)
VALUES('샘플제목5','샘플내용5','홍길동5',5);
INSERT INTO board0803(SUBJECT,CONTENTS,WRITER,midx)
VALUES('샘플제목6','샘플내용6','홍길동6',3);
INSERT INTO board0803(SUBJECT,CONTENTS,WRITER,midx)
VALUES('샘플제목7','샘플내용7','홍길동7',9);
INSERT INTO board0803(SUBJECT,CONTENTS,WRITER,midx)
VALUES('샘플제목8','샘플내용8','홍길동8',7);
INSERT INTO board0803(SUBJECT,CONTENTS,WRITER,midx)
VALUES('샘플제목9','샘플내용9','홍길동9',10);
INSERT INTO board0803(SUBJECT,CONTENTS,WRITER,midx)
VALUES('샘플제목10','샘플내용10','홍길동10',4);