[KULRICE-3700] Apply the modifications resulting from the addition of DataDictionarySearchableAttributeTest to the master databases Created: 11/Nov/09  Updated: 03/Nov/10  Resolved: 07/Dec/09

Status: Closed
Project: Kuali Rice Development
Component/s: Database
Affects Version/s: None
Fix Version/s: 1.0.1.1

Type: Task Priority: Major
Reporter: Chad Hagstrom Assignee: Garey Taylor
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Rely
is relied upon by KULRICE-3686 Write Data Dictionary based doc searc... Closed
Similar issues:
KULRICE-3627Apply the XSD change resulting from the event-notification-related parent issue to the master databases
KULRICE-8322Apply database updates for messages to master data source
KULRICE-3773Apply the database changes resulting from the doc search date validation fixes to the master DBs
KULRICE-8370Apply KULRICE-8300 database scripts to the 2.1.2 master database
KULRICE-11623Implement additive dataset database structure
KULRICE-8402Apply database scripts to the 2.1 and 2.2 master databases
KULRICE-8411Apply database scripts to the 2.1 and 2.2 master databases
KULRICE-8447Apply Backdoor Restriction database scripts to the 2.1 and 2.2 master databases
KULRICE-8462Apply database scripts to the 2.1 and 2.2 mysql master databases
KULRICE-6303Apply KRMS Master Database changes - compound proposition sequence number mods.

 Description   

Before KULRICE-3686 can be resolved, the following SQL needs to be executed against the master databases so that date parsing/formatting works properly with DD searchable attributes outside of the unit test context, and so that the @Ignore annotation on the DataDictionarySearchableAttributeTest class can be safely removed:

UPDATE KRNS_PARM_T SET TXT='MM/dd/yyyy;MM/dd/yyyy HH:mm:ss;MM/dd/yy;MM-dd-yy;MMddyy;MMMM dd;yyyy;MM/dd/yy HH:mm:ss;MM-dd-yy HH:mm:ss;MMddyy HH:mm:ss;MMMM dd HH:mm:ss;yyyy HH:mm:ss' WHERE NMSPC_CD='KR-NS' AND PARM_DTL_TYP_CD='All' AND PARM_NM='STRING_TO_DATE_FORMATS' AND APPL_NMSPC_CD='KUALI'
/
UPDATE KRNS_PARM_T SET TXT='MM/dd/yyyy hh:mm a;MM/dd/yyyy;MM/dd/yyyy HH:mm:ss;MM/dd/yy;MM-dd-yy;MMddyy;MMMM dd;yyyy;MM/dd/yy HH:mm:ss;MM-dd-yy HH:mm:ss;MMddyy HH:mm:ss;MMMM dd HH:mm:ss;yyyy HH:mm:ss' WHERE NMSPC_CD='KR-NS' AND PARM_DTL_TYP_CD='All' AND PARM_NM='STRING_TO_TIMESTAMP_FORMATS' AND APPL_NMSPC_CD='KUALI'
/
CREATE TABLE ACCT_DD_ATTR_DOC (
DOC_HDR_ID VARCHAR2(14),
OBJ_ID VARCHAR2(36),
VER_NBR NUMBER(14),
ACCT_NUM NUMBER(14) NOT NULL,
ACCT_OWNR VARCHAR2(50) NOT NULL,
ACCT_BAL NUMBER(16,2) NOT NULL,
ACCT_OPN_DAT DATE NOT NULL,
ACCT_STAT VARCHAR2(30) NOT NULL,
ACCT_UPDATE_DT_TM TIMESTAMP,
ACCT_AWAKE VARCHAR2(1),
CONSTRAINT ACCT_DD_ATTR_DOC_PK PRIMARY KEY (DOC_HDR_ID)
)
/

Note that the new table shown above is only needed for unit tests, meaning that table may also have to be added to a cleanup script so that non-test databases can easily remove it.



 Comments   
Comment by Garey Taylor [ 07/Dec/09 ]

Scripts have been run on the 1.0.1.1 master database.

Files have been updated and committed:
rice-1.0.1.1/scripts/dataset/bootstrap-server-dataset-cleanup.sql
rice-1.0.1.1/scripts/upgrades/1.0.1 to 1.0.1.1/db-updates/12-07-2009.sql

Generated at Mon Jul 13 15:50:07 CDT 2020 using JIRA 6.1.5#6160-sha1:a61a0fc278117a0da0ec9b89167b8f29b6afdab2.