web/lib/Zend/Queue/Adapter/Db/postgresql.sql
changeset 807 877f952ae2bd
parent 207 621fa6caec0c
equal deleted inserted replaced
805:5e7a0fedabdf 807:877f952ae2bd
    36   message_id bigserial NOT NULL,
    36   message_id bigserial NOT NULL,
    37   queue_id integer,
    37   queue_id integer,
    38   handle character(32),
    38   handle character(32),
    39   body character varying(8192) NOT NULL,
    39   body character varying(8192) NOT NULL,
    40   md5 character(32) NOT NULL,
    40   md5 character(32) NOT NULL,
    41   timeout real,
    41   timeout double precision,
    42   created integer,
    42   created integer,
    43   CONSTRAINT message_pk PRIMARY KEY (message_id),
    43   CONSTRAINT message_pk PRIMARY KEY (message_id),
    44   CONSTRAINT message_ibfk_1 FOREIGN KEY (queue_id)
    44   CONSTRAINT message_ibfk_1 FOREIGN KEY (queue_id)
    45       REFERENCES queue (queue_id) MATCH SIMPLE
    45       REFERENCES queue (queue_id) MATCH SIMPLE
    46       ON UPDATE CASCADE ON DELETE CASCADE
    46       ON UPDATE CASCADE ON DELETE CASCADE