Create a schema on upgrade or install

diff --git a/debian/changelog b/debian/changelog
index 9fe552c..a556228 100644 (file)
--- a/debian/changelog
+++ b/debian/changelog
@@ -1,3 +1,9 @@
+moonshot-trust-router (1.4-3) unstable; urgency=medium
+
+  * Create a schema on upgrade or install
+
+ -- Sam Hartman <hartmans@debian.org>  Tue, 30 Sep 2014 15:21:43 -0400
+
 moonshot-trust-router (1.4-2) unstable; urgency=medium
 
   * Update to fix bug in init script, Thanks Stefan

diff --git a/debian/moonshot-trust-router.postinst b/debian/moonshot-trust-router.postinst
index 44f80fb..2afb675 100644 (file)
--- a/debian/moonshot-trust-router.postinst
+++ b/debian/moonshot-trust-router.postinst
@@ -20,7 +20,7 @@ case "$1" in
         if dpkg --compare-versions "$2" lt 1.2-2; then
            adduser --system --home /var/lib/trust_router --group --disabled-login trustrouter
            fi
-    
+       su -p -c "/usr/bin/sqlite3 </usr/share/trust_router/schema.sql /var/lib/trust_router/keys" trustrouter ||true
     ;;
 
     abort-upgrade|abort-remove|abort-deconfigure)