1 /*

     2 Sample grant for PostgreSQL

     3 

     4 CREATE ROLE queue LOGIN

     5   PASSWORD '[CHANGE ME]'

     6   NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE;

     7 

     8 */

     9 

    10 --

    11 -- Table structure for table `queue`

    12 --

    13 

    14 DROP TABLE IF EXISTS queue;

    15 

    16 CREATE TABLE queue

    17 (

    18   queue_id serial NOT NULL,

    19   queue_name character varying(100) NOT NULL,

    20   timeout smallint NOT NULL DEFAULT 30,

    21   CONSTRAINT queue_pk PRIMARY KEY (queue_id)

    22 )

    23 WITH (OIDS=FALSE);

    24 ALTER TABLE queue OWNER TO queue;

    25 

    26 

    27 -- --------------------------------------------------------

    28 --

    29 -- Table structure for table `message`

    30 --

    31 

    32 DROP TABLE IF EXISTS message;

    33 

    34 CREATE TABLE message

    35 (

    36   message_id bigserial NOT NULL,

    37   queue_id integer,

    38   handle character(32),

    39   body character varying(8192) NOT NULL,

    40   md5 character(32) NOT NULL,

    41   timeout real,

    42   created integer,

    43   CONSTRAINT message_pk PRIMARY KEY (message_id),

    44   CONSTRAINT message_ibfk_1 FOREIGN KEY (queue_id)

    45       REFERENCES queue (queue_id) MATCH SIMPLE

    46       ON UPDATE CASCADE ON DELETE CASCADE

    47 )

    48 WITH (OIDS=FALSE);

    49 ALTER TABLE message OWNER TO queue;