3.0 Sprint 22

1. Sprint Release

3.0 - Sprint 22
Release date – Apr 24, 2017

3. Deliverables

Database Changes: (Relevant only for upgrades)

Oracle : https://github.com/openlibraryenvironment/ole/blob/3.0-Sprint-22/ole-app/ole-db/ole-sql/ole-liquibase-upgrade-sql/src/main/resources/org/kuali/ole/sql/oracle/3.0.sql

MySQL : https://github.com/openlibraryenvironment/ole/blob/3.0-Sprint-22/ole-app/ole-db/ole-sql/ole-liquibase-upgrade-sql/src/main/resources/org/kuali/ole/sql/mysql/3.0.sql

In 3.0 Sprint 16, For JIRA OLE-9100 - Getting issue details... STATUS , OLE_DS_DELETED_BIB_T table was created with Bib_id and Date_Updated column.
In 3.0 Sprint 21, FOR JIRA OLE-9158 - Getting issue details... STATUS Using ALTER command, multiple columns and data types were added/modified which were causing problems due to the existing records in the table.

In 3.0 Sprint 22, To overcome the problems in OLE_DS_DELETED_BIB_T table,

OLE-9158

After taking backup of OLE_DS_DELETED_BIB_T

Please execute DROP TABLE OLE_DS_DELETED_BIB_T before running 3.0.sql.

Added the Create TABLE script in 3.0 Sprint 22 for the Table OLE_DS_DELETED_BIB_T

CREATE TABLE OLE_DS_DELETED_BIB_T
(
        ID NUMBER(19,0)
        , DELETED_BIB_ID VARCHAR2(11)
        , IS_BIB_DELETED VARCHAR2(1)
        , DELETED_HOLDINGS_ID VARCHAR2(11)
        , IS_HOLDINGS_DELETED VARCHAR2(1)
        , DELETED_ITEM_ID VARCHAR2(11)
        , IS_ITEM_DELETED VARCHAR2(1)
        , DATE_UPDATED TIMESTAMP
 , CONTENT CLOB
}