From c05747de89d4de94edf0af13b31ca83daffdbd19 Mon Sep 17 00:00:00 2001 From: markster Date: Mon, 26 Jan 2004 05:54:40 +0000 Subject: 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 --- contrib/scripts/iax-friends.sql | 14 ++++++++++++++ contrib/scripts/sip-friends.sql | 13 +++++++++++++ 2 files changed, 27 insertions(+) create mode 100755 contrib/scripts/iax-friends.sql create mode 100755 contrib/scripts/sip-friends.sql (limited to 'contrib/scripts') 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; -- cgit v1.2.3