Uz5EhRjN

1DROP DATABASE IF EXISTS tumblr;
2CREATE DATABASE tumblr;
3USE tumblr;
4 
5CREATE TABLE Blog(
6    Id INTEGER NOT NULL PRIMARY KEY,
7    Name VARCHAR(50),
8    Number_of_likes INTEGER NOT NULL
9);
10 
11CREATE TABLE BlogPost(
12    Id INTEGER NOT NULL PRIMARY KEY,
13    Name VARCHAR(50),
14    Blog_id INTEGER NOT NULL
15);
16 
17CREATE TABLE Likes(
18    Id INTEGER NOT NULL PRIMARY KEY,
19    User_id INTEGER NOT NULL,
20    Blog_post_id INTEGER NOT NULL