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

[Stephen More (JIRA)]

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

Stephen More commented on ASTERISK-23825:
-----------------------------------------

I built a simple CRUD web interface that allows our helpdesk to update the tables. Because the table allows it so did the CRUD interface.
In my environment I fixed it with:

alter table queue_members add UNIQUE INDEX (uniqueid);
alter table queue_members modify uniqueid int(10) unsigned NOT NULL auto_increment;

Now the helpdesk is unable to make an error with uniqueid




> 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
>            Assignee: 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)