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