Details

    • Type: Task Task
    • Status: Closed Closed
    • Priority: Blocker Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.0.0-rc1, 2.0
    • Component/s: Database
    • Security Level: Public (Public: Anyone can view)
    • Labels:
      None
    • Similar issues:
      KULRICE-8424Consolidate database scripts for release
      KULRICE-10277Prepare database upgrade scripts for the 2.3.1 release
      KULRICE-2174Create coherent database upgrade scripts for 0.9.4 release
      KULRICE-8611validate, consolidate, and test DB upgrade scripts
      KULRICE-8942Roll up and test database upgrade scripts in preparation for release of 2.1.3
      KULRICE-8943Roll up and test database upgrade scripts in preparation for release of 2.2.1
      KULRICE-8757Roll up and test database upgrade scripts in preparation for release
      KULRICE-12531Verify datasets, and commit final db upgrade scripts for the Rice 2.4.0 release
      KULRICE-9447Prepare db upgrade scripts for the 2.1.6 & 2.2.4 releases
      KULRICE-7408Consolidate, verify and test SQL upgrade scripts
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required

      Description

      Prior to final release, all of the database scripts need to be consolidated into a single script.

        Issue Links

          Activity

          Hide
          Peter Giles (Inactive) added a comment - - edited

          Got oracle and mysql versions of scripts rolled up and tested, ran into many issues which I fixed, and now they working without errors for me. Roll-ups can be found in scripts/upgrades/1.0.3 to 2.0.0/final

          One thing I came upon that I wasn't able to get to was the following comment in 2011-06-17-m6.sql:

          
          --
          -- NOTE: when assembling this script for release, please merge any table rebuilds with those from 2011-04-28.sql
          --
          

          The script that this comment is in is thousands of lines long, and it was not practical for me to do the proposed merging for rc1.

          I'm going to resolve this issue and open a new Jira for doing the merging so that task can be appropriately prioritized.

          Show
          Peter Giles (Inactive) added a comment - - edited Got oracle and mysql versions of scripts rolled up and tested, ran into many issues which I fixed, and now they working without errors for me. Roll-ups can be found in scripts/upgrades/1.0.3 to 2.0.0/final One thing I came upon that I wasn't able to get to was the following comment in 2011-06-17-m6.sql: -- -- NOTE: when assembling this script for release, please merge any table rebuilds with those from 2011-04-28.sql -- The script that this comment is in is thousands of lines long, and it was not practical for me to do the proposed merging for rc1. I'm going to resolve this issue and open a new Jira for doing the merging so that task can be appropriately prioritized.
          Hide
          Jessica Coltrin (Inactive) added a comment -

          Closing since these items are now in the release notes.

          Show
          Jessica Coltrin (Inactive) added a comment - Closing since these items are now in the release notes.

            People

            • Assignee:
              Peter Giles (Inactive)
              Reporter:
              Matt Sargent
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Structure Helper Panel