==================================================================================
create table THEME_MESSAGE (
THEME_MESSAGE_ID INTEGER NOT NULL PRIMARY KEY,
GROUP_ID INTEGER NOT NULL,
ORDER_NO INTEGER NOT NULL,
LEVEL INTEGER NOT NULL,
PARENT_ID INTEGER NOT NULL,
REGISTER TIMESTAMP NOT NULL,
NAME VARCHAR(20) NOT NULL,
EMAIL VARCHAR(80) NOT NULL,
IMAGE VARCHAR(40) NOT NULL,
PASSWORD VARCHAR(20),
TITLE VARCHAR(100) NOT NULL
);
====================================================================================
create index THEME_MESSAGE_INDEX
on THEME_MESSAGE(GROUP_ID DESC, ORDER_NO ASC);
====================================================================================
create table THEME_CONTENT (
THEME_MESSAGE_ID INTEGER NOT NULL PRIMARY KEY,
CONTENT LONG VARCHAR NOT NULL
);
===================================================================================
create table ID_SEQUENCE (
TABLE_NAME VARCHAR(60) NOT NULL PRIMARY KEY,
MESSAGE_ID INTEGER NOT NULL
);
===================================================================================
위는 게시판 구성을 위한 mysql용 쿼리문인데요.....
각각의 테이블을 sybase로 변환하는건 할 수 있겠는데, 2번째 단락을
보시면 create index...라는건 어떻게
고쳐야하는지원...도와주세요..어케 고쳐야되요?....
|