All Downloads are FREE. Search and download functionalities are using the official Maven repository.

org.kuali.ole.sql.mysql.1.5.2.sql Maven / Gradle / Ivy

There is a newer version: 1.6.2
Show newest version
--  *********************************************************************
--  Update Database Script
--  *********************************************************************
--  Change Log: org/kuali/ole/1.5.2/db.changelog-20140728.xml
--  *********************************************************************

--  Lock Database
--  Changeset org/kuali/ole/1.5.2/db.changelog-20140728.xml::OLE_DS_ITEM_T::ole
ALTER TABLE ole.OLE_DS_ITEM_T ADD NUM_OF_RENEW INT NULL
/

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, LIQUIBASE) VALUES ('OLE_DS_ITEM_T', 'ole', 'org/kuali/ole/1.5.2/db.changelog-20140728.xml', NOW(), 1, '7:93503c8c1298520974abba5e9f3e2e2f', 'addColumn', '', 'EXECUTED', '3.2.0')
/

--  Changeset org/kuali/ole/1.5.2/db.changelog-20140728.xml::OLE_LOAD_KRCR_PARM_T_mysql::ole
SET sql_mode='NO_BACKSLASH_ESCAPES'
/

INSERT INTO KRCR_PARM_T (NMSPC_CD, CMPNT_CD, PARM_NM, OBJ_ID, VER_NBR, PARM_TYP_CD, VAL, PARM_DESC_TXT, EVAL_OPRTR_CD, APPL_ID) VALUES ('OLE-DLVR', 'Deliver', 'ITEM_STATUS_FOR_RET_LOAN', 'OLE6516', '1', 'CONFG', 'LOANED|LOST', 'This is for retrieving all the item', 'A', 'OLE')
/

INSERT INTO KRCR_PARM_T (NMSPC_CD, CMPNT_CD, PARM_NM, OBJ_ID, VER_NBR, PARM_TYP_CD, VAL, PARM_DESC_TXT, EVAL_OPRTR_CD, APPL_ID) VALUES ('OLE-DLVR', 'Deliver', 'MY_ACCOUNT_URL', 'OLE6517', '1', 'CONFG', 'http://dev.ole.kuali.org/olefs/portal.do?channelTitle=MyAccount&channelUrl=http://dev.ole.kuali.org/olefs/ole-kr-krad/myaccountcontroller?viewId=RenewalItemView&methodToCall=start', 'This is for retrieving all the item', 'A', 'OLE')
/

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, LIQUIBASE) VALUES ('OLE_LOAD_KRCR_PARM_T_mysql', 'ole', 'org/kuali/ole/1.5.2/db.changelog-20140728.xml', NOW(), 2, '7:795d4698003fdc79397a04348d234d88', 'sql, loadData', '', 'EXECUTED', '3.2.0')
/

--  Release Database Lock
--  Release Database Lock




© 2015 - 2024 Weber Informatics LLC | Privacy Policy