The ./xml directory
The most important directory in The DOPE is the xml directory. This contains all the table definitions in Apache Turbine XML format. The SQL is generated automatically from the XML.
The ./bin directory
The bin directory contains scripts that generate the SQL scripts from the XML, that construct the databases from the SQL scripts, and load in the example data from the data directory.
The ./sql directory
The ./sql directory contains the SQL for creating the database. The database creation SQL is specific to the different types of databases so the SQL for creating the MySQL database is put into the sql/mysql subdirectory, the SQL for SQLite3 is put into the sql/sqlite3 directory, etc. The sql/data directory contains the insert statements for the static and example data.
The ./data directory
This directory contains the static and example data for populating the various tables. This data is used to create the SQL INSERT statements which are then placed under the ./sql/data directory.