diff options
| author | Michael L. Young <elgueromexicano@gmail.com> | 2013-03-12 20:41:42 +0000 |
|---|---|---|
| committer | Michael L. Young <elgueromexicano@gmail.com> | 2013-03-12 20:41:42 +0000 |
| commit | 6a57a36d288c55cdc2b793a5386bc28ca6dbe8f1 (patch) | |
| tree | b0e99cd7dd9c6262979b98a869f5f92cc4081eab /contrib/realtime | |
| parent | 9a992c6cba9d0245898bf6f3b7b1d174e53da95a (diff) | |
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
Diffstat (limited to 'contrib/realtime')
| -rw-r--r-- | contrib/realtime/mysql/sippeers.sql | 14 | ||||
| -rw-r--r-- | contrib/realtime/postgresql/realtime.sql | 2 |
2 files changed, 8 insertions, 8 deletions
diff --git a/contrib/realtime/mysql/sippeers.sql b/contrib/realtime/mysql/sippeers.sql index 1b01b2809..8ca2821df 100644 --- 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, - `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, - `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, - `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, @@ -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, - `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, @@ -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, - `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, diff --git a/contrib/realtime/postgresql/realtime.sql b/contrib/realtime/postgresql/realtime.sql index 96cbb16c2..63f57de29 100644 --- 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), -defaultip character varying(15), +defaultip character varying(45), dtmfmode character varying(7), fromuser character varying(80), fromdomain character varying(80), |