Uploaded image for project: 'DSpace'
  1. DSpace
  2. DS-437

Oracle DB Schema has artifacts from past releases

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.5.2, 1.6.0
    • Fix Version/s: 1.6.0
    • Component/s: DSpace API
    • Labels:
      None
    • Attachments:
      1
    • Comments:
      3
    • Documentation Status:
      Not Required

      Description

      The database schema defined in dspace/etc/oracle/database_schema.sql contains some artifacts that were dropped from the PostgreSQL schema in past releases. They need to be removed from Oracle's schema to bring them back to parity. They are:

      "History" table (delete it)
      "HistoryState" table (delete it)
      "mets_bitstream_id" column of "Bundle" table (delete it)

      Change "MetadataValue.text_lang" to varchar(24) to match PostgreSQL.

      Patch is forthcoming.

        Attachments

          Activity

            People

            Assignee:
            lcs Larry Stone
            Reporter:
            lcs Larry Stone
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: