From 92b20aa05311630558dc912de6dfd4df2397654b Mon Sep 17 00:00:00 2001 From: Tilghman Lesher Date: Fri, 10 Apr 2009 17:29:34 +0000 Subject: 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: https://origsvn.digium.com/svn/asterisk/trunk@187764 65c4cc65-6c06-0410-ace0-fbb531ad65f3 --- contrib/scripts/realtime_pgsql.sql | 3 ++- contrib/scripts/sip-friends.sql | 1 + 2 files changed, 3 insertions(+), 1 deletion(-) (limited to 'contrib') 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), -- cgit v1.2.3