diff options
Diffstat (limited to 'contrib/realtime/mysql')
| -rw-r--r-- | contrib/realtime/mysql/sippeers.sql | 14 |
1 files changed, 7 insertions, 7 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, |