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');