CREATE TABLE `user` (
 `UserId` int(255) NOT NULL DEFAULT '0',
 `UserName` varchar(50) DEFAULT NULL,
 `UserDOB` date DEFAULT NULL,
 `UserBio` longtext,
 `UserReputation` int(100) DEFAULT NULL,
 `UserPassword` varchar(100) DEFAULT NULL,
 `UserRole` varchar(10000) DEFAULT NULL,
 `profilepicture` blob,
 `UserEmail` varchar(50) DEFAULT NULL,
 PRIMARY KEY (`UserId`)
)
CREATE TABLE `tag` (
 `tagID` int(11) NOT NULL DEFAULT '0',
 `tagContent` varchar(100) DEFAULT NULL,
 `tagCount` int(11) DEFAULT NULL,
 PRIMARY KEY (`tagID`)
)
CREATE TABLE `posttagrelation` (
 `postID` int(11) NOT NULL DEFAULT '0',
 `tagID` int(11) NOT NULL DEFAULT '0',
 PRIMARY KEY (`postID`,`tagID`)
)
CREATE TABLE `postcategoryrelation` (
 `postID` int(11) NOT NULL DEFAULT '0',
 `categoryID` int(11) NOT NULL DEFAULT '0',
 PRIMARY KEY (`postID`,`categoryID`)
)
CREATE TABLE `post` (
 `postID` int(11) NOT NULL DEFAULT '0',
 `postTitle` varchar(100) DEFAULT NULL,
 `postContent` mediumtext,
 `postAuthor` varchar(100) DEFAULT NULL,
 `postDate` date DEFAULT NULL,
 `postUpvote` int(11) DEFAULT NULL,
 `postDownvote` int(11) DEFAULT NULL,
 `postViewCount` int(11) DEFAULT NULL,
 PRIMARY KEY (`postID`)
)
CREATE TABLE `follow` (
 `userID` int(11) NOT NULL DEFAULT '0',
 `followingID` int(11) NOT NULL DEFAULT '0',
 PRIMARY KEY (`userID`,`followingID`)
)