Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-30799

META: Enable foreign keys in the database schema

    XMLWordPrintable

Details

    Description

      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.

      Attachments

        Issue Links

          has a non-specific relationship to

          Sub-task - Issues are sometimes broken into multiple sub-tasks. MDL-9271 XMLDB: Keys are lost when changing table settings

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-21115 Several foreign key fields defined in the install script have incorrect data types

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-16981 Referential integrity problems in the gradebook

          • Trivial - Cosmetic problem like misspelt words or misaligned text
          • Closed

          Task - A task that needs to be completed. Tasks usually refer to work that must be done outside the product. MDL-17623 Summary of Violated Foreign Key Constraints from 700+ Moodles

          • Major - Major loss of function, incorrect output
          • Closed
          has been marked as being related by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-53795 Missing logstore_standard index significantly slows backups with logs

          • Major - Major loss of function, incorrect output
          • Closed

          Improvement - An enhancement to an existing Moodle feature. MDL-71793 Extend check_database_schema to look for potentially missing foreign relations

          • Minor - Minor loss of function where workaround is possible
          • Development in progress

          Improvement - An enhancement to an existing Moodle feature. MDL-49795 Add missing Primary/Foreign Key relationships to core Moodle tables

          • Minor - Minor loss of function where workaround is possible
          • Closed
          will be (partly) resolved by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-20437 When I set $foreign_keys=true in in sql_generator.php, the ddl is not created.

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-21116 When uninstalling a block the tables in install.xml should be dropped in reverse order

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Activity

            People

              avimoto Avi Levy
              timhunt Tim Hunt
              Votes:
              39 Vote for this issue
              Watchers:
              27 Start watching this issue

              Dates

                Created:
                Updated: