In Chapter 11, 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). Now, we will examine a feature that enables us to generate a custom-made relational schema for our tables in a popular format: PDF. This feature requires that the linked-tables infrastructure be properly installed and configured, as explained in Chapter 11.

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');