Update Contributed Realtime Schema Files - IPv6 Addresses

This commit updates some fields in the contributed realtime schema files to
handle IPv6 addresses.

(closes issue ASTERISK-21173)
Reported by: Torrey Searle
Patches:
  realtime_sql.patch Torrey Searle (license 5334)
  asterisk-21173-update-ip-fields.diff Michael L. Young (license 5026)
........

Merged revisions 382939 from http://svn.asterisk.org/svn/asterisk/branches/1.8
........

Merged revisions 382940 from http://svn.asterisk.org/svn/asterisk/branches/11

git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@382941 65c4cc65-6c06-0410-ace0-fbb531ad65f3

diff --git a/contrib/realtime/mysql/sippeers.sql b/contrib/realtime/mysql/sippeers.sql
index 1b01b28..8ca2821 100644 (file)
--- a/contrib/realtime/mysql/sippeers.sql
+++ b/contrib/realtime/mysql/sippeers.sql
@@ -5,19 +5,19 @@
 CREATE TABLE IF NOT EXISTS `sippeers` (
       `id` int(11) NOT NULL AUTO_INCREMENT,
       `name` varchar(10) NOT NULL,
 CREATE TABLE IF NOT EXISTS `sippeers` (
       `id` int(11) NOT NULL AUTO_INCREMENT,
       `name` varchar(10) NOT NULL,

-      `ipaddr` varchar(15) DEFAULT NULL,
+      `ipaddr` varchar(45) DEFAULT NULL,

       `port` int(5) DEFAULT NULL,
       `regseconds` int(11) DEFAULT NULL,
       `defaultuser` varchar(10) DEFAULT NULL,
       `port` int(5) DEFAULT NULL,
       `regseconds` int(11) DEFAULT NULL,
       `defaultuser` varchar(10) DEFAULT NULL,

-      `fullcontact` varchar(35) DEFAULT NULL,
+      `fullcontact` varchar(80) DEFAULT NULL,

       `regserver` varchar(20) DEFAULT NULL,
       `useragent` varchar(20) DEFAULT NULL,
       `lastms` int(11) DEFAULT NULL,
       `host` varchar(40) DEFAULT NULL,
       `type` enum('friend','user','peer') DEFAULT NULL,
       `context` varchar(40) DEFAULT NULL,
       `regserver` varchar(20) DEFAULT NULL,
       `useragent` varchar(20) DEFAULT NULL,
       `lastms` int(11) DEFAULT NULL,
       `host` varchar(40) DEFAULT NULL,
       `type` enum('friend','user','peer') DEFAULT NULL,
       `context` varchar(40) DEFAULT NULL,

-      `permit` varchar(40) DEFAULT NULL,
-      `deny` varchar(40) DEFAULT NULL,
+      `permit` varchar(95) DEFAULT NULL,
+      `deny` varchar(95) DEFAULT NULL,

       `secret` varchar(40) DEFAULT NULL,
       `md5secret` varchar(40) DEFAULT NULL,
       `remotesecret` varchar(40) DEFAULT NULL,
       `secret` varchar(40) DEFAULT NULL,
       `md5secret` varchar(40) DEFAULT NULL,
       `remotesecret` varchar(40) DEFAULT NULL,

@@ -56,7 +56,7 @@ CREATE TABLE IF NOT EXISTS `sippeers` (
       `fromdomain` varchar(40) DEFAULT NULL,
       `fromuser` varchar(40) DEFAULT NULL,
       `qualify` varchar(40) DEFAULT NULL,
       `fromdomain` varchar(40) DEFAULT NULL,
       `fromuser` varchar(40) DEFAULT NULL,
       `qualify` varchar(40) DEFAULT NULL,

-      `defaultip` varchar(40) DEFAULT NULL,
+      `defaultip` varchar(45) DEFAULT NULL,

       `rtptimeout` int(11) DEFAULT NULL,
       `rtpholdtimeout` int(11) DEFAULT NULL,
       `sendrpid` enum('yes','no') DEFAULT NULL,
       `rtptimeout` int(11) DEFAULT NULL,
       `rtpholdtimeout` int(11) DEFAULT NULL,
       `sendrpid` enum('yes','no') DEFAULT NULL,

@@ -66,8 +66,8 @@ CREATE TABLE IF NOT EXISTS `sippeers` (
       `timerb` int(11) DEFAULT NULL,
       `qualifyfreq` int(11) DEFAULT NULL,
       `constantssrc` enum('yes','no') DEFAULT NULL,
       `timerb` int(11) DEFAULT NULL,
       `qualifyfreq` int(11) DEFAULT NULL,
       `constantssrc` enum('yes','no') DEFAULT NULL,

-      `contactpermit` varchar(40) DEFAULT NULL,
-      `contactdeny` varchar(40) DEFAULT NULL,
+      `contactpermit` varchar(95) DEFAULT NULL,
+      `contactdeny` varchar(95) DEFAULT NULL,

       `usereqphone` enum('yes','no') DEFAULT NULL,
       `textsupport` enum('yes','no') DEFAULT NULL,
       `faxdetect` enum('yes','no') DEFAULT NULL,
       `usereqphone` enum('yes','no') DEFAULT NULL,
       `textsupport` enum('yes','no') DEFAULT NULL,
       `faxdetect` enum('yes','no') DEFAULT NULL,

diff --git a/contrib/realtime/postgresql/realtime.sql b/contrib/realtime/postgresql/realtime.sql
index 96cbb16..63f57de 100644 (file)
--- a/contrib/realtime/postgresql/realtime.sql
+++ b/contrib/realtime/postgresql/realtime.sql
@@ -40,7 +40,7 @@ callerid character varying(80),
 canreinvite character varying(3) DEFAULT 'yes',
 supportpath character varying(3) DEFAULT 'no',
 context character varying(80),
 canreinvite character varying(3) DEFAULT 'yes',
 supportpath character varying(3) DEFAULT 'no',
 context character varying(80),

-defaultip character varying(15),
+defaultip character varying(45),

 dtmfmode character varying(7),
 fromuser character varying(80),
 fromdomain character varying(80),
 dtmfmode character varying(7),
 fromuser character varying(80),
 fromdomain character varying(80),