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

[Leandro Dardini]

The reason I add a new column autoincrement is due to the fact I trust more
mysql about uniquness than asterisk.

Leandro

I am typing from my mobile phone...
Il giorno 06/dic/2012 19:11, "Ron Wheeler" <rwheeler at artifact-software.com>
ha scritto:

>  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>
>
>> 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
>
>
> --
> _____________________________________________________________________
> -- 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20121206/fc620026/attachment.htm>