The examples in this book use MySQL 5.0, with InnoDB tables, but the concepts we describe should apply equally to other databases.
Unlike tables using the MyISAM engine, InnoDB tables properly support foreign key constraints. We will make use of these to infer relationships between tables.
We chose MySQL because it is free and relatively easy to set up. You can download it from http://mysql.org.
The table definitions, as well as some sample data, are provided with the book, in the
extra folder. The scripts create two database instances:
optilux, the main database, and
optilux_test, a blank database used for testing. Here is the code that sets up the main database:
create database if not exists optilux; use optilux; -- Screenings ...