I add the revelants parts of sql.log:
CREATE TABLE bookpage(
id INT AUTO_INCREMENT NOT NULL,
content LONGTEXT,
image VARCHAR(255),
from_book INT, INDEX from_book__idx (from_book), FOREIGN KEY
(from_book) REFERENCES book(id) ON DELETE CASCADE,
modified_on DATETIME,
PRIMARY KEY(id)
) ENGINE=InnoDB CHARACTER SET utf8;
success!
CREATE TABLE page_link(
id INT AUTO_INCREMENT NOT NULL,
in_page INT, INDEX in_page__idx (in_page), FOREIGN KEY (in_page)
REFERENCES bookpage(id) ON DELETE CASCADE,
out_page INT, INDEX out_page__idx (out_page), FOREIGN KEY
(out_page) REFERENCES bookpage(id) ON DELETE CASCADE,
text VARCHAR(255),
PRIMARY KEY(id)
) ENGINE=InnoDB CHARACTER SET utf8;
--
