Hi there!
I'm converting some MySQL scripts to PostgreSQL so they can run on a newly-acquired Moodle 3.3 PostgreSQL installation (via the Configurable Reports plugin). I noticed that the Moodle database schema hosted here is only for the MySQL installations. Is there a publicised PostgreSQL version of the db schema?
In reply to Matthew Willis
Re: Where is the PostgreSQL Database Schema publicised?
by Marcus Green -
Moodle installations are generated from the same XML source files so the difference between installing on MySQL and PostGres is in the SQL syntax, e.g. create table and create indexes. A scheme like the one you gave the link to that was generated from PostGres would be just about identical. You can get some visualisations of the db scheme from here.
That site also includes all of the xml in a single page here
In reply to Marcus Green
Re: Where is the PostgreSQL Database Schema publicised?
by Matthew Willis -
Ah, thanks for the info and the links - that makes a lot of sense!