CREATE DATABASE qoobk CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

USE qoobk;

DROP TABLE IF EXISTS book;

CREATE TABLE book (
                      id MEDIUMINT NOT NULL AUTO_INCREMENT,
                      title CHAR(255) NOT NULL,
                      url VARCHAR(2048) CHARACTER SET utf8mb4,
                      PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;