<div dir="ltr">Uhm ... I see the easy way will be to tcpdump the connection between the asterisk and the mysql database server and to dump the exact SQL syntax used. It will be something wrong...<div><br></div><div>Leandro</div>
<div><br></div><div style>PS</div><div style>tcpdump -i any -n -s 1500 -w /tmp/data.pcap port 3306</div><div style><br></div><div style><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/4/18 Tommy Cooper <span dir="ltr"><<a href="mailto:tomcooper83@yahoo.com" target="_blank">tomcooper83@yahoo.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="font-size:12pt;font-family:times new roman,new york,times,serif"><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></var></span></div>
<div style="font-size:16px;font-style:normal;background-color:transparent;font-family:times new roman,new york,times,serif"><span></span> </div>
<div style="font-size:16px;font-style:normal;background-color:transparent;font-family:times new roman,new york,times,serif"><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 face="Arial"><b><span style="FONT-WEIGHT:bold">From:</span></b> Leandro Dardini <<a href="mailto:ldardini@gmail.com" target="_blank">ldardini@gmail.com</a>><br>
<b><span style="FONT-WEIGHT:bold">To:</span></b> Tommy Cooper <<a href="mailto:tomcooper83@yahoo.com" target="_blank">tomcooper83@yahoo.com</a>>; Asterisk Users Mailing List - Non-Commercial Discussion <<a href="mailto:asterisk-users@lists.digium.com" target="_blank">asterisk-users@lists.digium.com</a>> <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><br>
<div>
<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></var></div></div></div></div></div></div></div></div></div><br>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br></div>