home
> work
>> htl
>>> instdb

translate to German (by SYSTRAN)

Installation Database

For keeping track of software and configuration installations I have implemented a database (I'm currently using PostgreSQL 7.0). Every time a software package is installed, the installation script generates an e-mail message with the relevant information which is then semi-automatically stored in the database.

Some PHP-Scripts on my Web-site access the database and publish the information in an easily readable format (HTML tables).

Database Model

This SQL-script (instdb.sql) generates the database schema. It might look a bit complicated on first sight, but it keeps redundancy to a minimum.

Sorry, no Entity/Relationship diagrams yet... :-(