N0ZuvMEP

1CREATE TABLE IF NOT EXISTS `gregs_list`.`Book_Author` (
2  `id` INT NOT NULL,
3  `book-id` INT NOT NULL,
4  `author-id` INT NOT NULL,
5  PRIMARY KEY (`id`),
6  UNIQUE INDEX `id_UNIQUE` (`id` ASC))
7ENGINE = InnoDB CHARACTER SET utf8;
8
9CREATE TABLE IF NOT EXISTS `gregs_list`.`Authors` (
10  `id` INT NOT NULL,
11  `name` VARCHAR(45) NULL,
12  `gender` VARCHAR(45) NULL,
13  `born` DATE NULL,
14  PRIMARY KEY (`id`),
15  UNIQUE INDEX `id_UNIQUE` (`id` ASC),
16  CONSTRAINT `id`
17    FOREIGN KEY (`id`)
18    REFERENCES `gregs_list`.`Book_Author` (`author-id`)
19    ON DELETE NO ACTION
20    ON UPDATE NO ACTION)
21ENGINE = InnoDB CHARACTER SET utf8;
22
23
24CREATE TABLE IF NOT EXISTS `gregs_list`.`Books` (
25  `id` INT not NULL,
26  `name` VARCHAR(200) NOT NULL,
27  `published` DATE NULL,
28  `genre` VARCHAR(45) NULL,
29  `rating` INT NULL,
30  PRIMARY KEY (`id`),
31  UNIQUE INDEX `id_UNIQUE` (`id` ASC),
32  CONSTRAINT `kniga`
33    FOREIGN KEY (`id`)
34    REFERENCES `gregs_list`.`Book_Author` (`book-id`)
35    ON DELETE NO ACTION
36    ON UPDATE NO ACTION)
37ENGINE = InnoDB