[OpenSIPS-Users] MediaProxy 2.6.1 - manually creating media_sessions table

Edwin eahaselhoff at gmail.com
Fri Jul 25 16:23:36 CEST 2014


Hi Gary,

If you give your database user CREATE rights the database is greated at
first start.

But to answer your question:
CREATE TABLE IF NOT EXISTS `media_sessions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `call_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `from_tag` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `to_tag` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `info` mediumblob,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=52 ;

Cheers,

Edwin



--
View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/MediaProxy-2-6-1-manually-creating-media-sessions-table-tp7592620p7592621.html
Sent from the OpenSIPS - Users mailing list archive at Nabble.com.



More information about the Users mailing list