1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
ALTER TABLE `ebook_format` CHANGE `mime_type` `mime_type` VARCHAR( 128 ) NOT NULL;
#rev 25
CREATE TABLE `ebook_serie_other_authors` (
`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
`serie_id` integer NOT NULL,
`author_id` integer NOT NULL,
UNIQUE (`serie_id`, `author_id`)
)
;
ALTER TABLE `ebook_serie_other_authors` ADD CONSTRAINT `serie_id_refs_id_9cdd2349` FOREIGN KEY (`serie_id`) REFERENCES `ebook_serie` (`id`);
ALTER TABLE `ebook_serie_other_authors` ADD CONSTRAINT `author_id_refs_id_a616dddb` FOREIGN KEY (`author_id`) REFERENCES `ebook_author` (`id`);
CREATE TABLE `ebook_ebook_other_authors` (
`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
`ebook_id` integer NOT NULL,
`author_id` integer NOT NULL,
UNIQUE (`ebook_id`, `author_id`)
)
;
ALTER TABLE `ebook_ebook_other_authors` ADD CONSTRAINT `ebook_id_refs_id_2aa4fec3` FOREIGN KEY (`ebook_id`) REFERENCES `ebook_ebook` (`id`);
ALTER TABLE `ebook_ebook_other_authors` ADD CONSTRAINT `author_id_refs_id_8a488791` FOREIGN KEY (`author_id`) REFERENCES `ebook_author` (`id`);
|