[sr-dev] git:master: * modules/lcr: gw table db schema fixes

Module: sip-router Branch: master Commit: 00634dc0869c2e65a6626b8ad2408cd9a2b3598a URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=00634dc… Author: Juha Heinanen &lt;jh(a)tutpro.com&gt; Committer: Juha Heinanen &lt;jh(a)tutpro.com&gt; Date: Wed Sep 30 16:33:05 2009 +0300 * modules/lcr: gw table db schema fixes - Added missing defunct column. - Replaced index lcr_id_idx with index lcr_id_gw_name_idx. --- lib/srdb1/schema/gw.xml | 12 +++++++++++- 1 files changed, 11 insertions(+), 1 deletions(-) diff --git a/lib/srdb1/schema/gw.xml b/lib/srdb1/schema/gw.xml index e73d61b..842c9c8 100644 --- a/lib/srdb1/schema/gw.xml +++ b/lib/srdb1/schema/gw.xml @@ -113,9 +113,19 @@ <description>Gateway specific flags</description> </column> + <column> + <name>defunct</name> + <type>unsigned int</type> + <null/> + <default><null/></default> + <description>If not null, contains unix timestamp telling when gw becomes operational.</description> + </column> + <index> - <name>lcr_id_idx</name> + <name>lcr_id_gw_name_idx</name> <colref linkend="lcr_id"/> + <colref linkend="gw_name"/> + <unique/> </index> </table>