ssion
*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
[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"
ha scritto:
I
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"
ha scritto:
> It seems like a safe thing to do.
> You could also ask about the impact of makin
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
2012/12/6 Leandro Dardini
> 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 reason, a
unique
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
> Hello,
>
> I need to develop an application that will query (mostly reading) an
> existing MySQL C
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 t