diff options
| author | tilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b> | 2010-07-16 04:18:58 +0000 |
|---|---|---|
| committer | tilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b> | 2010-07-16 04:18:58 +0000 |
| commit | 22b2dbca0bfbe7ad64528623e368afdfb76f7876 (patch) | |
| tree | 7c40cda56c3bcb72f6854bae4607839fc844df07 /contrib | |
| parent | ceff8cd7884ba1c07c236938ced5553730f3c33e (diff) | |
Allow ipaddress to contain the maximum IPv6 address.
Also, update meetme to the full list of supported fields.
git-svn-id: http://svn.digium.com/svn/asterisk/trunk@276869 f38db490-d61c-443f-a65b-d21fe96a405b
Diffstat (limited to 'contrib')
| -rw-r--r-- | contrib/realtime/mysql/iaxfriends.sql | 2 | ||||
| -rw-r--r-- | contrib/realtime/mysql/meetme.sql | 11 | ||||
| -rw-r--r-- | contrib/realtime/mysql/sipfriends.sql | 2 | ||||
| -rw-r--r-- | contrib/realtime/postgresql/realtime.sql | 2 |
4 files changed, 13 insertions, 4 deletions
diff --git a/contrib/realtime/mysql/iaxfriends.sql b/contrib/realtime/mysql/iaxfriends.sql index a83d8ce46..3b3bbb3c7 100644 --- a/contrib/realtime/mysql/iaxfriends.sql +++ b/contrib/realtime/mysql/iaxfriends.sql @@ -12,7 +12,7 @@ CREATE TABLE `iaxfriends` ( `context` varchar(40) NULL, `regcontext` varchar(40) NULL, `host` varchar(40) NULL default 'dynamic', - `ipaddr` varchar(20) NULL, -- Must be updateable by Asterisk user + `ipaddr` varchar(40) NULL, -- Must be updateable by Asterisk user `port` int(5) NULL, -- Must be updateable by Asterisk user `defaultip` varchar(20) NULL, `sourceaddress` varchar(20) NULL, diff --git a/contrib/realtime/mysql/meetme.sql b/contrib/realtime/mysql/meetme.sql index 19c4ed745..7e79a8c74 100644 --- a/contrib/realtime/mysql/meetme.sql +++ b/contrib/realtime/mysql/meetme.sql @@ -3,10 +3,19 @@ -- CREATE TABLE meetme ( + bookid int(11) auto_increment, confno char(80) DEFAULT '0' NOT NULL, + starttime datetime default '1900-01-01 12:00:00', + endtime datetime default '2038-01-01 12:00:00', pin char(20) NULL, adminpin char(20) NULL, + opts char(20) NULL, + adminopts char(20) NULL, + recordingfilename char(80) NULL, + recordingformat char(10) NULL, + maxusers int(11) NULL, members integer DEFAULT 0 NOT NULL, - PRIMARY KEY (confno) + index confno (confno,starttime,endtime) + PRIMARY KEY (bookid), ); diff --git a/contrib/realtime/mysql/sipfriends.sql b/contrib/realtime/mysql/sipfriends.sql index a9c94e8dc..c7f10e934 100644 --- a/contrib/realtime/mysql/sipfriends.sql +++ b/contrib/realtime/mysql/sipfriends.sql @@ -35,7 +35,7 @@ CREATE TABLE `sipfriends` ( `maxcallbitrate` varchar(15), `host` varchar(40) default 'dynamic', `outboundproxy` varchar(40), - `ipaddr` varchar(20) NOT NULL default '', + `ipaddr` varchar(40) NOT NULL default '', `defaultip` varchar(20), `port` int(6) NOT NULL default '0', `fullcontact` varchar(40), diff --git a/contrib/realtime/postgresql/realtime.sql b/contrib/realtime/postgresql/realtime.sql index 7eab14136..74b895738 100644 --- a/contrib/realtime/postgresql/realtime.sql +++ b/contrib/realtime/postgresql/realtime.sql @@ -65,7 +65,7 @@ disallow character varying(100) DEFAULT 'all', allow character varying(100) DEFAULT 'g729;ilbc;gsm;ulaw;alaw', musiconhold character varying(100), regseconds bigint DEFAULT 0::bigint NOT NULL, -ipaddr character varying(15) DEFAULT '' NOT NULL, +ipaddr character varying(40) DEFAULT '' NOT NULL, regexten character varying(80) DEFAULT '' NOT NULL, cancallforward character varying(3) DEFAULT 'yes', lastms integer DEFAULT -1 NOT NULL |