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

2012-12-07 Thread Don Kelly
] 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 rwhee...@artifact-software.com ha scritto

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

2012-12-07 Thread Jeff LaCoursiere
] 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 rwhee...@artifact-software.com

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

2012-12-06 Thread Olivier
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

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

2012-12-06 Thread 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_4...@yahoo.fr Hello, I need to develop an application that will query (mostly reading) an

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

2012-12-06 Thread Olivier
2012/12/6 Leandro Dardini ldard...@gmail.com Yes, go for it. However I have added another autoincrement column and created the primary key on it. May I ask why did you choose to add a new column ? I'm hesitating between both solutions. For me, your solution has the advantage that, if, for any

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

2012-12-06 Thread Ron Wheeler
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

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

2012-12-06 Thread Leandro Dardini
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 rwhee...@artifact-software.com ha scritto: It seems like a safe thing to do. You could also