CREATE TABLE `Users` (
	`User_ID` int PRIMARY KEY,
	`Username` varchar(255),
	`Password` varchar(255),
	`Firstname` varchar(255),
	`Lastname` varchar(255),
	`Gender` varchar(255),
	`DateOfBirth` datetime,
	`Join_Date` datetime,
	`Profile_Picture` varchar(255),
	`isAdmin` bool,
	`Activated` bool,
	`Banned` bool,
	`Activation_Code` varchar(255)
);
CREATE TABLE `Questions` (
	`Question_ID` int PRIMARY KEY,
	`Question` varchar(255),
	`Question_Details` varchar(255),
	`Question_Date` datetime,
	`Best_Answer_ID` int,
	`User_ID` int,
	`Category_ID` int,
	FOREIGN KEY(`User_ID`) REFERENCES `Users` (`User_ID`),
	FOREIGN KEY(`Category_ID`) REFERENCES `Categories` (`Category_ID`)
);
CREATE TABLE `Answers` (
	`Answer_ID` int PRIMARY KEY,
	`Answer` varchar(255),
	`Answer_Date` datetime,
	`User_ID` int,
	`Question_ID` int,
	FOREIGN KEY(`User_ID`) REFERENCES `Users` (`User_ID`),
	FOREIGN KEY(`Question_ID`) REFERENCES `Questions` (`Question_ID`)
);
CREATE TABLE `Categories` (
	`Category_ID` int PRIMARY KEY,
	`Category` varchar(255),
	`Category_Description` varchar(255),
	`Category_Image` varchar(255),
	`Parent_Category_ID` int
);