Java
iBatis 에서 테이블 생성
우혁이 아빠
2009. 11. 17. 13:27
<insert id="boardCreate" parameterClass="java.util.Map">
CREATE TABLE $boardTitle$ (
BOARD_NUM INTEGER NOT NULL,
BOARD_NAME VARCHAR2(20 BYTE) NOT NULL,
BOARD_PASS VARCHAR2(15 BYTE) NOT NULL,
BOARD_EMAIL VARCHAR2(30 BYTE),
BOARD_SUBJECT VARCHAR2(50 BYTE) NOT NULL,
BOARD_CONTENT VARCHAR2(2000 BYTE) NOT NULL,
BOARD_RE_REF INTEGER NOT NULL,
BOARD_RE_LEV INTEGER NOT NULL,
BOARD_RE_SEQ INTEGER NOT NULL,
BOARD_READCOUNT INTEGER NOT NULL,
BOARD_DATE DATE NOT NULL,
BOARD_FILE VARCHAR2(50 BYTE),
PRIMARY KEY (BOARD_NUM) )
</insert>
CREATE TABLE $boardTitle$ (
BOARD_NUM INTEGER NOT NULL,
BOARD_NAME VARCHAR2(20 BYTE) NOT NULL,
BOARD_PASS VARCHAR2(15 BYTE) NOT NULL,
BOARD_EMAIL VARCHAR2(30 BYTE),
BOARD_SUBJECT VARCHAR2(50 BYTE) NOT NULL,
BOARD_CONTENT VARCHAR2(2000 BYTE) NOT NULL,
BOARD_RE_REF INTEGER NOT NULL,
BOARD_RE_LEV INTEGER NOT NULL,
BOARD_RE_SEQ INTEGER NOT NULL,
BOARD_READCOUNT INTEGER NOT NULL,
BOARD_DATE DATE NOT NULL,
BOARD_FILE VARCHAR2(50 BYTE),
PRIMARY KEY (BOARD_NUM) )
</insert>