<?php
$servername = "localhost";
$username = "root";
$password = "";

// 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 IF NOT EXISTS `loja` CHARSET = UTF8 COLLATE = utf8_general_ci;";

if ($conn->query($sql) === TRUE) {
    echo 'Database criada.';
} else {
    echo "Error creating database: " . $conn->error;
}

$db_selected = mysqli_select_db($conn, "loja");
if (!$db_selected)
    {
    die ('Can\'t use database : ' . mysqli_error());
}
else
{
    $sql2 = "CREATE TABLE IF NOT EXISTS `tb_custumer` (
                               `id` INT(11) NOT NULL AUTO_INCREMENT,
                               `idext` VARCHAR(20) NULL DEFAULT NULL,
                               `custumer` VARCHAR(50) NOT NULL,
                               `cpf` VARCHAR(11) NULL DEFAULT NULL,
                               `birthdate` DATE NULL DEFAULT NULL,
                               `voter` VARCHAR(20) NULL DEFAULT NULL,
                               `cellphone` VARCHAR(15) NULL DEFAULT NULL,
                               `postalcode` VARCHAR(8) NULL DEFAULT NULL,
                               `address` VARCHAR(50) NULL DEFAULT NULL,
                               `district` VARCHAR(50) NULL DEFAULT NULL,
                               `city` VARCHAR(50) NULL DEFAULT NULL,
                               `state` VARCHAR(50) NULL DEFAULT NULL,
                               PRIMARY KEY (`id`)
)

COLLATE='utf8_general_ci'
    ENGINE=InnoDB
    AUTO_INCREMENT=118";

    $conn->query($sql2);
    echo '<br> Tabelas criadas';
}






$conn->close();
?>