Tag : datetime

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