<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><DIV><SPAN>Thank you for your response</SPAN></DIV>
<DIV><SPAN></SPAN> </DIV>
<DIV><SPAN>I already have a name column but my primary key is 'QueueID' instead of name<VAR id=yiv18722196yui-ie-cursor></VAR></SPAN></DIV>
<DIV style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman, new york, times, serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px"><SPAN></SPAN> </DIV>
<DIV style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman, new york, times, serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px"><SPAN>+-----------------------------+-----------------------+------+-----+------------+----------------+<BR>| Field | Type | Null | Key | Default | Extra |<BR>+-----------------------------+-----------------------+------+-----+------------+----------------+<BR>| QueueID | mediumint(8) unsigned | NO | PRI | NULL | auto_increment |<BR>|
name | varchar(128) | NO | UNI | NULL | |<BR>| description | varchar(128) | YES | | NULL | |<BR>| maxlen | tinyint(4) | YES
| | NULL | |<BR>| reportholdtime | varchar(3) | YES | | no | |<BR>| periodic_announce_frequency | varchar(4) | YES | | NULL | |<BR>| periodic_announce | varchar(128) |
YES | | NULL | |<BR>| strategy | varchar(20) | NO | | rrmemory | |<BR>| joinempty | varchar(35) | YES | | no | |<BR>|
leavewhenempty | varchar(35) | YES | | no | |<BR>| autopause | varchar(3) | YES | | no | |<BR>| announce_round_seconds | varchar(4) | YES | | NULL
| |<BR>| retry | varchar(4) | YES | | NULL | |<BR>| wrapuptime | varchar(4) | YES | | NULL | |<BR>| announce_holdtime |
varchar(3) | YES | | no | |<BR>| announce_frequency | varchar(4) | YES | | 0 | |<BR>| timeout | varchar(4) | YES | | 60
| |<BR>| context | varchar(128) | NO | | NULL | |<BR>| musicclass | varchar(128) | YES | | default | |<BR>| autofill |
varchar(3) | YES | | yes | |<BR>| ringinuse | varchar(45) | YES | | no | |<BR>| musiconhold | varchar(128) | YES | | yes
| |<BR>| monitor_type | varchar(128) | YES | | MixMonitor | |<BR>| monitor_format | varchar(128) | YES | | wav | |<BR>| servicelevel | varchar(4) | YES
| | 60 | |<BR>| queue_thankyou | varchar(128) | YES | | | |<BR>| queue_youarenext | varchar(128) | YES | | | |<BR>|
queue_thereare | varchar(128) | YES | | | |<BR>| queue_callswaiting | varchar(128) | YES | | | |<BR>| queue_holdtime | varchar(128) | YES |
| | |<BR>| queue_minutes | varchar(128) | YES | | | |<BR>| queue_seconds | varchar(128) | YES | | | |<BR>|
queue_lessthan | varchar(128) | YES | | | |<BR>| queue_reporthold | varchar(128) | YES | | | |<BR>| relative_periodic_announce | varchar(4) | YES | | yes
| |<BR>+-----------------------------+-----------------------+------+-----+------------+----------------+<BR>35 rows in set (0.00 sec)<BR></SPAN></DIV>
<DIV><BR></DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">
<DIV dir=ltr>----- Forwarded Message -----<BR><FONT size=2 face=Arial><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Leandro Dardini <ldardini@gmail.com><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Tommy Cooper <tomcooper83@yahoo.com>; Asterisk Users Mailing List - Non-Commercial Discussion <asterisk-users@lists.digium.com> <BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Thursday, April 18, 2013 11:04 PM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: [asterisk-users] Dynamic realtime + queues<BR></FONT></DIV>
<DIV class=yiv18722196y_msg_container><BR>
<DIV id=yiv18722196>
<DIV dir=ltr>You need a "name" column. This is my queue table:
<DIV><BR></DIV>
<DIV>
<DIV>CREATE TABLE IF NOT EXISTS `queue` (</DIV>
<DIV> `name` varchar(128) NOT NULL,</DIV>
<DIV> `musiconhold` varchar(128) DEFAULT NULL,</DIV>
<DIV> `announce` varchar(128) DEFAULT NULL,</DIV>
<DIV> `context` varchar(128) DEFAULT NULL,</DIV>
<DIV> `timeout` int(11) DEFAULT NULL,</DIV>
<DIV> `monitor_join` tinyint(1) DEFAULT NULL,</DIV>
<DIV> `monitor_format` varchar(128) DEFAULT NULL,</DIV>
<DIV> `queue_youarenext` varchar(128) DEFAULT NULL,</DIV>
<DIV> `queue_thereare` varchar(128) DEFAULT NULL,</DIV>
<DIV> `queue_callswaiting` varchar(128) DEFAULT NULL,</DIV>
<DIV> `queue_holdtime` varchar(128) DEFAULT NULL,</DIV>
<DIV> `queue_minutes` varchar(128) DEFAULT NULL,</DIV>
<DIV> `queue_seconds` varchar(128) DEFAULT NULL,</DIV>
<DIV> `queue_lessthan` varchar(128) DEFAULT NULL,</DIV>
<DIV> `queue_thankyou` varchar(128) DEFAULT NULL,</DIV>
<DIV> `queue_reporthold` varchar(128) DEFAULT NULL,</DIV>
<DIV> `announce_frequency` int(11) DEFAULT NULL,</DIV>
<DIV> `announce_round_seconds` int(11) DEFAULT NULL,</DIV>
<DIV> `announce_holdtime` varchar(128) DEFAULT NULL,</DIV>
<DIV> `retry` int(11) DEFAULT NULL,</DIV>
<DIV> `wrapuptime` int(11) DEFAULT NULL,</DIV>
<DIV> `maxlen` int(11) DEFAULT NULL,</DIV>
<DIV> `servicelevel` int(11) DEFAULT NULL,</DIV>
<DIV> `strategy` varchar(128) DEFAULT NULL,</DIV>
<DIV> `joinempty` varchar(128) DEFAULT NULL,</DIV>
<DIV> `leavewhenempty` varchar(128) DEFAULT NULL,</DIV>
<DIV> `eventmemberstatus` tinyint(1) DEFAULT NULL,</DIV>
<DIV> `eventwhencalled` tinyint(1) DEFAULT NULL,</DIV>
<DIV> `reportholdtime` tinyint(1) DEFAULT NULL,</DIV>
<DIV> `memberdelay` int(11) DEFAULT NULL,</DIV>
<DIV> `weight` int(11) DEFAULT NULL,</DIV>
<DIV> `timeoutrestart` tinyint(1) DEFAULT NULL,</DIV>
<DIV> `periodic_announce` varchar(50) DEFAULT NULL,</DIV>
<DIV> `periodic_announce_frequency` int(11) DEFAULT NULL,</DIV>
<DIV> `ringinuse` tinyint(1) DEFAULT NULL,</DIV>
<DIV> `setinterfacevar` tinyint(1) DEFAULT NULL,</DIV>
<DIV> PRIMARY KEY (`name`)</DIV>
<DIV>) ENGINE=MyISAM DEFAULT CHARSET=latin1;<VAR id=yui-ie-cursor></VAR></DIV></DIV></DIV></DIV></DIV></DIV></DIV></div></body></html>