CREATE TABLE IF NOT EXISTS users ( id int(6) unsigned NOT NULL, name varchar(30) NOT NULL, date varchar(30) NOT NULL, url varchar(30) NOT NULL, org varchar(30) NOT NULL, source varchar(30) NOT NULL, PRIMARY KEY (id) ) DEFAULT CHARSET=utf8; INSERT INTO users (id, name, date, url, org, source) VALUES ('1','Ankit Shukla','27-11-2021','/ankit','HelloPM','organic'), ('2','Gagan Mahajan','28-11-2021','/gagan','Meesho','organic'), ('3','Robert Clive','29-11-2021','/robert','EIC','organic'), ('4','Parag Agarwal','29-11-2021','/parag','Twitter','twitter-promotion');

CREATE TABLE IF NOT EXISTS posts ( id int(6) unsigned NOT NULL, content varchar(50) NOT NULL, date varchar(30) NOT NULL, user_id int(6) unsigned NOT NULL, PRIMARY KEY (id) ) DEFAULT CHARSET=utf8; INSERT INTO posts (id, content, date, user_id) VALUES ('1','Post from Ankit','27-11-2021','1'), ('2','Post 2 from Ankit','28-11-2021','1'), ('3','Post 3 from Ankit','29-11-2021','1'), ('4','Post from Gagan','29-11-2021','2'), ('5','Post 2 from Gagan','29-11-2021','2'), ('6','Post 3 from Gagan','29-11-2021','2'), ('7','Post from Parag','29-11-2021','4');

CREATE TABLE IF NOT EXISTS reactions ( id int(6) unsigned NOT NULL, type varchar(50) NOT NULL, post_id int(6) unsigned NOT NULL, user_id int(6) unsigned NOT NULL, date varchar(30) NOT NULL, PRIMARY KEY (id) ) DEFAULT CHARSET=utf8; INSERT INTO reactions (id, type, post_id, user_id, date) VALUES ('1','like','1','1','27-11-2021'), ('2','heart','1','2','28-11-2021'), ('3','like','2','1','29-11-2021'), ('4','like','2','2','29-11-2021'), ('5','like','3','1','29-11-2021'), ('6','like','3','2','29-11-2021'), ('7','celebrate','1','2','29-11-2021'), ('8','like','2','3','29-11-2021'), ('9','heart','3','1','29-11-2021'), ('10','celebrate','4','4','29-11-2021');