diff options
author | Tilghman Lesher <tilghman@meg.abyt.es> | 2009-04-10 17:29:34 +0000 |
---|---|---|
committer | Tilghman Lesher <tilghman@meg.abyt.es> | 2009-04-10 17:29:34 +0000 |
commit | 92b20aa05311630558dc912de6dfd4df2397654b (patch) | |
tree | 34b5b46f7ce9eb75c1ec59e9210e29d04a9eb364 /contrib/scripts | |
parent | f6de93c5dfeb7d54ded98a3f364dc54703ccc06c (diff) |
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
Diffstat (limited to 'contrib/scripts')
-rw-r--r-- | contrib/scripts/realtime_pgsql.sql | 3 | ||||
-rw-r--r-- | contrib/scripts/sip-friends.sql | 1 |
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), |