Goal
- ActiveMQ JDBC Persistence에서 사용하는 테이블 스키마 정보 정리
ActiveMQ JDBC Persistence 스키마 정보
Acknowledge Table
CREATE TABLE ACTIVEMQ_ACKS (
CONTAINER VARCHAR(250) NOT NULL
, SUB_DEST VARCHAR(250) NULL
, CLIENT_ID VARCHAR(250) NOT NULL
, SUB_NAME VARCHAR(250) NOT NULL
, SELECTOR VARCHAR(250) NULL
, LAST_ACKED_ID BIGINT NULL
, PRIORITY INTEGER NOT NULL
, XID BLOB NULL
, PRIMARY KEY (CONTAINER, CLIENT_ID, SUB_NAME, PRIORITY)
);
Lock Table
CREATE TABLE ACTIVEMQ_LOCK (
ID BIGINT NOT NULL
, TIME BIGINT NULL
, BROKER_NAME VARCHAR(250) NULL
, CONSTRAINT PRIMARY KEY (ID)
);
Message Table
CREATE TABLE ACTIVEMQ_MSGS (
ID BIGINT NOT NULL
, CONTAINER VARCHAR(250) NULL
, MSGID_PROD VARCHAR(250) NULL
, MSGID_SEQ INTEGER NULL
, EXPIRATION BIGINT NULL
, MSG BLOB NULL
, PRIORITY INTEGER NULL
, XID BLOB NULL
, CONSTRAINT PRIMARY KEY (ID)
);
댓글남기기