File manager - Edit - /usr/local/prospamfilter/library/Zend/Queue/Adapter/Db/postgresql.sql
Back
/* 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 double precision, 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;
| ver. 1.4 |
Github
|
.
| PHP 8.2.30 | Generation time: 0 |
proxy
|
phpinfo
|
Settings