Uploaded image for project: 'Red Hat 3scale API Management'
  1. Red Hat 3scale API Management
  2. THREESCALE-2298

Fix Oracle Schema for DeletedObjects

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • None
    • None
    • System
    • 2
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • 3scale 2019-04-08, 3scale 2019-04-23, 3scale 2019-05-06, 3scale 2019-05-20

    Description

      When creating a new installation from the 2.5 version of system, not everything from the Oracle DB schema is correct.

      This is the difference:

      diff --git a/db/oracle_schema.rb b/db/oracle_schema.rb
index b5b7a969..2d352951 100644
--- a/db/oracle_schema.rb
+++ b/db/oracle_schema.rb
@@ -464,11 +464,11 @@ ActiveRecord::Schema.define(version: 20190304222108) do
   add_index "countries", ["code"], name: "index_countries_on_code"

   create_table "deleted_objects", force: :cascade do |t|
-    t.integer  "owner_id",    limit: 19, precision: 19
+    t.integer  "owner_id",    precision: 38
     t.string   "owner_type"
-    t.integer  "object_id",   limit: 19, precision: 19
+    t.integer  "object_id",   precision: 38
     t.string   "object_type"
-    t.datetime "created_at",                            null: false
+    t.datetime "created_at",                 null: false
   end

      Attachments

        Issue Links

          blocks

          Sub-task - The sub-task of the issue THREESCALE-2025 Remove Account column service_prefix from code & DB

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Sub-task - The sub-task of the issue THREESCALE-2480 Remove tech_support_email and admin_support_email fields from the DB

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Sub-task - The sub-task of the issue THREESCALE-2624 Remove Account column deleted_at from the DB

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed
          causes

          Bug - A problem that impairs or prevents the functions of the product. THREESCALE-4793 Upgrade of 3scale from 2.5 to 2.6 on oracle fails

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              Unassigned Unassigned
              hramihaj Hery Ramihajamalala (Inactive)
              Marta Noya Marta Noya (Inactive)
              Marta Noya Marta Noya (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: