OpenJMS是一个开源的Java Message Service API 1.0.2 规范的实现,它包含有以下特性: *. 它既支持点到点(point-to-point)(PTP)模型和发布/订

源代码在线查看: create_jds.sql

软件大小: 1548 K
上传用户: a1a1J0
关键词: point-to-point OpenJMS Message Service
下载地址: 免注册下载 普通下载 VIP

相关代码

				/* 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);							

相关资源