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

Olivier oza_4h07 at yahoo.fr
Thu Dec 6 11:23:06 CST 2012


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>


More information about the asterisk-users mailing list