create table tbl_bbs (

  bbsno number,

  title varchar2(500) not null, 

  content varchar2(2000),

  writer varchar2(50),

  regdate date default sysdate,

  viewcnt number default 0

);


alter table tbl_bbs add CONSTRAINT

pk_bbs primary key (bbsno);


create sequence seq_bbs;


insert into tbl_bbs 

(bbsno, title, content, writer)

values (seq_bbs.nextval, '제목..14134525245245', '내용..34563623563456', 'user00');



--------------------------------------------------------------------------------------------


create table tbl_reply (

  replyno number not null,

  bbsno number not null,

  replyer varchar2(50) not null,

  reply varchar2(1000) not null,

  regdate date default sysdate,

  moddate date default sysdate

);


select * from tbl_reply;


alter table tbl_reply add CONSTRAINT

pk_reply primary key (replyno);


create sequence seq_reply;

insert into tbl_reply 

(REPLYNO, BBSNO, REPLYER, REPLY)

values (seq_reply.nextval, 1048577, '이XX', '박XX 바보');




create table tbl_store2 as (select * from tbl_store );

create table tbl_user2 as (select * from tbl_user );

create table tbl_menu2 as (select * from tbl_menu );

create table tbl_review2 as (select * from tbl_review );

Posted by 타다키치

댓글을 달아 주세요