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 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_4...@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 >> >> -- >> _____________________________________________________________________ >> -- Bandwidth and Colocation Provided by http://www.api-digital.com -- >> New to Asterisk? Join us for a live introductory webinar every Thurs: >> http://www.asterisk.org/hello >> >> asterisk-users mailing list >> To UNSUBSCRIBE or update options visit: >> http://lists.digium.com/mailman/listinfo/asterisk-users >> > > > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > > > > -- > Ron Wheeler > President > Artifact Software Inc > email: rwhee...@artifact-software.com > skype: ronaldmwheeler > phone: 866-970-2435, ext 102 > > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users