In this assignment you will use your PHP and MySQL skills to create a very simple social networking site. Authorized users can post, and can comment on other posts. (YOU KNOW ENOUGH TO CREATE A SITE WITH MULTIPLE USERS, EACH WITH HIS/HER OWN PAGE, but I am not asking you to do that.)

DB Tables [Start DB name with your login name followed by an underscore on 163.238.35.165]

At the minimum you should have three DB tables:

Users table

username (primary key)

password (remember to store encrypted)

email address

Post table

id of post(primary key)

title (255 char max)

body of post (5000 char max)

user name that created this post (this is a foreign key for Users table)

date/time the post was created

Comments table

id of comment (primary key)

name of user commenting (foreign key for users table)

body of comment (5000 word maximum)

post id that the comment is about (foreign key for Blog Post table)

date/time comment was posted

Populate your database with 4 users and 10 blog Posts.