<?php
function createdatabase() {
$servername = "localhost";
$username = "root";
$password = "";

// Create connection
$conn = mysqli_connect($servername, $username, $password);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

// Create database
$sql = "CREATE DATABASE csc8417test";
if (mysqli_query($conn, $sql)) {
    echo "Database created successfully";
} else {
    echo "Error creating database: " . mysqli_error($conn);
}

mysqli_close($conn);
}

function createcharactor() {
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "csc8417test";

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

// sql to create table


$sql = "CREATE TABLE IF NOT EXISTS `charactor` (
  `charactor_name` varchar(20) NOT NULL,
  `vault_number` int(3) NOT NULL,
  `history` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1";

if ($conn->query($sql) === TRUE) {
    echo "Table charactor created successfully";
} else {
    echo "Error creating charactor table: " . $conn->error;
}

$conn->close();

}

function creategames() {
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "csc8417test";

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

// sql to create table


$sql = "CREATE TABLE IF NOT EXISTS `games` (
  `charactor_name` varchar(20) NOT NULL,
  `vault_number` int(3) NOT NULL,
  `group_name` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;";

if ($conn->query($sql) === TRUE) {
    echo "Table games created successfully";
} else {
    echo "Error creating games table: " . $conn->error;
}

$conn->close();

}

function creategroups() {
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "csc8417test";

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

// sql to create table


$sql = "CREATE TABLE IF NOT EXISTS `groups` (
  `group_name` varchar(20) NOT NULL,
  `history` text NOT NULL,
  `vault_number` int(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;";

if ($conn->query($sql) === TRUE) {
    echo "Table groups created successfully";
} else {
    echo "Error creating groups table: " . $conn->error;
}

$conn->close();

}

function createhistory() {
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "csc8417test";

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

// sql to create table


$sql = "CREATE TABLE IF NOT EXISTS `history` (
  `History` text NOT NULL,
  `date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;";

if ($conn->query($sql) === TRUE) {
    echo "Table history created successfully";
} else {
    echo "Error creating history table: " . $conn->error;
}

$conn->close();

}

function createlocations() {
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "csc8417test";

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

// sql to create table


$sql = "CREATE TABLE IF NOT EXISTS `locations` (
  `location_name` varchar(20) NOT NULL,
  `game` varchar(50) NOT NULL,
  `history` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;";

if ($conn->query($sql) === TRUE) {
    echo "Table locations created successfully";
} else {
    echo "Error creating locations table: " . $conn->error;
}

$conn->close();

}

function createusers() {
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "csc8417test";

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

// sql to create table


$sql = "CREATE TABLE IF NOT EXISTS `users` (
  `username` varchar(20) NOT NULL,
  `firstname` varchar(50) NOT NULL,
  `lastname` varchar(50) NOT NULL,
  `password` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;";



if ($conn->query($sql) === TRUE) {
    echo "Table users created successfully";
} else {
    echo "Error creating users table: " . $conn->error;
}

$conn->close();

}

function createvault() {
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "csc8417test";

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

// sql to create table


$sql = "CREATE TABLE IF NOT EXISTS `vault` (
  `vault_number` int(3) NOT NULL,
  `game` varchar(50) NOT NULL,
  `history` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;";

if ($conn->query($sql) === TRUE) {
    echo "Table vault created successfully";
} else {
    echo "Error creating vault table: " . $conn->error;
}

$conn->close();

}

function usersdata() {
    $servername = "localhost";
$username = "root";
$password = "";
$dbname = "csc8417test";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$sql = " INSERT INTO `users` (`username`, `firstname`, `lastname`, `password`) VALUES
('test', 'test', 'test', 'test'),
('tim', 'tim', 'tim', 'tim');";

if ($conn->query($sql) === TRUE) {
    echo "users data created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();

}

function altercharactortable() {
    $servername = "localhost";
$username = "root";
$password = "";
$dbname = "csc8417test";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$sql = " ALTER TABLE `charactor`
  ADD PRIMARY KEY (`charactor_name`);";

if ($conn->query($sql) === TRUE) {
    echo "charactor primary key created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();

}

function altergamestable() {
    $servername = "localhost";
$username = "root";
$password = "";
$dbname = "csc8417test";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$sql = " ALTER TABLE `games`
  ADD PRIMARY KEY (`charactor_name`),
  ADD KEY `vault_number` (`vault_number`),
  ADD KEY `group_name` (`group_name`);";

if ($conn->query($sql) === TRUE) {
    echo "games primary key created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();

}

function altergroupstable() {
    $servername = "localhost";
$username = "root";
$password = "";
$dbname = "csc8417test";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$sql = "ALTER TABLE `groups`
  ADD PRIMARY KEY (`group_name`);";

if ($conn->query($sql) === TRUE) {
    echo "groups primary key created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();

}

function alterlocationstable() {
    $servername = "localhost";
$username = "root";
$password = "";
$dbname = "csc8417test";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$sql = "ALTER TABLE `locations`
  ADD PRIMARY KEY (`location_name`);";

if ($conn->query($sql) === TRUE) {
    echo "locations primary key created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();

}

function alteruserstable() {
    $servername = "localhost";
$username = "root";
$password = "";
$dbname = "csc8417test";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$sql = "ALTER TABLE `users`
  ADD PRIMARY KEY (`username`);";

if ($conn->query($sql) === TRUE) {
    echo "users primary key created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();

}

function altervaulttable() {
    $servername = "localhost";
$username = "root";
$password = "";
$dbname = "csc8417test";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$sql = "ALTER TABLE `vault`
  ADD PRIMARY KEY (`vault_number`);";

if ($conn->query($sql) === TRUE) {
    echo "vault primary key created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();

}

function altergametable() {
    $servername = "localhost";
$username = "root";
$password = "";
$dbname = "csc8417test";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$sql = "ALTER TABLE `games`
  ADD CONSTRAINT `games_ibfk_1` FOREIGN KEY (`charactor_name`) REFERENCES `charactor` (`charactor_name`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `games_ibfk_2` FOREIGN KEY (`vault_number`) REFERENCES `vault` (`vault_number`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `games_ibfk_3` FOREIGN KEY (`group_name`) REFERENCES `groups` (`group_name`) ON DELETE CASCADE ON UPDATE CASCADE;";

if ($conn->query($sql) === TRUE) {
    echo "game table m2m successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();

}
?>