Mastering phpMyAdmin 3.4 for Effective MySQL Management

Generating relational schemas

In Chapter 10, we defined relations between the book and author tables. These relations were used for various foreign key functions (for example, getting a list of possible values in Insert mode). We will now examine a feature that enables us to generate a custom-made relational schema for our tables in the popular PDF format and other formats as well. This feature requires that the phpMyAdmin configuration storage be properly installed and configured.

Adding a third table to our model

To get a more complete schema, we will now add another table, country, to our database. The following block of code displays the contents of its export file:

CREATE TABLE IF NOT EXISTS `country` ( `code` char(2) NOT NULL, `description` ...