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

[Don Kelly]

This thread confuses me. I've not worked with the Asterisk MySQL CDR, but
have worked with SQL for years.

 

Every table should have a primary key. Is no column identified as a PK?

 

If there is a PK, you will not be able to designate another column as PK.

 

If there is a PK, you don't need to worry about Asterisk duplicating keys in
that column-the database will not permit non-unique PKs.

 

If (and this would be really weird) the table is created with no primary
key, it shouldn't be a problem to add the primary key constraint to a column
IF there are no nulls or duplicates existing.

--Don

 

From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Leandro
Dardini
Sent: Thursday, December 06, 2012 12:50 PM
To: rwheeler at artifact-software.com; Asterisk Users Mailing List -
Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR - Freepbx - Safe to add primary key to
table ?

 

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

--



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20121207/e1c07756/attachment.htm>