[asterisk-bugs] [Asterisk 0014339]: contrib/scripts/realtime_pgsql.sql misses uniqueid in queue_member_table

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=14339 
====================================================================== 
Reported By:                fiddur
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   14339
Category:                   Resources/res_realtime
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     new
Asterisk Version:           SVN 
Regression:                 No 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!): 121856 
Request Review:              
====================================================================== 
Date Submitted:             2009-01-27 02:06 CST
Last Modified:              2009-01-27 02:14 CST
====================================================================== 
Summary:                    contrib/scripts/realtime_pgsql.sql misses uniqueid
in queue_member_table
Description: 
app_queue.c uses uniqueid in queue_member_table (to update member fields).

Add:
uniqueid serial NOT NULL,

...to the CREATE TABLE queue_member_table....
====================================================================== 

---------------------------------------------------------------------- 
 (0098819) fiddur (reporter) - 2009-01-27 02:14
 http://bugs.digium.com/view.php?id=14339#c98819 
---------------------------------------------------------------------- 
I updated from svn, added the fields I missed and made a diff:

> svn diff realtime_pgsql.sql 
Index: realtime_pgsql.sql
===================================================================
--- realtime_pgsql.sql  (revision 171522)
+++ realtime_pgsql.sql  (arbetskopia)
@@ -118,6 +118,7 @@
 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 @@
 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; 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-01-27 02:14 fiddur         Note Added: 0098819                          
======================================================================