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

Remove old tables from ddl directories, add drop statements to upgrade script

    Details

    • Type: Task Task
    • Status: Closed Closed
    • Priority: Trivial Trivial
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.9.2
    • Component/s: Database
    • Labels:
      None
    • Similar issues:
      KULRICE-6359Remove old upgrade directories from the scripts sub directory
      KULRICE-1396Add DDL for rule expression enhancements to upgrade script
      KULRICE-7448Database upgrade scripts should not drop tables
      KULRICE-2874Drop KRNS_DOC_TYP_T from the Rice databases
      KULRICE-2371Drop SH_NTE_TC1 constraint on Notes table
      KULRICE-3444DB migration from the old workflow-based tables
      KULRICE-2263Drop old user tables
      KULRICE-2482Drop old tables from rice094dba schema
      KULRICE-2434Clean up the old bootstrap DDL and scripts
      KULRICE-2621Remove old fields from data dictionary related to Document Type merge, KIM work, etc., create a script which will remove them from data dictionary files

      Description

      The following tables are no longer being used:

      EN_CACHE_SERVER_T
      EN_DIRTY_CACHE_T
      EN_MESSAGE_QUE_T
      EN_SERVICE_DEF_T
      EN_SERVICE_DEF_INTER_T
      EN_TRANSACTION_TST_ADDRS_T
      EN_TRANSACTION_TST_PRSN_T

      Let's remove the DDL files and add drop statements to our upgrade script.

        Issue Links

          Activity

          Hide
          Aaron Godert (Inactive) added a comment -

          Once again George, if you have any questions, please consult with Eric on this. Thanks.

          Show
          Aaron Godert (Inactive) added a comment - Once again George, if you have any questions, please consult with Eric on this. Thanks.
          Hide
          Aaron Godert (Inactive) added a comment -

          Remove all files associated with these (DDL, indexes, constraints, etc).

          Show
          Aaron Godert (Inactive) added a comment - Remove all files associated with these (DDL, indexes, constraints, etc).
          Hide
          Aaron Godert (Inactive) added a comment -

          Add to upgrade script as well.

          Show
          Aaron Godert (Inactive) added a comment - Add to upgrade script as well.
          Hide
          George Lindholm (Inactive) added a comment -

          Hi Eric,
          I've removed the DDL files and updated the upgrade script, but
          I haven't run dball.

          What about these other references to these tables?

          kew/src/main/config/sql/

          {drop_master_workflow_sql.sql,drop_workflow_tables.sql,kew-master.ddl}

          kew/src/main/config/upgrades//
          kew/src/test/java/edut/iu/uis/eden/test/TesUtilities.java
          kns/src/test/resources/db/derby/kns.sql
          testharness/src/test/resouces/db/derby/testharness.sql

          Show
          George Lindholm (Inactive) added a comment - Hi Eric, I've removed the DDL files and updated the upgrade script, but I haven't run dball. What about these other references to these tables? kew/src/main/config/sql/ {drop_master_workflow_sql.sql,drop_workflow_tables.sql,kew-master.ddl} kew/src/main/config/upgrades/ / kew/src/test/java/edut/iu/uis/eden/test/TesUtilities.java kns/src/test/resources/db/derby/kns.sql testharness/src/test/resouces/db/derby/testharness.sql
          Hide
          Eric Westfall added a comment -

          I ran dball a little bit ago as part of the work I was doing on the upgrade script. As far as the other references:

          kew/src/main/config/sql/

          {drop_master_workflow_sql.sql,drop_workflow_tables.sql,kew-master.ddl}

          - I removed these (see linked KULRICE-1568)
          kew/src/main/config/upgrades// - go ahead and leave this for now, I think we probably need to consolidate the 0.9.1 and 0.9.2 sections under here into the scripts/upgrades location
          kew/src/test/java/edut/iu/uis/eden/test/TesUtilities.java - the referencing code wasn't actually being used, i removed it
          kns/src/test/resources/db/derby/kns.sql and estharness/src/test/resouces/db/derby/testharness.sql - don't worry about these, they will be obsoleted once JPA materializes

          So, I think everything looks good for this one to be closed

          Show
          Eric Westfall added a comment - I ran dball a little bit ago as part of the work I was doing on the upgrade script. As far as the other references: kew/src/main/config/sql/ {drop_master_workflow_sql.sql,drop_workflow_tables.sql,kew-master.ddl} - I removed these (see linked KULRICE-1568 ) kew/src/main/config/upgrades/ / - go ahead and leave this for now, I think we probably need to consolidate the 0.9.1 and 0.9.2 sections under here into the scripts/upgrades location kew/src/test/java/edut/iu/uis/eden/test/TesUtilities.java - the referencing code wasn't actually being used, i removed it kns/src/test/resources/db/derby/kns.sql and estharness/src/test/resouces/db/derby/testharness.sql - don't worry about these, they will be obsoleted once JPA materializes So, I think everything looks good for this one to be closed
          Hide
          Ailish Byrne added a comment -

          just fyi - we have a parm to add today as part of the "ability to turn off direct inquiries"

          Show
          Ailish Byrne added a comment - just fyi - we have a parm to add today as part of the "ability to turn off direct inquiries"
          Hide
          Eric Westfall added a comment -

          Thanks, I'll be sure to re-run dball once KULRICE-1513 is closed.

          Show
          Eric Westfall added a comment - Thanks, I'll be sure to re-run dball once KULRICE-1513 is closed.

            People

            • Assignee:
              George Lindholm (Inactive)
              Reporter:
              Eric Westfall
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 1 hour
                1h
                Remaining:
                Remaining Estimate - 1 hour
                1h
                Logged:
                Time Spent - Not Specified
                Not Specified

                  Structure Helper Panel