CREATE DATABASE home_library;
use home_library;
CREATE TABLE `library` (
 `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
 `title` VARCHAR(255) NOT NULL,
 `author` VARCHAR(255),
 `genre` VARCHAR(50),
 `type` VARCHAR(50),
 `year` INTEGER UNSIGNED,
 `comment` VARCHAR(1000),
 PRIMARY KEY (`id`)
);