====
    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.
====

/****************************************************************************************/
/*    Copyright 2005-2012 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.
/****************************************************************************************/

Work was done on the final upgrade scripts so that they run without error.
For more information please see KULRICE-7992


/******************************************************/
/*       Upgrade Process from 2.0.0 to 2.1            */
/******************************************************/

If you are upgrading a standalone or bundled Oracle database:

    1. Run FIXED-update_final_oracle.sql
    2. Once data is verified, run cleanup_final_oracle.sql to drop temporary tables created during the upgrade

If you are upgrading a standalone or bundled MySql database:

    1. Run FIXED-update_final_mysql.sql

If you are upgrading an embedded Oracle database:

    1. Run update_client_final_oracle.sql

If you are upgrading an embedded MySql database:

    1. Run update_client_final_mysql.sql


/******************************************************/
/*  What changed from the original upgrade scripts?   */
/******************************************************/

    1. Demo and sample tables were removed from the scripts, along with any corresponding data.

    2. Any temp tables that used to be created & dropped as part of the upgrade are now dropped in cleanup_final_*.sql

    3. For KRIM table unique identifiers, the id that will be used is the next highest number in the table under
       10,000.  For Example, if ids 1, 2, 6, 10001, KFS123, and KC34 exist in KRIM_PERM_T, The next row created via
       the upgrade scripts will have an id of 7.

/******************************************************/
/*    Items to Consider                               */
/******************************************************/

    1. Are you upgrading from 1.0.3?  If so, read the following:
       https://svn.kuali.org/repos/rice/branches/rice-2.1/scripts/upgrades/1.0.3 to 2.0.0/final/README.TXT
