Tag : table schema

MySQL and MariaDB voicemessages Schema

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

Tags: callerid, default, innodb, MariaDB, msgnum, MySQL, storage engine, table schema

If you are using MySQL or MariaDB, and are planning to use ODBC storage for Voicemail, this table schema for voicemessages table could be useful.The storage engine has explicitly been defined as MyISAM. Recent versions of MySQL use InnoDB by defau..

Read more

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