[SQL] Sequences

[loveAlakazam]

The sequence for column of the table called BOARD

• purpose column name: BO_NO

-- (수진 11/20 )규호오빠 테스트DB bo_no이랑 충돌나서 start값을 8로 바꿉니다.
CREATE SEQUENCE SEQ_BO_NO
START WITH 8
INCREMENT BY 1
MAXVALUE 9999999999
NOCYCLE
NOCACHE;

The sequence for column of the table called IMG_FILE

• purpose column name: FILE_NO

CREATE SEQUENCE SEQ_FILE_NO
START WITH 1
INCREMENT BY 1
MAXVALUE 9999999999
NOCYCLE
NOCACHE;

The sequence for column of the table called REPLY

• purpose column name: RE_NO

CREATE SEQUENCE SEQ_RE_NO
START WITH 1
INCREMENT BY 1
MAXVALUE 9999999999
NOCYCLE
NOCACHE;

The sequence for column of the table called TRAVEL

-[수진] 11/20 추가 ++

• purpose column name: TR_NO

CREATE SEQUENCE SEQ_TRNO
START WITH 1
INCREMENT BY 1
MAXVALUE 9999999999
NOCYCLE
NOCACHE;