Entity Relationship Diagram for Moodle 3.0 released #Moodle3.0 #ERD

January 27th, 2016

Entity relationship diagram (ERD) is released for the latest Moodle 3.0 by Marcus Green. The ERD for Moodle 3.0 is based on “reverse engineering” the code from a fresh install of Moodle 3.0

The diagram was generated by using the reverse engineering feature of the MySQL Workbench tool using a file containing the SQL code used to install Moodle. The SQL statements were extracted from the install.xml files from each Moodle module. This was converted from XML to SQL using a utility which can be downloaded through this link. Read More

Install new tables into database of Moodle site by using UpgradeDB plugin

October 12th, 2015

UprgadeDB plugin is basically meant for developers to help them in designing new plugins  and this plugin allows the developers to install new tables into Moodle DB using xmldb files completely under developer control.

You can choose which install.xml table want to install in place to install all tables and upgrade tables whenever you want. At present you can’t delete the tables which contains any data in it and in future you can add new columns and empty tables using this plugin Read More