[asterisk-bugs] [Asterisk 0014339]: [patch] 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:                svnbot
====================================================================== 
Project:                    Asterisk
Issue ID:                   14339
Category:                   Resources/res_realtime
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     closed
Asterisk Version:           SVN 
Regression:                 No 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!): 121856 
Request Review:              
Resolution:                 fixed
Fixed in Version:           
====================================================================== 
Date Submitted:             2009-01-27 02:06 CST
Last Modified:              2009-01-29 07:51 CST
====================================================================== 
Summary:                    [patch] 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....
====================================================================== 

---------------------------------------------------------------------- 
 (0099050) svnbot (reporter) - 2009-01-29 07:51
 http://bugs.digium.com/view.php?id=14339#c99050 
---------------------------------------------------------------------- 
Repository: asterisk
Revision: 172273

_U  branches/1.6.0/
U   branches/1.6.0/contrib/scripts/realtime_pgsql.sql

------------------------------------------------------------------------
r172273 | lmadsen | 2009-01-29 07:51:01 -0600 (Thu, 29 Jan 2009) | 13
lines

Merged revisions 172271 via svnmerge from 
https://origsvn.digium.com/svn/asterisk/trunk

........
  r172271 | lmadsen | 2009-01-29 08:47:27 -0500 (Thu, 29 Jan 2009) | 5
lines
  
  The realtime_pgsql.sql script is missing a couple of fields.
  closes issue http://bugs.digium.com/view.php?id=14339)
  Reported by: fiddur
  Patches:
        realtime_pgsql.sql.diff uploaded by fiddur (license 678)
........

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk?view=rev&revision=172273 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-01-29 07:51 svnbot         Checkin                                      
2009-01-29 07:51 svnbot         Note Added: 0099050                          
======================================================================