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

[Juha Heinanen]

Module: sip-router
Branch: master
Commit: 00634dc0869c2e65a6626b8ad2408cd9a2b3598a
URL:    http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=00634dc0869c2e65a6626b8ad2408cd9a2b3598a

Author: Juha Heinanen <jh at tutpro.com>
Committer: Juha Heinanen <jh at 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>