<?php
// PHP script to create MySQL table used for this project
// Called From: Command line

// https://www.w3schools.com/php/php_mysql_create_table.asp
$servername = "csmysql.snc.edu";
$username = "mohrjv";
$password = "LostDogs2019";
$dbname = "LostDogs2019";

// 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
// decimal = 8 digits with 5 people after the period
$sql = "CREATE TABLE dogs (
    Breed char(30),
    Missing bool,
    Picture char(100),
    Email char(40),
	Latitude decimal(8,5),
    Longitude decimal(8,5),
	Date date,
	Color char(1),
	Age tinyint,
	Size char(1),
	Note char(41)
)";

if ($conn->query($sql) === TRUE) {
    echo "Table created successfully";
} else {
    echo "Error creating table: " . $conn->error;
}

$conn->close();
?>