aboutsummaryrefslogtreecommitdiffstats
path: root/contrib
diff options
context:
space:
mode:
authortilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b>2009-04-10 17:30:11 +0000
committertilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b>2009-04-10 17:30:11 +0000
commita13f5a95692d26887f4e496de7d94e24e6bf0fec (patch)
tree5f15c6222efb5275d845270671d170dd634f865c /contrib
parent7c0dcc7736510d24c3b6078e625f62f06e18e9d9 (diff)
Merged revisions 187764 via svnmerge from
https://origsvn.digium.com/svn/asterisk/trunk ................ r187764 | tilghman | 2009-04-10 12:29:34 -0500 (Fri, 10 Apr 2009) | 9 lines Merged revisions 187763 via svnmerge from https://origsvn.digium.com/svn/asterisk/branches/1.4 ........ r187763 | tilghman | 2009-04-10 12:28:46 -0500 (Fri, 10 Apr 2009) | 2 lines Add lastms column to the contributed table designs ........ ................ git-svn-id: http://svn.digium.com/svn/asterisk/branches/1.6.0@187765 f38db490-d61c-443f-a65b-d21fe96a405b
Diffstat (limited to 'contrib')
-rw-r--r--contrib/scripts/realtime_pgsql.sql3
-rw-r--r--contrib/scripts/sip-friends.sql1
2 files changed, 3 insertions, 1 deletions
diff --git a/contrib/scripts/realtime_pgsql.sql b/contrib/scripts/realtime_pgsql.sql
index 760464b1f..5539bbeb8 100644
--- a/contrib/scripts/realtime_pgsql.sql
+++ b/contrib/scripts/realtime_pgsql.sql
@@ -67,7 +67,8 @@ musiconhold character varying(100),
regseconds bigint DEFAULT 0::bigint NOT NULL,
ipaddr character varying(15) DEFAULT '' NOT NULL,
regexten character varying(80) DEFAULT '' NOT NULL,
-cancallforward character varying(3) DEFAULT 'yes'
+cancallforward character varying(3) DEFAULT 'yes',
+lastms integer DEFAULT -1 NOT NULL
);
drop table voicemail_users;
diff --git a/contrib/scripts/sip-friends.sql b/contrib/scripts/sip-friends.sql
index e9d85a3db..9110018af 100644
--- a/contrib/scripts/sip-friends.sql
+++ b/contrib/scripts/sip-friends.sql
@@ -47,6 +47,7 @@ CREATE TABLE `sipfriends` (
`rtptimeout` varchar(15),
`rtpholdtimeout` varchar(15),
`rtpkeepalive` varchar(15),
+ `lastms` int(11) NOT NULL default '-1',
`setvar` varchar(200),
PRIMARY KEY (`name`),
INDEX host (host, port),