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

Compare one 1.7 clean installation DB with one 1.7 installation migrated from previous version


    • Icon: Task Task
    • Resolution: Fixed
    • Icon: Minor Minor
    • 2.0.10
    • 1.7.2
    • Installation
    • None
    • MySQL & PG
    • MySQL, PostgreSQL

      In order to be 100% sure that we haven't forgotten anything with all the new install.xml I would propose to:

      1) Make one clean install of Moodle 1.7
      2) Make one clean install of Moodle, 1.6 and upgrade it up to 1.7
      3) Compare (with phpMyAdmin) that every table/field is exactly equal and that we haven't forgotten anything, annotating all the differences found.

      It can be done in some hours and will allow us to start thinking about to drop all the old .sql files definitively (plus being 100% confident with the new tables).

      Ideally, this should be performed both under MySQL and PostgreSQL, although checking it under the first could be enough... assuming that PG is 100% up-to-date with MySQL. Your decision.

      Marked as blocker. Not sure if this is too much, but I think it's a must.

        1. 1.6-1.7.sql
          152 kB
        2. 17fresh_vs_17upgraded.diff
          149 kB
        3. diff_default.txt
          2 kB
        4. diff_indexes.txt
          3 kB
        5. diff_unsigned.txt
          2 kB
        6. diff.txt
          0.5 kB
        7. diff.txt
          4 kB
        8. diff.txt
          7 kB
        9. diff.txt
          150 kB
        10. infinite_loop.patch
          0.9 kB
        11. pg74dbstructure.zip
          27 kB
        12. udiff
          130 kB

            stronk7 Eloy Lafuente (stronk7)
            stronk7 Eloy Lafuente (stronk7)
            0 Vote for this issue
            5 Start watching this issue


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