Tag : MySQL

Asterisk unixODBC configuration files for MySQL and MariaDB

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

Tags: API, asterisk, compliant data source, Data, Driver, linkedin, ms windows platforms, MySQL, source, unified communication solution, unixodbc project

1.0 Asterisk + unixODBCHaving almost all of our Asterisk configuration based on our preferred Database Management System is one of the greatest advantages that we have at the moment to deploy a VoIP solution. Now, having the possibility of building ..

Read more

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