Add tables for iax and sip friends (bug #913)

git-svn-id: http://svn.digium.com/svn/asterisk/trunk@2076 f38db490-d61c-443f-a65b-d21fe96a405b

2 files changed, 27 insertions, 0 deletions

diff --git a/contrib/scripts/iax-friends.sql b/contrib/scripts/iax-friends.sql
new file mode 100755
index 000000000..d919ab16f
--- /dev/null
+++ b/contrib/scripts/iax-friends.sql
@@ -0,0 +1,14 @@
+#
+# Table structure for table `iaxfriends`
+#
+
+CREATE TABLE `iaxfriends` (
+  `name` varchar(40) NOT NULL default '',
+  `secret` varchar(40) NOT NULL default '',
+  `context` varchar(40) NOT NULL default '',
+  `ipaddr` varchar(20) NOT NULL default '',
+  `port` int(6) NOT NULL default '0',
+  `regseconds` int(11) NOT NULL default '0',
+  PRIMARY KEY  (`name`)
+) TYPE=MyISAM;
+
diff --git a/contrib/scripts/sip-friends.sql b/contrib/scripts/sip-friends.sql
new file mode 100755
index 000000000..30e4ec366
--- /dev/null
+++ b/contrib/scripts/sip-friends.sql
@@ -0,0 +1,13 @@
+#
+# Table structure for table `sipfriends`
+#
+
+CREATE TABLE `sipfriends` (
+  `name` varchar(40) NOT NULL default '',
+  `secret` varchar(40) NOT NULL default '',
+  `context` varchar(40) NOT NULL default '',
+  `ipaddr` varchar(20) NOT NULL default '',
+  `port` int(6) NOT NULL default '0',
+  `regseconds` int(11) NOT NULL default '0',
+  PRIMARY KEY  (`name`)
+) TYPE=MyISAM;