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 <hud@zurich.ibm.com>

   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

