팬션 DB

create sequence cus_seq;

create sequence review_seq;

create sequence image_seq;

create sequence writeNo_seq;

create sequence map_seq;

create sequence ad_seq;

create suquence bug_seq;

 

 

drop table localInfo;

 

create table localInfo(

localInfo_no number(5),

localInfo_name varchar2(50),

localInfo_addr1 varchar2(100),

localInfo_addr2 varchar2(100),

localInfo_tel1 varchar2(20),

localInfo_tel2 varchar2(20),

localInfo_tel3 varchar2(20),

localInfo_phone1 varchar2(20),

localInfo_phone2 varchar2(20),

localInfo_phone3 varchar2(20),

localInfo_contents clob,

localInfo_imgName varchar2(50),

localInfo_x varchar2(20),

localInfo_y varchar2(20),

regdate Date

);

 

 

drop table cus;

 

create table cus(

cus_no number(5) constraint cus_no_pk primary key ,

cus_id varchar2(30),

cus_name varchar2(30),

cus_pw varchar2(30),

cus_cn varchar2(30),

cus_cf varchar2(30),

cus_nickName varchar2(30),

cus_addr varchar2(100),

cus_sex varchar2(10),

cus_tel varchar2(20),

cus_phone varchar2(20),

cus_email varchar2(100),

cus_birth varchar2(100),

cus_regdate date

);

 

 

create table review(

re_no number(11) constraint re_no_pk primary key,

re_writeno number(5),

re_writer varchar2(30),

re_contents clob,

re_regdate date,

re_title varchar2(500)

) ;

 

 

drop table bug;

 

create table bug(

bug_no number(5),

bug_name varchar2(80),

bug_mail varchar2(80),

bug_address varchar2(100),

bug_subject varchar2(80),

bug_content clob,

bug_imgname varchar2(80),

regdate date

);

 

실행문 : http://localhost/stay/stay.action

dao, vo, service 이름의 형식을 통일했음.

되던게 안될 경우 변수 이름 확인하공, 스트럭처, 맵퍼, 어플리케이션 id, name 안겹치도록 할 것!!