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

源代码在线查看: create_interbase.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           blob 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,				  passwd              varchar(50) not null				);				create unique index users_pk on users(username);			

相关资源