Summary: | ASTERISK-23825: Alembic scripts - table queue_members missing unique index on column uniqueid | ||
Reporter: | Stephen More (mores) | Labels: | |
Date Opened: | 2014-06-05 19:56:13 | Date Closed: | 2014-08-06 11:53:23 |
Priority: | Minor | Regression? | |
Status: | Closed/Complete | Components: | Contrib/General |
Versions: | 12.3.0 | Frequency of Occurrence | |
Related Issues: | |||
Environment: | Attachments: | ||
Description: | 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 | ||
Comments: | By: Matt Jordan (mjordan) 2014-06-05 21:47:15.009-0500 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? By: Stephen More (mores) 2014-06-12 09:34:24.959-0500 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 |