[asterisk-users] CDR - Freepbx - Safe to add primary key to table ?

[Ron Wheeler]

It seems like a safe thing to do.
You could also ask about the impact of making an existing column a  
primary key, in a MySQL forum.

Leandro's solution seems to be a good one as well and does guarantee 
uniqueness.



Ron

On 06/12/2012 12:25 PM, Leandro Dardini wrote:
> 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.
>
> Leandro
>
> 2012/12/6 Olivier <oza_4h07 at yahoo.fr <mailto:oza_4h07 at yahoo.fr>>
>
>     Hello,
>
>     I need to develop an application that will query (mostly reading)
>     an existing MySQL CDR database.
>     This database (named asteriskcdrdb) was created during Freepbx
>     2.10 install on my asterisk 1.8 setup.
>     This database has a single CDR table which is filled by Asterisk.
>
>     The tools I'm planning to use require this table to include a
>     Primary Key.
>     Is it safe to Alter this table telling it to use UniqueID column
>     as a Primary Key ?
>
>     (Sure, I'll test this on a database copy but I'm not confident my
>     tests will cover everything)
>
>     Regards
>
>     --
>     _____________________________________________________________________
>     -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>     New to Asterisk? Join us for a live introductory webinar every Thurs:
>     http://www.asterisk.org/hello
>
>     asterisk-users mailing list
>     To UNSUBSCRIBE or update options visit:
>     http://lists.digium.com/mailman/listinfo/asterisk-users
>
>
>
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>                 http://www.asterisk.org/hello
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>     http://lists.digium.com/mailman/listinfo/asterisk-users


-- 
Ron Wheeler
President
Artifact Software Inc
email: rwheeler at artifact-software.com
skype: ronaldmwheeler
phone: 866-970-2435, ext 102

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20121206/3da1c0f5/attachment.htm>