1 files changed, 62 insertions, 0 deletions

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