Hello, Still about CDR and MySQL table, should the calldate field be inserted by Asterisk?
This is the table structure we are using, based on Asterisk wiki: mysql> describe cdr; +-------------+-----------------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+-----------------------+------+-----+---------------------+----------------+ | id | mediumint(8) unsigned | NO | PRI | NULL | auto_increment | | calldate | datetime | NO | | 0000-00-00 00:00:00 | | | clid | varchar(80) | NO | | | | | src | varchar(80) | NO | | | | | dst | varchar(80) | NO | | | | | dcontext | varchar(80) | NO | | | | | channel | varchar(80) | NO | | | | | dstchannel | varchar(80) | NO | | | | | lastapp | varchar(80) | NO | | | | | lastdata | varchar(80) | NO | | | | | duration | int(11) | NO | | 0 | | | billsec | int(11) | NO | | 0 | | | disposition | varchar(45) | NO | | | | | amaflags | int(11) | NO | | 0 | | | accountcode | varchar(20) | NO | | | | | uniqueid | varchar(32) | NO | | | | | userfield | varchar(255) | NO | | | | | peeraccount | varchar(20) | NO | | | | | linkedid | varchar(32) | NO | | | | | sequence | int(11) | NO | | 0 | | +-------------+-----------------------+------+-----+---------------------+----------------+ 20 rows in set (0.01 sec) Thank you! 2013/6/4 Olivier <oza_4...@yahoo.fr> > OK, then I'll go with linkedid, uniqueid and sequence number. > > Thanks for sharing this on this list > > > 2013/6/3 Matthew Jordan <mjor...@digium.com> > >> On 06/03/2013 11:20 AM, Olivier wrote: >> > Hi, >> > >> > When dealing with CDR SQL tables, I always added an auto-incremented >> > cdr_id key as a primary key, just in case provided uniqueid key went >> wrong. >> > >> > Now I'm facing a situation where I need to insert into a database's >> > table and from the dialplan, a reference to the CDR record which is >> > currently processed. >> > >> > So my questions are: >> > >> > 1. Can uniqueid/sequence (or uniqueid/sequence/calldate) bundle be >> > safely used as CDR's table primary key (ie I cannot have any >> > uniqueid/sequence combination from one CDR record to match a past >> > uniqueid/sequence combination) ? >> >> Possibly. Things to keep in mind: >> >> * You can run into uniqueid collisions across multiple systems if you do >> not specify a system name in asterisk.conf or do not specify a unique >> system name in asterisk.conf. >> * You can run into uniqueid collisions if your system clock goes >> backwards for any reason (the uniqueid for a channel happens to use a >> timestamp for its uniqueness) >> >> Whether or not this is unique enough will be completely dependent on >> your overall system configuration. >> >> In general, the recommended combination that *should* uniquely specify a >> CDR (when configured correctly) is linkedid (which should be enabled and >> added to your schema), uniqueid, and sequence number, with the asterisk >> system name specified. >> >> -- >> Matthew Jordan >> Digium, Inc. | Engineering Manager >> 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA >> Check us out at: http://digium.com & http://asterisk.org >> >> >> >> -- >> _____________________________________________________________________ >> -- 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 > -- Jairo Molina Jr∴ http://www.intermol.com.br
-- _____________________________________________________________________ -- 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