#!/bin/bash
### Copyright 1999-2017. Plesk International GmbH. All rights reserved.

if [ -n "$PLESK_INSTALLER_DEBUG" -o -n "$PLESK_INSTALLER_VERBOSE" ]; then
	set -x;
fi

prog="`basename $0`"
tmp_d="/usr/local/psa/var"
mu_flag="$tmp_d/${prog%.sh}.flag"

[ ! -f "$mu_flag" ] || exit 0

#####
PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/sbin:/usr/bin:/bin:/usr/local/psa/bin:/opt/psa/bin"
umask 022

plesk_db() {
    MYSQL_PWD=$(cat /etc/psa/.psa.shadow) mysql -u admin -D psa -N -Br -e "$1"
}

have_column=$(plesk_db "SHOW COLUMNS FROM dns_zone LIKE 'rnameType'")

if [ -n "$have_column" ]; then
	echo "Column rnameType already present"
	touch "$mu_flag"
	exit 0
fi

plesk_db "alter table dns_zone add column rnameType enum('owner','domain','external') not null default 'owner'" && touch "$mu_flag"