diff options
author | tilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b> | 2009-04-10 17:28:46 +0000 |
---|---|---|
committer | tilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b> | 2009-04-10 17:28:46 +0000 |
commit | e26ac1629213d4b6d03917ec59cd47bb0115fb67 (patch) | |
tree | ca2c93943e3ee3a2948eba7293c9f820b0375dc3 /contrib | |
parent | 4c1a9e8396d1ee084ab606b733e4e0db695a88d5 (diff) |
Add lastms column to the contributed table designs
git-svn-id: http://svn.digium.com/svn/asterisk/branches/1.4@187763 f38db490-d61c-443f-a65b-d21fe96a405b
Diffstat (limited to 'contrib')
-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 319c9e108..7eab14136 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 d76db7f93..a9c94e8dc 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), |