Uploaded image for project: 'Kuali Rice Development'
  1. Kuali Rice Development
  2. KULRICE-6303

Apply KRMS Master Database changes - compound proposition sequence number mods.

    Details

    • Type: Task
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.0.0-b3
    • Fix Version/s: 2.0.0-b4, 2.0
    • Component/s: Database
    • Security Level: Public (Public: Anyone can view)
    • Labels:
      None
    • Rice Module:
      KRMS
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required

      Description

      Updates the KRMS data model. Moves the compound proposition sequence number from the join table to the proposition table krms_prop_t.

      Also corrects erroneous fields values in current krms test data.

      Please apply the following script (mysql-1011-12-07.sql) to the master database.
      The script has been tested with MySQL. There is an identical oracle version of the script that has NOT been tested.

      – correct fields in krms test data
      update krms_prop_t set cmpnd_op_cd = '&' where cmpnd_op_cd = 'a';
      update krms_cmpnd_prop_props_t set seq_no = '2' where prop_id = 'P421C';
      update krms_cmpnd_prop_props_t set seq_no = '3' where prop_id = 'P421D';
      update krms_cmpnd_prop_props_t set seq_no = '3' where prop_id = 'P502C';

      – move seq_no column from krms_cmpnd_prop_props_t pivot table to krms_prop_t table.
      alter table krms_prop_t add column cmpnd_seq_no decimal(5,0) default null;

      update krms_prop_t, krms_cmpnd_prop_props_t set krms_prop_t.cmpnd_seq_no = krms_cmpnd_prop_props_t.seq_no
      where krms_prop_t.prop_id = krms_cmpnd_prop_props_t.prop_id;

      alter table krms_cmpnd_prop_props_t drop seq_no;

        Attachments

          Activity

          Hide
          gilesp Peter Giles (Inactive) added a comment -

          – Applied to master db using the following SQL:

          update krms_prop_t set cmpnd_op_cd = '&' where cmpnd_op_cd = 'a';
          update krms_cmpnd_prop_props_t set seq_no = '2' where prop_id = 'P421C';
          update krms_cmpnd_prop_props_t set seq_no = '3' where prop_id = 'P421D';
          update krms_cmpnd_prop_props_t set seq_no = '3' where prop_id = 'P502C';

          alter table krms_prop_t add (cmpnd_seq_no decimal(5,0) default null);

          update krms_prop_t set krms_prop_t.cmpnd_seq_no = (select seq_no from krms_cmpnd_prop_props_t where prop_id = krms_prop_t.prop_id);

          alter table krms_cmpnd_prop_props_t drop (seq_no);

          Show
          gilesp Peter Giles (Inactive) added a comment - – Applied to master db using the following SQL: update krms_prop_t set cmpnd_op_cd = '&' where cmpnd_op_cd = 'a'; update krms_cmpnd_prop_props_t set seq_no = '2' where prop_id = 'P421C'; update krms_cmpnd_prop_props_t set seq_no = '3' where prop_id = 'P421D'; update krms_cmpnd_prop_props_t set seq_no = '3' where prop_id = 'P502C'; alter table krms_prop_t add (cmpnd_seq_no decimal(5,0) default null); update krms_prop_t set krms_prop_t.cmpnd_seq_no = (select seq_no from krms_cmpnd_prop_props_t where prop_id = krms_prop_t.prop_id); alter table krms_cmpnd_prop_props_t drop (seq_no);
          Hide
          gilesp Peter Giles (Inactive) added a comment -

          Committed script changes to scripts/upgrades/1.0.3 to 2.0.0/db-updates/2011-12-07.sql. Still need to add notes to Beta to beta impacting changes wiki page.

          Show
          gilesp Peter Giles (Inactive) added a comment - Committed script changes to scripts/upgrades/1.0.3 to 2.0.0/db-updates/2011-12-07.sql. Still need to add notes to Beta to beta impacting changes wiki page.
          Hide
          riceci Rice-CI User (Inactive) added a comment -

          Integrated in rice-trunk-nightly #276 (See http://ci.rice.kuali.org/job/rice-trunk-nightly/276/)
          KULRICE-6303: Apply KRMS Master Database changes - compound proposition sequence number mods.

          Fixing for PL/SQL.

          Show
          riceci Rice-CI User (Inactive) added a comment - Integrated in rice-trunk-nightly #276 (See http://ci.rice.kuali.org/job/rice-trunk-nightly/276/ ) KULRICE-6303 : Apply KRMS Master Database changes - compound proposition sequence number mods. Fixing for PL/SQL.
          Hide
          jcoltrin Jessica Coltrin (Inactive) added a comment -

          Closing since these items are now in the release notes.

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

            People

            • Assignee:
              gilesp Peter Giles (Inactive)
              Reporter:
              dsiebert Daniel Seibert (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Due:
                Created:
                Updated:
                Resolved: