DB는 오라클10g
>테이블<
create table guestbook(
num number(4) not null primary key,
name varchar2(20) not null,
pass varchar2(20) not null,
reg_date varchar2(10) not null,
subject varchar2(50) not null,
content varchar2(4000) not null,
readcount number(4) not null,
re_step number(4) not null,
re_level number(4) not null,
ref number(4) default 0
);
>num증가를 위한 시퀀스<
create sequence guest_bookno
start with 1
increment by 1
minvalue 1
maxvalue 9999999
;
>테이블<
create table guestbook(
num number(4) not null primary key,
name varchar2(20) not null,
pass varchar2(20) not null,
reg_date varchar2(10) not null,
subject varchar2(50) not null,
content varchar2(4000) not null,
readcount number(4) not null,
re_step number(4) not null,
re_level number(4) not null,
ref number(4) default 0
);
>num증가를 위한 시퀀스<
create sequence guest_bookno
start with 1
increment by 1
minvalue 1
maxvalue 9999999
;