summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorLeif Madsen <leif@leifmadsen.com>2009-01-29 13:47:27 +0000
committerLeif Madsen <leif@leifmadsen.com>2009-01-29 13:47:27 +0000
commit898fd645281829da73fb6dda5c47959a80dface3 (patch)
tree2a87f0fa0e922f8a6b725898c9e444b076db9e42
parent0685c4b2813e66de3ba997c34a6f9c00aa036daa (diff)
The realtime_pgsql.sql script is missing a couple of fields.
closes issue #14339) Reported by: fiddur Patches: realtime_pgsql.sql.diff uploaded by fiddur (license 678) git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@172271 65c4cc65-6c06-0410-ace0-fbb531ad65f3
-rw-r--r--contrib/scripts/realtime_pgsql.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/contrib/scripts/realtime_pgsql.sql b/contrib/scripts/realtime_pgsql.sql
index 86551249b..760464b1f 100644
--- a/contrib/scripts/realtime_pgsql.sql
+++ b/contrib/scripts/realtime_pgsql.sql
@@ -118,6 +118,7 @@ memberdelay int8,
weight int8,
timeoutrestart bool,
setinterfacevar bool,
+autopause varchar(128),
PRIMARY KEY (name)
) WITHOUT OIDS;
ALTER TABLE queue_table OWNER TO asterisk;
@@ -125,9 +126,11 @@ ALTER TABLE queue_table OWNER TO asterisk;
drop table queue_member_table;
CREATE TABLE queue_member_table
(
+uniqueid serial,
queue_name varchar(128),
interface varchar(128),
penalty int8,
+paused int8,
PRIMARY KEY (queue_name, interface)
) WITHOUT OIDS;