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.
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` varchar(50) NOT NULL, PRIMARY KEY (`code`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; INSERT INTO `country` (`code`, `description`) VALUES ('ca', 'Canada'), ('uk', 'United Kingdom');
We will now link this table to the author
table. First, in the...