Web42Log - The Making Of

Web42Log will use MySQL for storing data. The table layout has to be done first since all other parts will depend on it. Small changes are possible at every time (and I'm sure there will be lots of small changes) but a complete change of the database design would render every completed program part useless.

You can download a diagram of the database structure in DIA format or in PNG format. This UML diagram will be converted to SQL with dia2sql.pl.
I had to patch dia2sql.pl so that it is able to use the file format of recent DIA versions and to create index statements for MySQL. I should remember tomake up a clean patch for the upstream author.

The diagram should be self explaining. A "#" marks a field as the primary key and a "-" marks it as indexed. A "+" has no special meaning.

The Making Of

This page contains my thoughts about the construction of Web42Log and will be updated continiously with upcoming parts of the project.