CREATE TABLE Users(UserID INT Primary Key AUTO_INCREMENT,
Username VARCHAR(200) NOT NULL,
First_Name VARCHAR(50) NOT NULL ,
Last_Name VARCHAR(50) NOT NULL ,
Email Varchar(50),
Date_of_Birth Varchar(20),
Join_Date varchar(20));
CREATE TABLE Posts(PostID INT Primary Key AUTO_INCREMENT,
UserID INT,
Post_Text VARCHAR(500),
Post_Date VARCHAR(20),
FOREIGN KEY(UserID) REFERENCES Users(UserID));
CREATE TABLE Comments(CommentID INT Primary Key AUTO_INCREMENT,
PostID INT,
UserID INT,
Comment_Text VARCHAR(500),
Comment_Date VARCHAR(20),
FOREIGN KEY(PostID) REFERENCES Posts(PostID),
FOREIGN KEY(UserID) REFERENCES Users(UserID));
CREATE TABLE Likes(LikeID INT Primary Key AUTO_INCREMENT,
PostID INT,
UserID INT,
Like_Date VARCHAR(20),
FOREIGN KEY(PostID) REFERENCES Posts(PostID),
FOREIGN KEY(UserID) REFERENCES Users(UserID));
SELECT * From Users
To embed this program on your website, copy the following code and paste it into your website's HTML: