text: -- schema.sql
  
  drop database if exists awesome;
  
  create database awesome;
  
  use awesome;
  
  grant select, insert, update, delete on awesome.* to 'www-data'@'localhost' identified by 'www-data';
  
  create table users (
  	`id` varchar(50) not null,
  	`email` varchar(50) not null,
  	`password` varchar(50) not null,
  	`admin` bool not null,
  	`name` varchar(50) not null,
  	`image` varchar(500) not null,
  	`created_at` real not null,
  	unique key `idx_email` (`email`),
  	primary key (`id`)
  ) engine=innodb default charset=utf8;
  
  create table blogs (
  	`id` varchar(50) not null,
  	`user_id` varchar(50) not null,
  	`user_name` varchar(50) not null,
  	`user_image` varchar(500) not null,
  	`name` varchar(50) not null,
  	`summary` varchar(200) not null,
  	`content` mediumtext not null,
  	`created_at` real not null,
  	primary key (`id`)
  ) engine=innodb default charset=utf8;
  
  create table comments(
  	`id` varchar(50) not null,
  	`blog_id` varchar(50) not null,
  	`user_id` varchar(50) not null,
  	`user_name` varchar(50) not null,
  	`user_iamge` varchar(500) not null,
  	`content` mediumtext not null,
  	`created_at` real not null,
  	primary key (`id`)
  ) engine=innodb default charset=utf8;