Open Source Database Schemas

I am seeking the help of the community. I am working on an evaluation project about schema design in open source applications. While it’s possible for me to download the software of many popular apps, and install the software and then do a mysqldump, it takes time. Quite often there is no simple schema.sql file, but a process for creating the schema. If you are using an open source project, would you take a moment and run the following.

$ mysqldump -u[user] -p --skip-lock-tables --no-data --databases [schema]  > [schema].sql

This will only dump the table definitions, and should therefore contain nothing company specific. I have at this time:

  • WordPress
  • Drupal
  • Mediawiki
  • OS Commerce
  • Joomla
  • EzPublish
  • PHPWiki

I am open to any projects, and it doesn’t matter if the version is not the most current, what I am seeking is to understand trends. There is a huge list of possibilities including Bugzilla, PHPBB, SugarCRM, Magento, PHPWiki just to name a few.

Your help would be greatly appreciated. You are welcome to add a a comment, or email me at [this domain] with your results.

I am also happy to accept sanitized schemas of any projects, however please ensure no company or propriety specific information is provided.

6 Responses to “Open Source Database Schemas”

  1. ankle says:

    You’re only interested in MySQL-based systems?

  2. [...] Ronald Bradford is working on an evaluation project about schema design in open source applications, and seeks community help. [...]

  3. ronald says:

    Yes, at this time, this is my focus.

  4. ronald says:

    Thanks

  5. At Mozilla we have customized our Bugzilla installation a lot. But it should be relatively easy to get the schema from the Bugzilla download at http://www.bugzilla.org/download/. (We do allow academic researchers to have our data, see https://bugzilla.mozilla.org/page.cgi?id=researchers.html, but I don’t know about the schema).

    You might also look at RT, the request tracker.

    You wouldn’t need to install all these, just download them and look for the schema file that would be imported.