Friday, July 22, 2011

Build your own updated Moodle Schema

This particular post is to assist in getting a Moodle DB schema specific to your database. It is especially handy if there are non-standard plugins installed on Moodle.

As mentioned in an earlier post, getting a relevant ERD on is almost herculian. This tool will reverse engineer the databse ERD.

The application is Fabforce4 located at

Installation on Windows is straightforward, simply download, install and configure to point to your database.

Installation on CentOS linux was not as good. The application refused to launch. I decided to run it on Wine (which I had to install here).

I'll update with a sample schema of my test database as soon as the operation completes.



  1. Note: I'm able to retrieve the tables fine, but the relationships are not being built. The applications hangs (I even left it running over a weekend with 100% CPU Util).
    Back to the drawing board for a decent ERD.

  2. can you tell me how did you retrieve the tables from moodle please ?