setTables.php

<?php
    include './includes/dbconfig.php';
    $errors=array();
    
    //Table structure for table `list_for_the_day`
    $listTable="CREATE TABLE IF NOT EXISTS `list_for_the_day` (
                    `day_id` int(11) NOT NULL AUTO_INCREMENT,
                    `day_date` varchar(25) NOT NULL,
                    `user_list` text NOT NULL,PRIMARY KEY (day_id)
                     ) ENGINE=InnoDB DEFAULT CHARSET=latin1";
    $query=  mysqli_query($con, $listTable);
    if(!empty(mysqli_error_list($con))){
        $errors[0]=mysqli_error_list($con);
    }
    
    $userTable="CREATE TABLE `users` (
                `user_id` int(11) NOT NULL AUTO_INCREMENT,
                `member_id` int(11) NOT NULL,
                `fname` varchar(100) NOT NULL,
                `lname` varchar(100) NOT NULL,
                `mname` varchar(100) NOT NULL,
                `sex` varchar(50) NOT NULL,
                `rating` int(11) NOT NULL,
                `expiration` varchar(25) NOT NULL,
                `last_played` varchar(25) NOT NULL,
                `email` varchar(255) NOT NULL,PRIMARY KEY (user_id), UNIQUE KEY (`member_id`)
              ) ENGINE=InnoDB DEFAULT CHARSET=latin1";
    $query=  mysqli_query($con, $userTable);
    if(!empty(mysqli_error_list($con))){
        $errors[1]=mysqli_error_list($con);
    }
    if(empty($errors)){
        echo json_encode(array('error'=>'false','message'=>'Success'));
    }
    else{
        echo json_encode(array('error'=>'true','message'=>$errors));
    }
?>