<br><br><div class="gmail_quote">2012/12/6 Leandro Dardini <span dir="ltr"><<a href="mailto:ldardini@gmail.com" target="_blank">ldardini@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Yes, go for it. However I have added another autoincrement column and created the primary key on it.</blockquote><div><br>May I ask why did you choose to add a new column ?<br>I'm hesitating between both solutions.<br>
For me, your solution has the advantage that, if, for any reason, a uniqueid is missing, it would still work ok.<br><br> </div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
On the other columns I need to search I have created just an index.<div><br></div><div>Leandro<br><br><div class="gmail_quote">
2012/12/6 Olivier <span dir="ltr"><<a href="mailto:oza_4h07@yahoo.fr" target="_blank">oza_4h07@yahoo.fr</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div class="h5">
Hello,<br><br>I need to develop an application that will query (mostly reading) an existing MySQL CDR database.<br>This database (named asteriskcdrdb) was created during Freepbx 2.10 install on my asterisk 1.8 setup.<br>
This database has a single CDR table which is filled by Asterisk.<br>
<br>The tools I'm planning to use require this table to include a Primary Key.<br>Is it safe to Alter this table telling it to use UniqueID column as a Primary Key ?<br><br>(Sure, I'll test this on a database copy but I'm not confident my tests will cover everything)<br>
<br>Regards<br>
<br></div></div><span class="HOEnZb"><font color="#888888">--<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></font></span></blockquote></div><br></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>