Module: sip-router Branch: master Commit: 00634dc0869c2e65a6626b8ad2408cd9a2b3598a URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=00634dc0...
Author: Juha Heinanen jh@tutpro.com Committer: Juha Heinanen jh@tutpro.com 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>