How to Create Social Networking Site
Added on - 26 Sep 2019
E. Specific Social Networking features of YOUR site18.Topic: this will allow users to post or view ideas by topic. Most new ideas are generic bynature, but one might share idea that is specific to a profession. Ideas that are specific to asubject such as science, IT, cosmology will be categorized.Challenging functionalities of proposed SN.19.Trend analysisfor search and recommend trending posts on the home page of our SN. Thetechnical details of how to implement the function is yet to be researched.20.Image upload. Drag and drop would be considered but not prioritized.
CREATE DATABASE if not exists web_coursework;use web_coursework;create table tblPosts (postID int auto_increment,userID int not null,postTitle varchar(250) not null,postTopic varchar(250) not null,postDateTime TIMESTAMP not null DEFAULT CURRENT_TIMESTAMP,postBody varchar(10000) not null,PRIMARY KEY (postID))AUTO_INCREMENT=1;create table tblComment (commentID int auto_increment,postID int not null,userID int not null,commentsDateTime TIMESTAMP not null DEFAULT CURRENT_TIMESTAMP,comment_Body varchar(1000) not null,PRIMARY KEY (commentID))AUTO_INCREMENT=1;create table tblLike (likeID int auto_increment,userID int not null,postID int not null,