kwAKPQxK

1DROP DATABASE IF exists Tumblr;
2CREATE database Tumblr charset 'utf8';
3USE Tumblr;
4
5create table Blog(
6	Id integer not null primary key auto_increment,
7    Name varchar(100) not null,
8    NumberOfLikes integer not null	
9);
10
11create table BlogPost(
12	Id integer not null primary key auto_increment,
13	Name varchar(100) not null,
14    BlogId integer not null
15);
16
17create table Likes(
18    UserId integer not null,
19    BlogPost varchar(500) not null
20);
21
22create table User(
23	Id integer not null primary key,
24	Name varchar(100) not null
25);
26
27insert into Blog(Id, Name, NumberOfLikes) values (1, "League of Legends", 10000);
28insert into Blog(Name, NumberOfLikes) values ("Leafy is Here", 500);
29insert into Blog(Name, NumberOfLikes) values ("Basic Bitches", 100);
30
31
32insert into BlogPost(Id, Name, BlogId) values (1, "Shit talk", 2);
33insert into BlogPost(Name, BlogId) values ("Basic shit", 3);
34insert into BlogPost(Name, BlogId) values ("ahahaha", 1);
35insert into BlogPost(Name, BlogId) values ("Asdf", 1);