Where is the PostgreSQL Database Schema publicised?

Where is the PostgreSQL Database Schema publicised?

oleh Matthew Willis -
Jumlah balasan: 2
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?
Rata-rata penilaian: -
Sebagai balasan Matthew Willis

Re: Where is the PostgreSQL Database Schema publicised?

oleh Marcus Green -
Gambar dari Core developers Gambar dari Particularly helpful Moodlers Gambar dari Plugin developers Gambar dari Testers

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.

http://www.examulator.com/er

That site also includes all of the xml in a single page here

http://www.examulator.com/er/xml/all_tables.html

Rata-rata penilaian:Useful (1)