Database Schema: Difference between revisions
No edit summary |
|||
Line 5: | Line 5: | ||
Discussion of the database schemas happens either in the forum of the relevant module, or in the [https://moodle.org/mod/forum/view.php?id=55 General developer forum]. | Discussion of the database schemas happens either in the forum of the relevant module, or in the [https://moodle.org/mod/forum/view.php?id=55 General developer forum]. | ||
=Moodle 3.2= | |||
[http://www.examulator.com/er/ Web view of the Moodle 3.2 schema] and a downloadable [http://www.examulator.com/er/moodle_32_erd.mwb Moodle 3.2 schema] by [http://www.moodleworld.com/moodle-entity-relationship-diagram-moodle-3-2-available-moodle3-2/ Marcus green] can be opened by [http://www.mysql.com/products/workbench MYSQL Workbench] tool. Which was reversed engineered using [http://www.examulator.com/er/er_howto.html moodle_local-sqlgenerator]. | |||
=Moodle 3.1= | =Moodle 3.1= | ||
[http://www.examulator.com/er/ Web view of the Moodle 3.1 schema] and a downloadable [http:// | [http://www.examulator.com/er/3.1/index.html Web view of the Moodle 3.1 schema] and a downloadable [http://examulator.com/er/3.1/moodle_31_erd.mwb Moodle 3.1 schema] by [https://moodle.org/mod/forum/discuss.php?d=278052 Marcus green] can be opened by [http://www.mysql.com/products/workbench MYSQL Workbench] tool. Which was reversed engineered using [http://www.examulator.com/er/er_howto.html moodle_local-sqlgenerator]. | ||
=Moodle 3.0= | =Moodle 3.0= |
Revision as of 09:42, 17 May 2017
The files available here are in DBDesigner4 format. DBDesigner4 is a schema drawing program released under GPL.
The database schemas have been put together by Alberto Giampani, Dario Toledo and Isaac Cueto. We are also discussing a means of creating them automatically from the new XMLDB definitions with an XML transform.
Discussion of the database schemas happens either in the forum of the relevant module, or in the General developer forum.
Moodle 3.2
Web view of the Moodle 3.2 schema and a downloadable Moodle 3.2 schema by Marcus green can be opened by MYSQL Workbench tool. Which was reversed engineered using moodle_local-sqlgenerator.
Moodle 3.1
Web view of the Moodle 3.1 schema and a downloadable Moodle 3.1 schema by Marcus green can be opened by MYSQL Workbench tool. Which was reversed engineered using moodle_local-sqlgenerator.
Moodle 3.0
Web view of the Moodle 3.0 schema and a downloadable Moodle 3.0 schema by Marcus green can be opened by MYSQL Workbench tool. Which was reversed engineered using moodle_local-sqlgenerator.
Moodle 2.9
Web view of the Moodle 2.9 schema and a downloadable Moodle 2.9 schema by Marcus green can be opened by MYSQL Workbench tool. Which was reversed engineered using moodle_local-sqlgenerator.
Moodle 2.8
Web view of the Moodle 2.8 schema and a downloadable Moodle 2.8 schema by Marcus green can be opened by MYSQL Workbench tool. Which was reversed engineered using moodle_local-sqlgenerator.
Moodle 2.7
Web view of the Moodle 2.7 schema and a downloadable Moodle 2.7 schema by Marcus green can be opened by MYSQL Workbench tool. Which was reversed engineered using moodle_local-sqlgenerator.
Moodle 2.2
Web view of the Moodle 2.2 schema and a downloadable Moodle 2.2 schema by Marcus green can be opened by MYSQL Workbench tool. Which was reversed engineered using moodle_local-sqlgenerator.
Moodle 1.8
http://moodle.org/file.php/5/moddata/forum/28/376698/moodle_1.8_data_structure.rar
Moodle 1.7
http://moodle.org/file.php/11/moddata/forum/110/268325/db-edudist-Moodle-1.7_.rar
Moodle 1.5.3
http://moodle.org/file.php/11/moddata/forum/110/267644/Db-Edudist-Moodle1.5.3-xml.rar