asterisk users - Dec 2012 - CDR - Freepbx - Safe to add primary key to table ?

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

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>