Tag : NOT

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