From e61464a580ce78c42f9d0a09b64c1a733e125800 Mon Sep 17 00:00:00 2001
From: tilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b>
Date: Fri, 10 Apr 2009 17:30:46 +0000
Subject: 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.1@187767 f38db490-d61c-443f-a65b-d21fe96a405b
---
 contrib/scripts/realtime_pgsql.sql | 3 ++-
 contrib/scripts/sip-friends.sql    | 1 +
 2 files changed, 3 insertions(+), 1 deletion(-)

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