# Pastebin o0GUan8M CREATE TABLE `proves`.`authors` ( `id` INT NOT NULL AUTO_INCREMENT, `name` VARCHAR(255), `created` DATETIME DEFAULT CURRENT_TIMESTAMP, `modified` DATETIME ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `proves`.`author_types` ( `id` INT NOT NULL AUTO_INCREMENT, `name` VARCHAR(255), `created` DATETIME DEFAULT CURRENT_TIMESTAMP, `modified` DATETIME ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `proves`.`authorities` ( `id` INT NOT NULL AUTO_INCREMENT, `author_id` INT, `author_type_id` INT, `created` DATETIME DEFAULT CURRENT_TIMESTAMP, `modified` DATETIME ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `proves`.`authorities_books` ( `id` INT NOT NULL AUTO_INCREMENT, `authority_id` INT, `book_id` INT, `created` DATETIME DEFAULT CURRENT_TIMESTAMP, `modified` DATETIME ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`)) ENGINE = InnoDB;