summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMark Spencer <markster@digium.com>2004-01-26 05:54:40 +0000
committerMark Spencer <markster@digium.com>2004-01-26 05:54:40 +0000
commit39f0e4b20776116925b0f535568c856129d6b362 (patch)
tree1425110eafc66ffc560711ea4906fb4c153d8236
parent1b3e733e1c1347a6cb648fd3b3fd6b19b3e56467 (diff)
Add tables for iax and sip friends (bug #913)
git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@2076 65c4cc65-6c06-0410-ace0-fbb531ad65f3
-rwxr-xr-xcontrib/scripts/iax-friends.sql14
-rwxr-xr-xcontrib/scripts/sip-friends.sql13
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;