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.
You’re only interested in MySQL-based systems?
You can find the eZPublish schema at https://github.com/ezsystems/ezpublish/blob/master/kernel/sql/mysql/cluster_schema.sql
Yes, at this time, this is my focus.
Thanks
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.