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

				drop table system_data;
				create table system_data (
				  id                     bigint 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                   bigint 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          bigint not null
				);
				create unique index destinations_pk on destinations(name);
				
				drop table messages;
				create table messages (
				  messageId             varchar(64) not null,
				  destinationId         bigint not null,
				  priority              int,
				  createTime            bigint not null,
				  expiryTime            bigint,
				  processed             int,
				  messageBlob           longblob not null
				);
				create index messages_pk on messages(messageId);
				
				DROP TABLE message_handles;
				CREATE TABLE message_handles (
				   messageId            varchar(64) not null,
				   destinationId        bigint NOT NULL,
				   consumerId           bigint NOT NULL,
				   priority             int,
				   acceptedTime         bigint,
				   sequenceNumber       bigInt,
				   expiryTime           bigint,
				   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        bigint not null,
				  consumerId           bigint not NULL,
				  created              bigint 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);