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

[Leandro Dardini]

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