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

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

    Details

    • Type: Task Task
    • Status: Closed Closed
    • Priority: Critical 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
    • Similar issues:
      KULRICE-13959PropositionBo's compound sequence number should default to 1 in the database
      KULRICE-6000sequence number column in join table between parent and child propositions breaks agenda persistence
      KULRICE-13315KRMS compound proposition AND/OR toggles not staying synced
      KULRICE-8411Apply database scripts to the 2.1 and 2.2 master databases
      KULRICE-10180Database changes for KULRICE-10175
      KULRICE-6432Apply Database changes for Proposition validation
      KULRICE-8168KRMS Agenda Editor: Gear icon of Compound Proposition doesn't align correctly.
      KULRICE-5203Apply pending krms ddl changes
      KULRICE-8552Apply populate group database scripts to the 2.1 and 2.2 master databases
      KULRICE-3719Create a 1.0.1.1 master database
    • 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;

        Activity

        Hide
        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
        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
        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
        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
        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
        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
        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:
            Daniel Seibert (Inactive)
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Due:
              Created:
              Updated:
              Resolved:

              Structure Helper Panel