# Pastebin LfFZynZ2
CREATE TABLE `proves`.`users` ( 
`id` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255),
`password` VARCHAR(255),
`mail` VARCHAR(255),
`birth_date` DATE,
`group_id` INT,
`subscription_state_id` INT,
`created` DATETIME DEFAULT CURRENT_TIMESTAMP,
`modified` DATETIME ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `proves`.`groups` ( 
`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`.`books` ( 
`id` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255),
`isbn` VARCHAR(20),
`cdu` VARCHAR(20),
`format_id` INT,
`editorial_id` INT,
`collection_id` INT,
`collection_item` INT,
`edition_place_id` INT,
`edition_country_id` INT,
`edition_date` DATE,
`image` VARCHAR(255),
`image_dir` VARCHAR(255),
`image_size` INT(11),
`image_type` VARCHAR(255),
`url` VARCHAR(2083),
`height` INT,
`width` INT,
`pagecount` INT,
`lending_state_id` INT,
`catalogue_state_id` INT,
`created` DATETIME DEFAULT CURRENT_TIMESTAMP,
`modified` DATETIME ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`)) ENGINE = InnoDB;
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`.`formats` ( 
`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`.`illustrators` ( 
`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`.`subjects` ( 
`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`.`level` ( 
`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`.`lendings` ( 
`id` INT NOT NULL AUTO_INCREMENT,
`book_id` INT,
`item_id` INT,
`user_id` INT,
`format_id` INT,
`group_id` INT,
`lending_policy_id` INT,
`date_taken` DATE,
`date_return` DATE,
`date_real_return` DATE,
`lending_state_id` INT,
`created` DATETIME DEFAULT CURRENT_TIMESTAMP,
`modified` DATETIME ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `proves`.`texttypes` ( 
`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`.`locations` ( 
`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`.`editorials` ( 
`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`.`collections` ( 
`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`.`conservation_states` ( 
`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`.`catalogue_states` ( 
`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`.`lent_states` ( 
`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`.`items` ( 
`id` INT NOT NULL AUTO_INCREMENT,
`book_id` INT,
`lendable_state` INT,
`lending_state` INT,
`conservation_state_id` INT,
`created` DATETIME DEFAULT CURRENT_TIMESTAMP,
`modified` DATETIME ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `proves`.`lendable_states` ( 
`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`.`lending_policies` ( 
`id` INT NOT NULL AUTO_INCREMENT,
`group_id` INT,
`format_id` INT,
`lending_length` INT,
`lending_max` INT,
`created` DATETIME DEFAULT CURRENT_TIMESTAMP,
`modified` DATETIME ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `proves`.`subscription_states` ( 
`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`.`edition_countries` ( 
`id` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(40),
`created` DATETIME DEFAULT CURRENT_TIMESTAMP,
`modified` DATETIME ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `proves`.`edition_places` ( 
`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(20),
`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;
CREATE TABLE `proves`.`books_subjects` ( 
`id` INT NOT NULL AUTO_INCREMENT,
`book_id` INT,
`subject_id` INT,
`created` DATETIME DEFAULT CURRENT_TIMESTAMP,
`modified` DATETIME ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `proves`.`books_levels` ( 
`id` INT NOT NULL AUTO_INCREMENT,
`book_id` INT,
`level_id` INT,
`created` DATETIME DEFAULT CURRENT_TIMESTAMP,
`modified` DATETIME ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `proves`.`books_texttypes` ( 
`id` INT NOT NULL AUTO_INCREMENT,
`book_id` INT,
`texttype_id` INT,
`created` DATETIME DEFAULT CURRENT_TIMESTAMP,
`modified` DATETIME ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `proves`.`items_locations` ( 
`id` INT NOT NULL AUTO_INCREMENT,
`item_id` INT,
`location_id` INT,
`created` DATETIME DEFAULT CURRENT_TIMESTAMP,
`modified` DATETIME ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `proves`.`languages` ( 
`id` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50),
`created` DATETIME DEFAULT CURRENT_TIMESTAMP,
`modified` DATETIME ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `proves`.`lending_states` ( 
`id` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50),
`created` DATETIME DEFAULT CURRENT_TIMESTAMP,
`modified` DATETIME ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`)) ENGINE = InnoDB;
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;