aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-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),