install.php

<?php 
include 'includes/library.php';
$pdo = connectDB();
$query = "show tables like 'users'";
$stmt = $pdo->query($query);
if($stmt->rowCount() == 0){
    $query = "CREATE TABLE `users` (
        `id` int(11) NOT NULL AUTO_INCREMENT,
        `username` varchar(255) NOT NULL,
        `password` varchar(255) NOT NULL,
        `email` varchar(255) NOT NULL,
        PRIMARY KEY (id)
        );";
    $stmt = $pdo->query($query);
    $query = "CREATE TABLE `lists` (
        `id` int(11) NOT NULL AUTO_INCREMENT,
        `listname` text NOT NULL,
        `ownerId` int NOT NULL,
        `public` boolean NOT NULL,
        `disable` boolean NOT NULL,
        `featureImage` varchar(255),
        `password` varchar(255),
		`views` int NOT NULL,
        `expiryDate` datetime,
        `content` longtext NOT NULL,
        PRIMARY KEY(id),
        FOREIGN KEY(owner_id) REFERENCES users(id)
        );";
    $stmt = $pdo->query($query);
    if($stmt){
        alert("Database created successfully");
    }
    else{
        alert("Install failed");
    }
}else{
    alert("Database already exists");
}
echo("<script>location.href='/'</script>");

function alert($var){
	echo '<script>alert("'.$var.'")</script>';
}
?>