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

Update qtype_match tables to match the coding guidelines

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.4.1
    • Fix Version/s: 2.5
    • Component/s: Questions
    • Labels:
    • Testing Instructions:
      Hide

      You need to test all aspects of match questions.

      1. Create, edit and delete match questions.

      2. Preview a match question.

      3. Export match questions as Moodle XML, and re-import and check that all the options are correctly preserved.

      4. Backup and restore a course with match questions, and check that all the settings are correctly preserved.

      5. In a Moodle 2.0 install, create a quiz including some match questions. Attempt that quiz with some student accounts. Backup the course including user data, and restore it to your master install. Verify the question definitions and attempt data is transferred correctly.

      6. In am Moodle 1.9 install, create a quiz including some match questions. Back up that course, and restore it into your master install. Verify that the question definitions are transferred correctly.

      Show
      You need to test all aspects of match questions. 1. Create, edit and delete match questions. 2. Preview a match question. 3. Export match questions as Moodle XML, and re-import and check that all the options are correctly preserved. 4. Backup and restore a course with match questions, and check that all the settings are correctly preserved. 5. In a Moodle 2.0 install, create a quiz including some match questions. Attempt that quiz with some student accounts. Backup the course including user data, and restore it to your master install. Verify the question definitions and attempt data is transferred correctly. 6. In am Moodle 1.9 install, create a quiz including some match questions. Back up that course, and restore it into your master install. Verify that the question definitions are transferred correctly.
    • Affected Branches:
      MOODLE_24_STABLE
    • Fixed Branches:
      MOODLE_25_STABLE
    • Pull from Repository:
    • Pull Master Branch:

      Description

      • Rename table question_match -> qtype_match_options.
      • Rename table question_match_sub -> qtype_match_subquestions.
      • Rename column question -> questionid in both tables.
      • Since we have to drop and re-create the foreign key, make qtype_match_options.questionid a foreign-unique key.
      • Drop the unnecessary column qtype_match_options.subquestions.
      • Drop the unnecessary column qtype_match_subquestions.code.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:
                    Fix Release Date:
                    14/May/13