Loading...

XML

Word

Printable

Type: Improvement
Resolution: Unresolved
Priority: Major
Fix Version/s: DEV backlog
Affects Version/s: 2.2
Component/s: Database SQL/XMLDB
Labels:

Database:

Any
Affected Branches:
MOODLE_22_STABLE
Pull from Repository:
https://github.com/SysBind/moodle
Pull Main Branch:
MDL-30799-Master
Pull Main Diff URL:
https://github.com/SysBind/moodle/compare/MDL-30799-Master

Moodle has never had foreign keys in its database, because we started in the dark days of MySQL 3.x. It would be really nice if we could enable them. It would detect many bugs, and so make Moodle more robust. However, there are a lot of steps required on the way to achieving that.

has a non-specific relationship to

MDL-9271 XMLDB: Keys are lost when changing table settings

Closed

MDL-21115 Several foreign key fields defined in the install script have incorrect data types

Closed

MDL-16981 Referential integrity problems in the gradebook

Closed

MDL-17623 Summary of Violated Foreign Key Constraints from 700+ Moodles

Closed

has been marked as being related by

MDL-53795 Missing logstore_standard index significantly slows backups with logs

Closed

MDL-71793 Extend check_database_schema to look for potentially missing foreign relations

Development in progress

MDL-49795 Add missing Primary/Foreign Key relationships to core Moodle tables

Closed

will be (partly) resolved by

MDL-20437 When I set $foreign_keys=true in in sql_generator.php, the ddl is not created.

Closed

MDL-21116 When uninstalling a block the tables in install.xml should be dropped in reverse order

Closed

(2 has been marked as being related by, 2 will be (partly) resolved by)

1.	New flag for each install.xml file: Foreign keys are safe		Closed	Unassigned
2.	New option $CFG->foreignkeys = NONE \| SAFE \| ALL in config.php		Closed	Unassigned

Assignee:: Avi Levy

Reporter:: Tim Hunt

Participants:: Avi Levy, Daniel Neis Araujo, Dan Poltawski, Eloy Lafuente (stronk7), Jason Pyeron, Martin Dougiamas, Tim Hunt

Votes:: 40 Vote for this issue

Watchers:: 26 Start watching this issue

Created:: 20/Dec/11 3:01 AM

Updated:: 15/Oct/23 10:00 PM

Details

Description

Attachments

Issue Links

Sub-Tasks

Activity

People

Dates

Clockify