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

Improve customfield table schema foreign key field nullability

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Unresolved
    • Icon: Minor Minor
    • None
    • 4.5
    • General
    • None
    • MOODLE_405_STABLE

      See the following fields (each of which are foreign keys) that define themselves as nullable:

      1. customfield_category.contextid;
      2. customfield_field.categoryid - this can be ignored, handlers may not support categories;
      3. customfield_data.contextid

      Investigate whether they should be nullable or not. In the first case (the customfield_category table) - ensure we cleanup any currently null data that may exist

      Found while looking at MDL-83094

            Unassigned Unassigned
            pholden Paul Holden
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.