I use following for MySQL... CREATE TABLE queue_log( id int(11) NOT NULL auto_increment, time datetime not null, queuename VARCHAR(50), agent VARCHAR(50), callid varchar(32), event VARCHAR(100), data1 VARCHAR(100), data2 VARCHAR(100), data3 VARCHAR(100), data4 VARCHAR(100), data5 VARCHAR(100), PRIMARY KEY (id) ) ENGINE=InnoDB ;
Check the link to know the meaning of data1,data2... for Events. http://www.voip-info.org/wiki/view/Asterisk+log+queue_log [SATISH] On Mon, Jun 6, 2011 at 1:49 PM, Ishfaq Malik <i...@pack-net.co.uk> wrote: > On Thu, 2011-06-02 at 16:03 +0100, Ishfaq Malik wrote: > > Hi Does anyone know of an accurate resource I could refer to for this? > > > > The best I can find is > > > > http://www.voip-info.org/wiki/view/Asterisk+queue_log+on+MySQL > > > > And that table wont create in my database... > > > > Thanks > > > > Ish > > Can someone at least point me to the source file that I can analyse to > find out the table requirements? > > Ish > > -- > Ishfaq Malik > Software Developer > PackNet Ltd > > Office: 0161 660 3062 > > > -- > _____________________________________________________________________ > -- 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