Yes, go for it. However I have added another autoincrement column and created the primary key on it. 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">
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>--<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>