And here the output of the SCRIPT TO
SCRIPT
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SET CLUSTER
'';
SET LOCK_MODE
0;
SET DEFAULT_TABLE_TYPE
0;
SET WRITE_DELAY
500;
SET DEFAULT_LOCK_TIMEOUT
2000;
SET CACHE_SIZE
16384;
CREATE USER IF NOT EXISTS "" SALT '7091d7ce961a1c94' HASH
'04d4577c6824c213aca77be2fd910b824232acd7f0cb99b05065201363ccf987'
ADMIN;
CREATE CACHED TABLE PUBLIC.ACTIVEMQ_MSGS(
ID BIGINT NOT NULL,
CONTAINER VARCHAR(250),
MSGID_PROD VARCHAR(250),
MSGID_SEQ BIGINT,
EXPIRATION BIGINT,
MSG BLOB
);
ALTER TABLE PUBLIC.ACTIVEMQ_MSGS ADD CONSTRAINT PUBLIC.CONSTRAINT_5
PRIMARY
KEY(ID);
-- 0 +/- SELECT COUNT(*) FROM
PUBLIC.ACTIVEMQ_MSGS;
CREATE INDEX PUBLIC.ACTIVEMQ_MSGS_MIDX ON
PUBLIC.ACTIVEMQ_MSGS(MSGID_PROD,
MSGID_SEQ);
CREATE INDEX PUBLIC.ACTIVEMQ_MSGS_CIDX ON
PUBLIC.ACTIVEMQ_MSGS(CONTAINER);
CREATE INDEX PUBLIC.ACTIVEMQ_MSGS_EIDX ON
PUBLIC.ACTIVEMQ_MSGS(EXPIRATION);
CREATE CACHED TABLE PUBLIC.ACTIVEMQ_ACKS(
CONTAINER VARCHAR(250) NOT NULL,
SUB_DEST VARCHAR(250),
CLIENT_ID VARCHAR(250) NOT NULL,
SUB_NAME VARCHAR(250) NOT NULL,
SELECTOR VARCHAR(250),
LAST_ACKED_ID BIGINT
);
ALTER TABLE PUBLIC.ACTIVEMQ_ACKS ADD CONSTRAINT PUBLIC.CONSTRAINT_5E
PRIMARY KEY(CONTAINER, CLIENT_ID,
SUB_NAME);
-- 0 +/- SELECT COUNT(*) FROM
PUBLIC.ACTIVEMQ_ACKS;
CREATE CACHED TABLE PUBLIC.ACTIVEMQ_LOCK(
ID BIGINT NOT NULL,
TIME BIGINT,
BROKER_NAME VARCHAR(250)
);
ALTER TABLE PUBLIC.ACTIVEMQ_LOCK ADD CONSTRAINT PUBLIC.CONSTRAINT_5E4
PRIMARY
KEY(ID);
-- 1 +/- SELECT COUNT(*) FROM
PUBLIC.ACTIVEMQ_LOCK;
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
