{

my $dbname = $freepbx{'DbName'} || 'freepbxdb';
my $cdrdbname = $freepbx{'CdrDbName'} || 'asteriskcdrdb';
my $dbuser = $freepbx{'DbUser'} || 'freepbxuser';
my $dbpass = $freepbx{'DbPassword'} || 'secret';
my $cdrdbpass = $freepbx{'CdrDbPassword'} || 'secret';
my $ManagerPassword = $freepbx{'ManagerPassword'} || 'secret';

$OUT .= << "HERE";
#! /bin/sh

if [ ! -d /var/lib/mysql/$dbname ]; then
    mysql -e "create database $dbname CHARACTER SET utf8 COLLATE utf8_unicode_ci  ;" 

    if [ -e /usr/share/freepbx/sql/asterisk.sql ]; then
        mysql $dbname < /usr/share/freepbx/sql/asterisk.sql
    else
        echo "Error: file /usr/share/freepbx/sql/asterisk.sql doesn't exists"
        exit 1
    fi
fi

if [ ! -d /var/lib/mysql/$cdrdbname ]; then
    mysql -e "create database $cdrdbname CHARACTER SET utf8 COLLATE utf8_unicode_ci  ;"
    if [ -e /usr/share/freepbx/sources/freepbx/installlib/SQL/cdr.sql ]; then
        mysql $cdrdbname < /usr/share/freepbx/sources/freepbx/installlib/SQL/cdr.sql
    else
        echo "Error: file /usr/share/freepbx/sources/freepbx/installlib/SQL/cdr.sql doesn't exists"
        exit 1
    fi
fi

/usr/bin/mysql $dbname -e 'INSERT INTO `admin` (`variable`, `value`) VALUES ("email", "admin\@$DomainName") ON DUPLICATE KEY UPDATE `value` = "admin\@$DomainName";'
/usr/bin/mysql $dbname -e 'INSERT INTO `ampusers` (`username`, `password_sha1`, `extension_low`, `extension_high`, `deptname`, `sections`) VALUES
("admin", sha1("$ManagerPassword"), "", "", "", 0x2a) ON DUPLICATE KEY UPDATE `password_sha1` = sha1("$ManagerPassword");'

/usr/bin/mysql <<EOF
USE mysql;

GRANT ALL PRIVILEGES ON  ${dbname} TO '$dbuser'\@'localhost' identified by '$dbpass';
GRANT ALL PRIVILEGES ON  ${cdrdbname}  TO '$dbuser'\@'localhost' identified by '$dbpass';

FLUSH PRIVILEGES;

EOF


HERE
}

