一个java方面的消息订阅发送的源码

源代码在线查看: create_postgresql.sql

软件大小: 1481 K
上传用户: LANCEZHANGL
关键词: java 方面 发送 源码
下载地址: 免注册下载 普通下载 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                   int not null
				);
				create unique index seeds_pk on seeds(name);
				
				DROP TABLE destinations;
				create table destinations (
				  name                   varchar(255) not null,
				  isQueue                char,
				  destinationId          int not null
				);
				create unique index destinations_pk on destinations(destinationId);
				
				DROP TABLE messages;
				create table messages (
				  messageId             varchar(64) not null,
				  destinationId         int8 not null,
				  priority              int,
				  createTime            int8,
				  expiryTime            int8,
				  processed             int,
				  messageBlob           bytea not null
				);
				create index messages_pk on messages(messageId);
				
				DROP TABLE message_handles;
				CREATE TABLE message_handles (
				   messageId            varchar(64) not null,
				   destinationId        int8 NOT NULL,
				   consumerId           int8 NOT NULL,
				   priority             int,
				   acceptedTime         int8,
				   sequenceNumber       int8,
				   expiryTime           int8,
				   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        int8 not null,
				  consumerId           int8 not NULL,
				  created              int8 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);			

相关资源