File mkbennouserdb of Package benno-web

#!/bin/bash
# Anlegen und Aktualisieren einer Benno-Userdatenbank
# (C) 2020 Stefan Schaefer - FSP Computer & Netzwerke

# Variablen
USER_DB=bennoweb.sqlite
ETC_DIR=/etc/benno-web
VAR_DIR=/var/lib/benno-web
SERVER_CONFIG=/etc/benno-web/benno.conf
SERVER_USER=benno
SERVER_GROUP=benno
WWW_USER=wwwrun
WWW_GROUP=www


# DB anlegen bzw. aktualisieren
set +e
echo ""|sqlite /var/lib/benno-web/bennoweb.sqlite 2>/dev/null
dbretval=$?
if [ -f "$VAR_DIR/$USER_DB" ] && [ $dbretval = 0 ];then
    # convert database from slite2 to sqlite3
    mv "$VAR_DIR/$USER_DB" "$VAR_DIR/${USER_DB}2"
    echo .dump| sqlite "$VAR_DIR/${USER_DB}2" | sqlite3 "$VAR_DIR/$USER_DB"
fi
sqlite3 "$VAR_DIR/$USER_DB" < /usr/share/benno-web/db-create.sql 2>/dev/null
#
sqlite3 "$VAR_DIR/$USER_DB" < /usr/share/benno-web/db-update_2.0.1.sql 2>/dev/null
#
perl /usr/share/benno-web/db-update_2.8.4.pl 2>/dev/null
#
set -e