회원가입 테이블 및 초기 정보 입력

create table userinfo(

userid varchar2(10) primary key

,passwd varchar2(12)

,username varchar2(12)

,gender char default 'M' check (gender in ('F', 'M'))

,birth date

,email varchar2(50)

,address varchar2(100)

,phone char(11)

,mobile char(11)

,blog varchar2(50)

,letter char default 'N' check (letter in ('Y', 'N'))

,sms char default 'N' check (sms in ('Y', 'N'))

,interest varchar2(100)

);

insert into userinfo (userid, passwd, username, birth, address, phone, mobile, blog)

values('admin', 'a1234', '관리자', sysdate, '경기도 안양시', '0311231234', '0109998888', 'http://websig.tistory.com');