[asterisk-bugs] [JIRA] (ASTERISK-23825) table queue_members missing unique index on column uniqueid

[Matt Jordan (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-23825?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=219110#comment-219110 ] 

Matt Jordan commented on ASTERISK-23825:
----------------------------------------

That may be a nice improvement for that table, but why are you inserting multiple Queue members with the same unique ID into that table in the first place?

> table queue_members missing unique index on column uniqueid
> -----------------------------------------------------------
>
>                 Key: ASTERISK-23825
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-23825
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Contrib/General
>    Affects Versions: 12.3.0
>            Reporter: Stephen More
>            Severity: Minor
>
> contrib/ast-db-manage/config queue_members table needs to be altered to add unique index on uniqueid.
> If two members have the same uniqueid, only one will show up in *CLI> queue show



--
This message was sent by Atlassian JIRA
(v6.2#6252)