Upgrading from 4.0.1b to 4.0.1
------------------------------

1. We had to rename everything from pa_* to pl_* to avoid conflicts
   with the photo-album package.  Running the following script:

    /serverroot/packages/photo-album-lite/sql/upgrade-4.0.1b-4.0.1.sql

   will effect all of the necessary changes.  The package manager
   should correctly detect and offer to run this script.

   Be warned that this script temporarily disables the foreign key
   constraint on the object_type column in acs_objects.  Try to run
   the script off-hours and make sure not to interrupt execution.

   Should the script be interrupted for some reason you can always
   manually re-enable the constraint like so:

   SQL> alter table acs_objects enable constraint acs_objects_object_type_fk;

   This script also renames and re-enters the dbms_job that rebuilds the
   search index.  The job interval is reset to the package's default
   (every 4 hours) so you should edit the script if you want to use a
   different value.

   Also, note that the default directory for uploaded images is now

    /serverroot/pl_photos

   so you'll need to either edit the PhotoBaseDirectory parameter or rename
   the pa_photos directory to pl_photos (recommended).

2. The upgrade script also remaps your sort_n's so that they always
   start with 1 for each folder (they used to be driven off the
   photo_id).  This makes it easier to display a photo's context in
   the folder, i.e. "Photo 5 of 12".