drop table system_data;
create table system_data (
id NUMBER(3) not null,
version varchar2(20) not null,
creationDate date not null
);
alter table system_data
add constraint system_data_pk
primary key ( id )
using index;
drop table seeds;
create table seeds (
name varchar2(20) not null,
seed NUMBER(28) not null
);
alter table seeds
add constraint seeds_pk
primary key ( name )
using index;
drop table destinations;
create table destinations (
name varchar2(255) not null,
isQueue NUMBER(3) not null,
destinationId NUMBER(28) not null
);
alter table destinations
add constraint destinations_pk
primary key ( name )
using index;
drop table messages;
create table messages (
messageId varchar2(64) not null,
destinationId NUMBER(28) not null,
priority NUMBER(3),
createTime NUMBER(28) not null,
expiryTime NUMBER(28),
processed NUMBER(3),
messageBlob long raw not null
);
alter table messages
add constraint messages_pk
primary key ( messageid )
using index;
create index messages_x1 on messages(
expiryTime
);
create index messages_x2 on messages(
destinationId
);
drop table message_handles;
create table message_handles (
messageId varchar2(64) NOT NULL,
destinationId NUMBER(28) NOT NULL,
consumerId NUMBER(28) NOT NULL,
priority NUMBER(3),
acceptedTime NUMBER(28),
sequenceNumber NUMBER(28),
expiryTime NUMBER(28),
delivered NUMBER(3)
);
alter table message_handles
add constraint message_handles_pk
primary key ( destinationId, consumerId, messageId )
using index;
create index message_handles_x1 on message_handles(expirytime);
create index message_handles_x2 on message_handles(messageid);
create index message_handles_x3 on message_handles(destinationid);
create index message_handles_x4 on message_handles(consumerid,acceptedtime);
drop table consumers;
create table consumers (
name varchar2(255) not null,
destinationId NUMBER(28) not null,
consumerId NUMBER(28) not NULL,
created NUMBER(28) NOT NULL
);
alter table consumers
add constraint consumers_pk
primary key ( name, destinationid )
using index;
drop table users;
create table users (
username varchar2(50) not null,
password varchar2(50) not null
);
alter table users
add constraint users_pk
primary key ( username )
using index;