--
-- Copyright 2005-2016 The Kuali Foundation
--
-- Licensed under the Educational Community License, Version 2.0 (the "License");
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at
--
-- http://www.opensource.org/licenses/ecl2.php
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.
--

update KRIM_PERM_T t set NM='Use Document Operation Screen' where PERM_ID = '140';
update KRIM_PERM_T t set NM='Use Java Security Management Screen' where PERM_ID = '141';
update KRIM_PERM_T t set NM='Use Message Queue Screen' where PERM_ID = '142';
update KRIM_PERM_T t set NM='Use Service Registry Screen' where PERM_ID = '143';
update KRIM_PERM_T t set NM='Use Thread Pool Screen' where PERM_ID = '144';
update KRIM_PERM_T t set NM='Use Quartz Queue Screen' where PERM_ID = '145';
update KRIM_PERM_T t set NM='Ad Hoc Review RICE Document' where PERM_ID = '146';
update KRIM_PERM_T t set NM='Administer Routing RICE Document' where PERM_ID = '147';
update KRIM_PERM_T t set NM='Blanket Approve RICE Document'	where PERM_ID = '148';
update KRIM_PERM_T t set NM='Initiate RICE Document' where PERM_ID = '149';
update KRIM_PERM_T t set NM='Assign Role' where PERM_ID = '150';
update KRIM_PERM_T t set NM='Grant Permission' where PERM_ID = '151';
update KRIM_PERM_T t set NM='Grant Responsibility' where PERM_ID = '152';
update KRIM_PERM_T t set NM='Populate Group' where PERM_ID = '155';
update KRIM_PERM_T t set NM='Copy RICE Document' where PERM_ID = '156';
update KRIM_PERM_T t set NM='Inquire Into RICE Records' where PERM_ID = '161';
update KRIM_PERM_T t set NM='Look Up RICE Records' where PERM_ID = '162';
update KRIM_PERM_T t set NM='Maintain System Parameter' where PERM_ID = '163';
update KRIM_PERM_T t set NM='Modify Batch Job' where PERM_ID = '164';
update KRIM_PERM_T t set NM='Open RICE Document' where PERM_ID = '165';
update KRIM_PERM_T t set NM='Use all RICE Screen' where PERM_ID = '166';
update KRIM_PERM_T t set NM='Cancel Document' where PERM_ID = '167';
update KRIM_PERM_T t set NM='Route Document' where PERM_ID = '168';
update KRIM_PERM_T t set NM='Take Requested Apprive Action' where PERM_ID = '170';
update KRIM_PERM_T t set NM='Take Requested FYI Action' where PERM_ID = '172';
update KRIM_PERM_T t set NM='Take Requested Acknowledge Action' where PERM_ID = '173';
update KRIM_PERM_T t set NM='Log In Kuali Portal' where PERM_ID = '174';
update KRIM_PERM_T t set NM='Edit Kuali ENROUTE Document Node Name PreRoute' where PERM_ID = '180';
update KRIM_PERM_T t set NM='Edit Kuali ENROUTE Document Route Status Code R' where PERM_ID = '181';
update KRIM_PERM_T t set NM='Full Unmask Tax Identification Number Payee ACH Document'	where PERM_ID = '183';
update KRIM_PERM_T t set NM='Add Note / Attachment Kuali Document' where PERM_ID = '259';
update KRIM_PERM_T t set NM='View Note / Attachment Kuali Document' where PERM_ID = '261';
update KRIM_PERM_T t set NM='Delete Note / Attachment Kuali Document' where PERM_ID = '264';
update KRIM_PERM_T t set NM='Use Screen XML Ingester Screen' where PERM_ID = '265';
update KRIM_PERM_T t set NM='Administer Pessimistic Locking' where PERM_ID = '289';
update KRIM_PERM_T t set NM='Save RICE Document' where PERM_ID = '290';
update KRIM_PERM_T t set NM='View Other Action List' where PERM_ID = '298';
update KRIM_PERM_T t set NM='Unrestricted Document Search' where PERM_ID = '299';
update KRIM_PERM_T t set NM='Full Unmask Tax Identification Number Person Document'	where PERM_ID = '306';
update KRIM_PERM_T t set NM='Modify Entity' where PERM_ID = '307';
update KRIM_PERM_T t set NM='Send FYI Request Kuali Document' where PERM_ID = '332';
update KRIM_PERM_T t set NM='Send Acknowledge Request Kuali Document' where PERM_ID = '333';
update KRIM_PERM_T t set NM='Send Approve Request Kuali Document' where PERM_ID = '334';
update KRIM_PERM_T t set NM='Override Entity Privacy Preferences' where PERM_ID = '378';
update KRIM_PERM_T t set NM='Look Up Rule Template'	where PERM_ID = '701';
update KRIM_PERM_T t set NM='Look Up Stylesheet' where PERM_ID = '702';
update KRIM_PERM_T t set NM='Look Up eDocLite' where PERM_ID = '703';
update KRIM_PERM_T t set NM='Look Up Rule Attribute' where PERM_ID = '707';
update KRIM_PERM_T t set NM='Look Up Parameter Component' where PERM_ID = '719';
update KRIM_PERM_T t set NM='Look Up Namespace'	where PERM_ID = '720';
update KRIM_PERM_T t set NM='Look Up Parameter Type' where PERM_ID = '721';
update KRIM_PERM_T t set NM='Inquire Into Rule Template' where PERM_ID = '801';
update KRIM_PERM_T t set NM='Inquire Into Stylesheet' where PERM_ID = '802';
update KRIM_PERM_T t set NM='Inquire Into eDocLite' where PERM_ID = '803';
update KRIM_PERM_T t set NM='Inquire Into Rule Attribute' where PERM_ID = '807';
update KRIM_PERM_T t set NM='Inquire Into Pessimistic' where PERM_ID = '814';
update KRIM_PERM_T t set NM='Inquire Into Parameter Component' where PERM_ID = '819';
update KRIM_PERM_T t set NM='Inquire Into Namespace' where PERM_ID = '820';
update KRIM_PERM_T t set NM='Inquire Into Parameter Type' where PERM_ID = '821';
update KRIM_PERM_T t set NM='Populate Group KUALI Namespace' where PERM_ID = '833';
update KRIM_PERM_T t set NM='Assign Role KUALI Namespace' where PERM_ID = '834';
update KRIM_PERM_T t set NM='Grant Permission KUALI Namespace' where PERM_ID = '835';
update KRIM_PERM_T t set NM='Grant Responsibility KUALI Namespace' where PERM_ID = '836';
update KRIM_PERM_T t set NM='Use Configuration Viewer Screen' where PERM_ID = '840';
update KRIM_PERM_T t set NM='Add Message to Route Log'	where PERM_ID = '841';

alter table KRIM_PERM_T change column NMSPC_CD NMSPC_CD varchar(40) not null;
alter table KRIM_PERM_T change column NM NM varchar(100) not null;
alter table KRIM_PERM_T add constraint krim_perm_t_tc1 unique (NM, NMSPC_CD);

alter table KRIM_RSP_T change column NMSPC_CD NMSPC_CD varchar(40) not null;
alter table KRIM_RSP_T change column NM NM varchar(100) not null;
alter table KRIM_RSP_T add constraint krim_rsp_t_tc1 unique (NM, NMSPC_CD);
