Archives : June-2011

MySQL/MariaDB CDR Schema

Posted June 28, 2011 by Pavel Espinal & filed under Initial Configuration of Asterisk Comments: 0.

Tags: Auto, datetime, for, MariaDB, MySQL, NOT, table schema, unicode, varchar

If you are using MySQL or MariaDB, this table schema for CDR table could be useful: CREATE TABLE `cdr` (`calldate` datetime NOT NULL DEFAULT 0000-00-00 00:00:00,`clid` varchar(80) COLLATE utf8_unicode_ci NOT NULL,`src` varchar(80) COLLATE utf8_unicode..

Read more

MySQL CEL Table Schema

Posted June 28, 2011 by Pavel Espinal & filed under Initial Configuration of Asterisk Comments: 0.

Tags: asterisk billing, asterisk cel, asterisk cel mysql, auto increment, billing applications, business voip, cdr records, CEL, End, NOT, storage engine, table schema, time

If you are using MySQL or MariaDB, this is the table schema for CEL ODBC backed:CREATE TABLE `cel` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`e..

Read more

Annotations and Tips About Asterisk and VoIP

Posted June 28, 2011 by Pavel Espinal & filed under General Comments: 0.

Tags: agony, asterisk, Auto, idea, post, reading guide, time, time post

So, I finally got some time out to write about Asterisk and post some (hopefully relevant and useful) tips about it. The idea is to increase my understanding of Asterisk while at the same time post things that might help someone out there.There are s..

Read more