diff options
-rw-r--r-- | contrib/realtime/postgresql/realtime.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/contrib/realtime/postgresql/realtime.sql b/contrib/realtime/postgresql/realtime.sql index 63f57de29..98fe28fcf 100644 --- a/contrib/realtime/postgresql/realtime.sql +++ b/contrib/realtime/postgresql/realtime.sql @@ -138,6 +138,23 @@ penalty int8, PRIMARY KEY (queue_name, interface) ) WITHOUT OIDS; +drop table queue_log; +CREATE TABLE "queue_log" ( +"id" SERIAL, +"time" TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL, +"callid" character varying(50) NOT NULL, +"queuename" character varying(50) NOT NULL, +"agent" character varying(50) NOT NULL, +"event" character varying(20) NOT NULL, +"data1" character varying(50) NOT NULL, +"data2" character varying(50) NOT NULL, +"data3" character varying(50) NOT NULL, +"data4" character varying(50) NOT NULL, +"data5" character varying(50) NOT NULL, +CONSTRAINT queue_log_pkey PRIMARY KEY (id) +) WITHOUT OIDS; + +GRANT ALL ON TABLE queue_log TO asterisk; GRANT ALL ON TABLE cdr TO asterisk; GRANT ALL ON TABLE extensions_conf TO asterisk; GRANT ALL ON TABLE sip_conf TO asterisk; |