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

Alter database table 'event' to store more information

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.3
    • Fix Version/s: None
    • Component/s: Calendar
    • Labels:
    • Testing Instructions:
      Hide
      Test 1
      1. Upgrade your Moodle site.
      2. Confirm the database table 'event' now contains the columns 'type' (int(4) null allowed) and 'timesort' (int(10) null allowed).
      3. Confirm the database table 'event' contains one index combining these two columns.
      Test 2
      1. Install a new Moodle site.
      2. Confirm the database table 'event' now contains the columns 'type' (int(4) null allowed) and 'timesort' (int(10) null allowed).
      3. Confirm the database table 'event' contains one index combining these two columns.
      Show
      Test 1 Upgrade your Moodle site. Confirm the database table 'event' now contains the columns 'type' (int(4) null allowed) and 'timesort' (int(10) null allowed). Confirm the database table 'event' contains one index combining these two columns. Test 2 Install a new Moodle site. Confirm the database table 'event' now contains the columns 'type' (int(4) null allowed) and 'timesort' (int(10) null allowed). Confirm the database table 'event' contains one index combining these two columns.
    • Affected Branches:
      MOODLE_33_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      MDL-57435_master
    • Sprint:
      3.3 Project Team Sprint 1

      Description

      As components will decorate the calendar events which are relevant to the myoverview block, not all of the information mentioned in the document below will need to be stored.

      We may want to use a separate table to store the information relevant to the completion of a calendar event.

      The functions to create the events must support the newly added persisted properties (sort date, etc...).

      See https://docs.moodle.org/dev/My_course_overview_improvements#Calendar_Event_API

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              markn Mark Nelson
              Reporter:
              markn Mark Nelson
              Peer reviewer:
              cameron1729
              Participants:
              Component watchers:
              Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: