Installation of foreign keys

Installation of foreign keys

par Eric Richer,
Nombre de réponses : 2

Good day folks, 

maybe I am missing something here but do foreign keys really not get installed in the database when Moodle is installed?

I see some keys defined in the install.xml files but they aren't present in the DB.  Maybe this is just an installation thing and a script needs to be run afterwards?

Cheers

Moyenne des évaluations  -
En réponse à Eric Richer

Re: Installation of foreign keys

par Howard Miller,
Avatar Core developers Avatar Documentation writers Avatar Particularly helpful Moodlers Avatar Peer reviewers Avatar Plugin developers
Historically, Moodle was developed with versions of MySQL that did not support foreign keys. I'm not completely sure what the status is now... I suspect very patchy.
Moyenne des évaluations  -
En réponse à Eric Richer

Re: Installation of foreign keys

par Marcus Green,
Avatar Core developers Avatar Particularly helpful Moodlers Avatar Plugin developers Avatar Testers

You are not missing anything.  The Foreign Key information in the xml is discarded during installation along with field level comments. 

You can read more about it here

https://github.com/marcusgreen/moodle_local-sqlgenerator/wiki

And the results of my work on table relationships can be seen in this set of er diagrams 

https://www.examulator.com/er/output/relationships.html

and table descriptions.

https://www.examulator.com/er/output/index.html

The introduction page.

http://www.examulator.com/er

Moyenne des évaluations Useful (2)