From f41214b918c60cd53f008828c929b2a14875e1ad Mon Sep 17 00:00:00 2001 From: lmadsen Date: Thu, 29 Jan 2009 13:47:27 +0000 Subject: 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: http://svn.digium.com/svn/asterisk/trunk@172271 f38db490-d61c-443f-a65b-d21fe96a405b --- contrib/scripts/realtime_pgsql.sql | 3 +++ 1 file changed, 3 insertions(+) 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; -- cgit v1.2.3