<?php
$servername = "localhost";
$username = "USER_NAME";
$password = "PASSWORD";
$dbname = "DN_NAME";


// Create connection
$conn = new mysqli($servername, $username, $password);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Create database
$sql = "CREATE DATABASE MY_DB";
if ($conn->query($sql) === TRUE) {

    echo "1. Database created successfully <br/>";
    $conn->select_db("MY_DB");


    $sql_users = "CREATE TABLE USERS (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(30) NOT NULL,
    email VARCHAR(40) NOT NULL,
    password VARCHAR(36),
    role_id INT (6) NOT NULL
    )";


    if ($conn->query($sql_users) === TRUE) {
        echo "2. Table USERS created successfully <br/>";
    } else {
        echo "Error creating table: " . $conn->error;
    }

    $sql_role = "CREATE TABLE ROLE (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(30) NOT NULL
    )";

    if ($conn->query($sql_role) === TRUE) {
        echo "3. Table ROLE created successfully <br/>";
    } else {
        echo "Error creating table: " . $conn->error;
    }
} else {
    echo "Error creating database: " . $conn->error;
}

$conn->close();