equal
deleted
inserted
replaced
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 |