diff -r 000000000000 -r 4eba9c11703f web/Zend/Queue/Adapter/Db/postgresql.sql --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/web/Zend/Queue/Adapter/Db/postgresql.sql Mon Dec 13 18:29:26 2010 +0100 @@ -0,0 +1,49 @@ +/* +Sample grant for PostgreSQL + +CREATE ROLE queue LOGIN + PASSWORD '[CHANGE ME]' + NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE; + +*/ + +-- +-- Table structure for table `queue` +-- + +DROP TABLE IF EXISTS queue; + +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` +-- + +DROP TABLE IF EXISTS 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; \ No newline at end of file