Kuali Rice Development
  1. Kuali Rice Development
  2. KULRICE-8370

Apply KULRICE-8300 database scripts to the 2.1.2 master database

    Details

    • Type: Task Task
    • Status: Closed Closed
    • Priority: Blocker Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.1.2
    • Fix Version/s: 2.1.2
    • Component/s: Database
    • Security Level: Public (Public: Anyone can view)
    • Labels:
      None
    • Similar issues:
      KULRICE-8402Apply database scripts to the 2.1 and 2.2 master databases
      KULRICE-8411Apply database scripts to the 2.1 and 2.2 master databases
      KULRICE-8447Apply Backdoor Restriction database scripts to the 2.1 and 2.2 master databases
      KULRICE-8462Apply database scripts to the 2.1 and 2.2 mysql master databases
      KULRICE-8552Apply populate group database scripts to the 2.1 and 2.2 master databases
      KULRICE-10180Database changes for KULRICE-10175
      KULRICE-8592Apply Completion Action Requested database scripts to the 2.1 master database
      KULRICE-9001Rice 2.2.0 database upgrade scripts omitted 2.1.2 changes
      KULRICE-9266Apply ActionList test data scripts to Master db
      KULRICE-5042Apply edoclite-related database and XML updates to master database
    • Rice Module:
      KIM
    • Application Requirement:
      Rice
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required

      Description

      Can you please apply the following database scripts to the master database for 2.1.2? The database scripts are on the rice-2.1-kfs branch.

      NOTE - This is the first time that the master database will have KRxxx as the IDs on some of it's tables. The SQL accounts for that and is error free.

      Listed as blocker since KULRICE-8300 is a blocker

        Issue Links

          Activity

          Hide
          Shannon Hess added a comment -

          Peter,

          I was able to get both the oracle and mysql scripts to run without errors or warnings. This is the first time I've requested a change to a master database, so if there is anything I need to do differently just let me know.

          Thanks,
          Shannon

          Show
          Shannon Hess added a comment - Peter, I was able to get both the oracle and mysql scripts to run without errors or warnings. This is the first time I've requested a change to a master database, so if there is anything I need to do differently just let me know. Thanks, Shannon
          Hide
          Shannon Hess added a comment -

          Peter,

          Since we may start hard coding the IDs, it would be good if you could hold off on this JIRA until after a final decision is made. If we go with hardcoding starting with ID KR1000, I can update the database scripts before you apply them to the master database.

          Thanks,
          Shannon

          Show
          Shannon Hess added a comment - Peter, Since we may start hard coding the IDs, it would be good if you could hold off on this JIRA until after a final decision is made. If we go with hardcoding starting with ID KR1000, I can update the database scripts before you apply them to the master database. Thanks, Shannon
          Hide
          Shannon Hess added a comment -

          Per the discussion in the rice stand up today, I updated 2012-09-26.sql and mysql-2012-09-26.sql with hard coded IDs on the rice-2.1-kfs branch so these changes can be applied to the master database.

          Thanks,
          Shannon

          Show
          Shannon Hess added a comment - Per the discussion in the rice stand up today, I updated 2012-09-26.sql and mysql-2012-09-26.sql with hard coded IDs on the rice-2.1-kfs branch so these changes can be applied to the master database. Thanks, Shannon
          Hide
          Peter Giles (Inactive) added a comment -

          Applied to both the 2.1 and 2.2 master DBs

          Show
          Peter Giles (Inactive) added a comment - Applied to both the 2.1 and 2.2 master DBs
          Hide
          Jessica Coltrin (Inactive) added a comment -

          closing all 2.1.2 Jiras

          Show
          Jessica Coltrin (Inactive) added a comment - closing all 2.1.2 Jiras

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Structure Helper Panel