--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/debian/littlebird-tc-sql.postinst	Wed Aug 31 16:51:37 2011 +0200
@@ -0,0 +1,72 @@
+#!/bin/sh
+# postinst script for littlebird
+#
+# see: dh_installdeb(1)
+set -e
+. /usr/share/debconf/confmodule
+
+# summary of how this script can be called:
+#        * <postinst> `configure' <most-recently-configured-version>
+#        * <old-postinst> `abort-upgrade' <new version>
+#        * <conflictor's-postinst> `abort-remove' `in-favour' <package>
+#          <new-version>
+#        * <postinst> `abort-remove'
+#        * <deconfigured's-postinst> `abort-deconfigure' `in-favour'
+#          <failed-install-package> <version> `removing'
+#          <conflicting-package> <version>
+# for details, see http://www.debian.org/doc/debian-policy/ or
+# the debian-policy package
+
+
+case "$1" in
+    configure)
+	db_get littlebird-tc/db/adminuser && adminuser="$RET" || true
+	db_get littlebird-tc/db/adminpass && adminpass="$RET" || true
+	db_get littlebird-tc/db/user && user="$RET" || true
+	db_get littlebird-tc/db/pass && pass="$RET" || true
+	db_get littlebird-tc/db/host && host="$RET" || true
+	db_get littlebird-tc/db/name && name="$RET" || true
+
+#	cat <<EOF
+#$@
+#adminuser/pass: $adminuser/$adminpass
+#user/pass: $user/$pass
+#db@host: $name@$host
+#EOF
+	# only init the db if there is no previous version
+	if test -z "$2" && test -n "$adminpass"; then
+
+	    if test "$host" = "localhost"; then client="localhost"
+	    else client="%"
+	    fi
+
+	    mysql -h"$host" -u"$adminuser" -p"$adminpass" <<EOF
+		CREATE DATABASE IF NOT EXISTS $name;
+		GRANT ALL ON $name.* TO '$user'@'$client' IDENTIFIED BY '$pass';
+		FLUSH PRIVILEGES;
+EOF
+	    (	set -e
+		cd /usr/share/littlebird/tc-sql
+		./install_test_iteration_2011-06.sh \
+		    "$host" "$name" \
+		    "$adminuser" "$adminpass" \
+		    "$user" "$pass"
+	    )
+	fi
+    ;;
+
+    abort-upgrade|abort-remove|abort-deconfigure)
+    ;;
+
+    *)
+        echo "postinst called with unknown argument \`$1'" >&2
+        exit 1
+    ;;
+esac
+
+# dh_installdeb will replace this with shell code automatically
+# generated by other debhelper scripts.
+
+#DEBHELPER#
+
+exit 0