



CREATE TABLE queue

(

  queue_id serial NOT NULL,

  queue_name character varying(100) NOT NULL,

  timeout smallint NOT NULL DEFAULT 30,

  CONSTRAINT queue_pk PRIMARY KEY (queue_id)

)

WITH (OIDS=FALSE);

ALTER TABLE queue OWNER TO queue;





-- --------------------------------------------------------

--

-- Table structure for table `message`

--






CREATE TABLE message

(

  message_id bigserial NOT NULL,

  queue_id integer,

  handle character(32),

  body character varying(8192) NOT NULL,

  md5 character(32) NOT NULL,

  timeout real,

  created integer,

  CONSTRAINT message_pk PRIMARY KEY (message_id),

  CONSTRAINT message_ibfk_1 FOREIGN KEY (queue_id)

      REFERENCES queue (queue_id) MATCH SIMPLE

      ON UPDATE CASCADE ON DELETE CASCADE

)

WITH (OIDS=FALSE);

ALTER TABLE message OWNER TO queue;