방명록

* 오라클

 CREATE TABLE GUESTBOOK
(
    SEQ    NUMBER UNIQUE NOT NULL,
    NAME    VARCHAR2(20) NOT NULL,
    EMAIL    VARCHAR2(40),
    HOMEPAGE    VARCHAR2(40),
    SUBJECT    VARCHAR2(100) NOT NULL,
    CONTENT    VARCHAR2(4000) NOT NULL,
    PASSWORD    VARCHAR2(8) NOT NULL,
    LOGTIME    DATE NOT NULL,
    CONSTRAINT PK_GUESTBOOK PRIMARY KEY (SEQ )
);

CREATE SEQUENCE SEQ_GUESTBOOK START WITH 1 INCREMENT BY 1 NOCACHE;