createDB.php

<?php
include("initial.php");

//user table
$query = "CREATE TABLE IF NOT EXISTS user(
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(60) NOT NULL UNIQUE,
name VARCHAR(100) NOT NULL,
password VARCHAR(100) NOT NULL,
email VARCHAR(100) NOT NULL
)";

$create = mysqli_query($con,$query);
if(!$create){
	echo mysqli_error($con);
}


  //created form list table
$query = "CREATE TABLE IF NOT EXISTS form_list(
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(30) NOT NULL,
form_title VARCHAR(100) NOT NULL,
form_description text NOT NULL,
url text DEFAULT NULL,
total_submissions INT DEFAULT 0,
submissions_per_user INT DEFAULT 0,
form_validity INT DEFAULT 0,
date_created VARCHAR(20) NOT NULL,
status INT NOT NULL
)";
$create = mysqli_query($con,$query);
if(!$create){
	echo mysqli_error($con);
}


//question table
$query = "CREATE TABLE IF NOT EXISTS form_questions(
id INT AUTO_INCREMENT PRIMARY KEY,
form_id INT NOT NULL,
question VARCHAR(128) NOT NULL,
required VARCHAR(10) NOT NULL,
answer_type VARCHAR(100) NOT NULL,
FOREIGN KEY (form_id) REFERENCES form_list(id)
)";  

$create = mysqli_query($con,$query);

if(!$create){
	echo mysqli_error($con);
}



$query = "CREATE TABLE IF NOT EXISTS form_options (
id INT AUTO_INCREMENT PRIMARY KEY,
question_id INT NOT NULL,
options VARCHAR(40) NOT NULL,
FOREIGN KEY (question_id) REFERENCES form_questions(id)
)";

$create = mysqli_query($con,$query);
if(!$create){
	echo mysqli_error($con);
}


//answer table
$query = "CREATE TABLE IF NOT EXISTS answers(
id INT AUTO_INCREMENT PRIMARY KEY,
form_id INT NOT NULL,
question_id INT NOT NULL,
answer text NOT NULL,
username VARCHAR(60) NOT NULL,
FOREIGN KEY (question_id) REFERENCES form_questions(id),
FOREIGN KEY (form_id) REFERENCES form_list(id)
)";  
$create = mysqli_query($con,$query);	

if(!$create){
	echo mysqli_error($con);
}

//notifications
$query = "CREATE TABLE IF NOT EXISTS notifications(
id INT AUTO_INCREMENT PRIMARY KEy,
username VARCHAR(60) NOT NULL,
message text NOT NULL,
date_filled VARCHAR(20) NOT NULL
)";

$create = mysqli_query($con,$query);

?>