The realtime_pgsql.sql script is missing a couple of fields.
authorLeif Madsen <leif@leifmadsen.com>
Thu, 29 Jan 2009 13:47:27 +0000 (13:47 +0000)
committerLeif Madsen <leif@leifmadsen.com>
Thu, 29 Jan 2009 13:47:27 +0000 (13:47 +0000)
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

contrib/scripts/realtime_pgsql.sql

index 8655124..760464b 100644 (file)
@@ -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;