O'Reilly logo

Professional Plone Development: Building robust, content-centric web applications with Plone 3, an open source Content Management System by Martin Aspeli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Setting Up the Database

The examples in this book use MySQL 5.0, with InnoDB tables, but the concepts we describe should apply equally to other databases.

Note

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required