DROP DATABASE IF EXISTS `kensaku`;
CREATE DATABASE `kensaku` CHARACTER SET `utf8` COLLATE `utf8_unicode_ci`;

USE `kensaku`;

DROP TABLE IF EXISTS `website`;
CREATE TABLE `website` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `url` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS `website_page`;
CREATE TABLE `website_page` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `website_id` int(10) NOT NULL,
  `url` varchar(100) NOT NULL,
  `title` varchar(100),
  `body` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;