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)