CREATE TABLE `blog`.`post` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(500) NULL,
  `content` VARCHAR(5000) NULL,
  `created_at` DATETIME NULL,
  PRIMARY KEY (`id`));


  CREATE TABLE `blog`.`user` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(200) NULL,
  `password` VARCHAR(200) NULL,
  `role` VARCHAR(200) NULL,
  PRIMARY KEY (`id`));

  CREATE TABLE `blog`.`comment`(
  `id` INT NOT NULL AUTO_INCREMENT,
  `post_id` INT NOT NULL,
  `user_id` INT NOT NULL,
  `created_at` DATETIME NULL,
  `content` VARCHAR(5000) NULL,
  PRIMARY KEY (`id`));