<?php
include('dbmaster.php');

$mysqlpass = ran();

$createUser = mysqli_query($dbmaster, "CREATE USER 'savoy'@'localhost' IDENTIFIED VIA mysql_native_password USING '" . $mysqlpass . "'");
$createGrant = mysqli_query($dbmaster, "GRANT USAGE ON *.* TO 'savoy'@'localhost' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0");
$createDb1 = mysqli_query($dbmaster, "CREATE DATABASE IF NOT EXISTS `savoy`;GRANT ALL PRIVILEGES ON `savoy`.* TO 'savoy'@'localhost'");
$createDb2 = mysqli_query($dbmaster, "CREATE DATABASE IF NOT EXISTS `events`;GRANT ALL PRIVILEGES ON `savoy`.* TO 'savoy'@'localhost'");

$createLoginTabelle = mysqli_query($dbmaster,"CREATE TABLE `login`. ( `id` INT NOT NULL , `loginname` TEXT NULL DEFAULT NULL , `loginpwd` TEXT NULL DEFAULT NULL , `pwchanged` BOOLEAN NOT NULL DEFAULT FALSE ) ENGINE = InnoDB");
$createMaTabelle = mysqli_query($dbmaster,"CREATE TABLE `ma`. ( `id` INT NOT NULL , `vorname` TEXT NULL DEFAULT NULL , `nachname` TEXT NULL DEFAULT NULL, `aktstunden` INT NOT NULL, `maxstunden` INT NOT NULL, `laststunden` INT NOT NULL, `gruppe` INT NOT NULL ) ENGINE = InnoDB");
$createEventTabelle = mysqli_query($dbmaster,"CREATE TABLE `events`. ( `date` TEXT NULL DEFAULT NULL , `name` TEXT NULL DEFAULT NULL, `besch` TEXT NULL DEFAULT NULL ) ENGINE = InnoDB");

$loginpw = ran();
$pwHashLogin = password_hash($loginpw, PASSWORD_DEFAULT);

$addLoginList = mysqli_query($dbmaster, "INSERT INTO `login` (`id`, `loginname`, `loginpwd`) VALUES ('1', 'admin', '" . $pwHashLogin . "')");
$addMaList = mysqli_query($dbmaster, "INSERT INTO `ma` (`id`, `vorname`, `nachname`, `aktstunden`, `maxstunden`, `laststunden`, `gruppe`) VALUES ('1', 'Admin', 'Admin', '0', '1', '0', '2')");

echo 'Erstellen Abgeschlossen!<br>Mysql User: savoy<br>Mysql Pass: ' . $mysqlpass . '<br><br><br>Login User: Admin<br>Login Pass: ' . $loginpw . '<br><br>Daten gut Aufbewahren! Diese können später nicht erneut angezeigt werden!!!';
function ran($length = 10) {
    $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
    $charactersLength = strlen($characters);
    $randomString = '';
    for ($i = 0; $i < $length; $i++) {
        $randomString .= $characters[rand(0, $charactersLength - 1)];
    }
    return $randomString;
}
?>