#!/bin/bash

LINUX_VERSION=$(lsb_release -s -c)
CUSTOM_CNF_DIR="/etc/mysql/conf.d"
BROWN='\033[33m'
NC='\033[0m'

echo -e "${BROWN}Внимание! Установка может занимать до 20 минут!${NC}"
echo "deb http://repo.mysql.com/apt/ubuntu/ bionic mysql-8.0" > /etc/apt/sources.list.d/mysql.list
echo "" > /etc/apt/preferences.d/mysql
curl http://downloads.artix.su/static/downloads/mysql/mysql5_to_mysql8/mysql_pubkey.asc -o /tmp/mysql_pubkey.asc
sudo apt-key add /tmp/mysql_pubkey.asc
apt-get update
apt-get install mysql-server

if [ "$LINUX_VERSION" = "bionic" ]; then
    CUSTOM_CNF_DIR="/etc/mysql/override.conf.d"
    if ! grep -q "!includedir $CUSTOM_CNF_DIR/" "/etc/mysql/mysql.cnf"; then
	echo !includedir $CUSTOM_CNF_DIR/ >> /etc/mysql/mysql.cnf
    fi
fi

if [[ $LINUX_VERSION == "bionic" && $(dpkg-query --show -f='${Version}' mysql-server) =~ ^8.0 ]]; then
cat >> /etc/mysql/override.conf.d/CS40_mysql8_settings.cnf << EOF
[mysqld]
explicit_defaults_for_timestamp = 0
EOF
fi

systemctl restart mysql