From 6f8ff326307ae1522e2f3163596b0bf1cdd2157f Mon Sep 17 00:00:00 2001 From: Sean Dague Date: Tue, 15 Apr 2008 14:24:15 +0000 Subject: From: Dr Scofield ansgar and i have been working on an asterisk voice module that will allow us to couple opensim with an asterisk VoIP gateway. the patch below consists of * AsteriskVoiceModule region module: alternative to the plain-vanilla VoiceModule, will make XmlRpc calls out to an asterisk-opensim frontend * asterisk-opensim.py frontend, living in share/python/asterisk, takes XmlRpc calls from the AsteriskVoiceModule * account_update: to update/create a new SIP account (on ProvisionVoiceAccountRequest) * region_update: to update/create a new "region" conference call (on ParcelVoiceInfo) * a asterisk-opensim test client, living in share/python/asterisk, to exercise astersik-opensim.py this still does not give us voice in OpenSim, but it's another step on this path... --- share/python/asterisk/create-table.sql | 62 ++++++++++++++++++++++++++++++++++ 1 file changed, 62 insertions(+) create mode 100644 share/python/asterisk/create-table.sql (limited to 'share/python/asterisk/create-table.sql') diff --git a/share/python/asterisk/create-table.sql b/share/python/asterisk/create-table.sql new file mode 100644 index 0000000..4fe190f --- /dev/null +++ b/share/python/asterisk/create-table.sql @@ -0,0 +1,62 @@ +USE %(database)s; +CREATE TABLE IF NOT EXISTS `ast_sipfriends` ( + `id` int(11) NOT NULL auto_increment, + `name` varchar(80) NOT NULL default '', + `host` varchar(31) NOT NULL default 'dynamic', + `nat` varchar(5) NOT NULL default 'route', + `type` enum('user','peer','friend') NOT NULL default 'friend', + `accountcode` varchar(20) default NULL, + `amaflags` varchar(13) default NULL, + `callgroup` varchar(10) default NULL, + `callerid` varchar(80) default NULL, + `call-limit` int(11) NOT NULL default '0', + `cancallforward` char(3) default 'no', + `canreinvite` char(3) default 'no', + `context` varchar(80) default 'pre_outgoing', + `defaultip` varchar(15) default NULL, + `dtmfmode` varchar(7) default NULL, + `fromuser` varchar(80) default NULL, + `fromdomain` varchar(80) default NULL, + `insecure` varchar(4) default NULL, + `language` char(2) default NULL, + `mailbox` varchar(50) default NULL, + `md5secret` varchar(80) default NULL, + `deny` varchar(95) default NULL, + `permit` varchar(95) default NULL, + `mask` varchar(95) default NULL, + `musiconhold` varchar(100) default NULL, + `pickupgroup` varchar(10) default NULL, + `qualify` char(3) default NULL, + `regexten` varchar(80) default NULL, + `restrictcid` char(3) default NULL, + `rtptimeout` char(3) default NULL, + `rtpholdtimeout` char(3) default NULL, + `secret` varchar(80) default NULL, + `setvar` varchar(100) default NULL, + `disallow` varchar(100) default 'all', + `allow` varchar(100) default 'g729', + `fullcontact` varchar(80) NOT NULL default '', + `ipaddr` varchar(15) NOT NULL default '', + `port` smallint(5) unsigned NOT NULL default '0', + `regserver` varchar(100) default NULL, + `regseconds` int(11) NOT NULL default '0', + `username` varchar(80) NOT NULL default '', + `user` varchar(255) NOT NULL, + `placement` varchar(255) NOT NULL, + `description` varchar(255) NOT NULL, + `delay` int(4) NOT NULL default '0', + `sortorder` int(11) NOT NULL default '1', + PRIMARY KEY (`id`), + UNIQUE KEY `name` (`name`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; + +CREATE TABLE IF NOT EXISTS `extensions_table` ( + `id` int(11) NOT NULL auto_increment, + `context` varchar(20) NOT NULL default '', + `exten` varchar(36) NOT NULL default '', + `priority` tinyint(4) NOT NULL default '0', + `app` varchar(20) NOT NULL default '', + `appdata` varchar(128) NOT NULL default '', + PRIMARY KEY (`context`,`exten`,`priority`), + KEY `id` (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; \ No newline at end of file -- cgit v1.1