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