{
my $db = $dl{'DbName'} || 'dl';
my $user = $dl{'DbUser'} || 'dl';
my $pass = $dl{'DbPassword'} || 'secret';

my $dbstruct = `rpm -ql dl | grep mysql.sql`;

$OUT .= <<"END";
#! /bin/sh
if [ ! -d /var/lib/mysql/$db ]; then
        /usr/bin/mariadb -e 'create database $db'
        /usr/bin/mariadb $db < $dbstruct
        /usr/bin/mariadb -e "create user $user\@localhost identified by '$pass'"
        /usr/bin/mariadb -e "grant all privileges on $db.* to $user\@localhost identified by '$pass'"
else
        su -s /bin/bash - www -c "cd /usr/share/dl/include/scripts && /usr/bin/php74 ./dbupgrade.php"
fi

/usr/bin/mariadb <<EOF
use $db;
INSERT INTO user (\\`name\\`,\\`role_id\\`) VALUES ('admin', '1') ON DUPLICATE KEY update role_id='1';

EOF
END
}
