<?php
//Initalize server credential varables
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "infx2070";

//create connection
$conn = new mysqli($servername, $username, $password, $dbname);

//check for connection status
if($conn->connect_error){
  die("connection failed: " . $conn->connect_error . "<br>");
} else {
  echo "Connection successful! <br>";
}


//create sql table Posts
$sql = "CREATE TABLE Posts (
P_id int UNSIGNED AUTO_INCREMENT,
first_name VARCHAR(30) NOT NULL,
last_name VARCHAR(30) NOT NULL,
PRIMARY KEY (P_id)
)";

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

//create sql table Comments
$sql = "CREATE TABLE Comments (
C_id int UNSIGNED AUTO_INCREMENT,
first_name VARCHAR(30) NOT NULL,
last_name VARCHAR(30) NOT NULL,
Comment VARCHAR(255),
P_id int UNSIGNED,
FOREIGN KEY (P_id) REFERENCES Posts(P_id),
PRIMARY KEY (C_id)
)";

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

//Close connection upon completion
$conn->close();
echo "Connection closed <br>";
?>