{
my $db = ${'zabbix-server'}{'DbName'} || 'zabbix';
my $user = ${'zabbix-server'}{'DbUser'} || 'zabbix';
my $pass = ${'zabbix-server'}{'DbPassword'} || 'secret';

my $schema = `rpm -qd zabbix-server-mysql | grep schema | grep mysql`;
$schema = `rpm -qd zabbix-server | grep schema | grep mysql` if $schema eq '';
my $data = `rpm -qd zabbix-server-mysql | grep data.sql`;
$data = `rpm -qd zabbix-server| grep mysql | grep data.sql` if $data eq '';
my $images = `rpm -qd zabbix-server-mysql | grep images_mysql`;
$images = `rpm -qd zabbix-server | grep mysql |grep images` if $images eq '';


$OUT .= <<"END";
#! /bin/sh
if [ -d /var/lib/mysql/$db ]; then
	for P in \$(rpm -qd zabbix-server | grep dbpatch | grep mysql); do
		/usr/bin/mysql $db < \$P
	done
else
	/usr/bin/mysqladmin create $db
	/usr/bin/mysql $db < $schema
	/usr/bin/mysql $db < $data
	/usr/bin/mysql $db < $images
fi

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

REPLACE INTO user (
                     host,
                     user,
                     password)
            VALUES (
                     'localhost',
                     '${'zabbix-server'}{DbUser}',
                     PASSWORD ('${'zabbix-server'}{DbPassword}'));


REPLACE INTO db (
                   host,
                   db,
                   user,
                   select_priv, insert_priv, update_priv, delete_priv,
                   create_priv, alter_priv, index_priv, drop_priv, create_tmp_table_priv,
                   grant_priv, lock_tables_priv, references_priv) 
          VALUES (
                   'localhost',
                   '${'zabbix-server'}{DbName}',
                   '${'zabbix-server'}{DbUser}',
                   'Y', 'Y', 'Y', 'Y',
                   'Y', 'Y', 'Y', 'Y', 'Y',
                   'N', 'Y', 'Y');

FLUSH PRIVILEGES;

USE ${'zabbix-server'}{DbName};

INSERT IGNORE INTO media_type (
		mediatypeid,
		type, description,
		smtp_server,
		smtp_helo,
		smtp_email,
		exec_path,
		gsm_modem,
		username,
		passwd) 
	VALUES(
		4,
		1,
		'xmpp',
		'',
		'',
		'',
		'sendxmpp',
		'',
		'',
		'');

EOF
END
}
