DROP DATABASE IF EXISTS tumblr; CREATE DATABASE tumblr; USE

DROP DATABASE IF EXISTS tumblr;
CREATE DATABASE tumblr;
USE tumblr;

CREATE TABLE Blog(
    Id INTEGER NOT NULL PRIMARY KEY,
    Name VARCHAR(50),
    Number_of_likes INTEGER NOT NULL
);

CREATE TABLE BlogPost(
    Id INTEGER NOT NULL PRIMARY KEY,
    Name VARCHAR(50),
    Blog_id INTEGER NOT NULL
);

CREATE TABLE Likes(
    Id INTEGER NOT NULL PRIMARY KEY,
    User_id INTEGER NOT NULL,
    Blog_post_id INTEGER NOT NULL