From e7cd583c1edcea7f600064fac89a94a52a84a553 Mon Sep 17 00:00:00 2001 From: Dr Scofield Date: Wed, 1 Oct 2008 20:18:57 +0000 Subject: removing asterisk: it's now living at http://forge.opensimulator.org/gf/project/asteriskvoice/ --- share/python/asterisk/create-table.sql | 62 ---------------------------------- 1 file changed, 62 deletions(-) delete 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 deleted file mode 100644 index 4fe190f..0000000 --- a/share/python/asterisk/create-table.sql +++ /dev/null @@ -1,62 +0,0 @@ -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