/* DROP TABLE system_data; */
create table system_data (
id int not null,
version varchar(20) not null,
creationDate DATE not null
);
create unique index system_data_pk on system_data(id);
/* DROP TABLE seeds; */
create table seeds (
name varchar(20) not null,
seed numeric(18) not null
);
create unique index seeds_pk on seeds(name);
/* DROP TABLE destinations; */
create table destinations (
name varchar(255) not null,
isQueue int not null,
destinationId numeric(18) not null
);
create unique index destinations_pk on destinations(destinationId);
/* DROP TABLE messages; */
create table messages (
messageId varchar(64) not null,
destinationId numeric(18) not null,
priority int,
createTime numeric(18) not null,
expiryTime numeric(18),
processed int,
messageBlob binary not null
);
create index messages_pk on messages(messageId);
/* DROP TABLE message_handles; */
CREATE TABLE message_handles (
messageId varchar(64) not null,
destinationId numeric(18) NOT NULL,
consumerId numeric(18) NOT NULL,
priority int,
acceptedTime numeric(18),
sequenceNumber numeric(18),
expiryTime numeric(18),
delivered int
);
CREATE INDEX message_handles_pk ON message_handles(destinationId, consumerId, messageId);
/* DROP TABLE consumers; */
create table consumers (
name varchar(255) not null,
destinationId numeric(18) not null,
consumerId numeric(18) not NULL,
created numeric(18) NOT NULL
);
create unique index consumers_pk on consumers(name, destinationId);
/* DROP TABLE users; */
create table users (
username varchar(50) not null,
password varchar(50) not null
);
create unique index users_pk on users(username);
