Stocktake Add-On for OpenBiblio 0.6.0
-------------------------------------

Stocktake is an inventory add-on for Openbiblio, originally written for version
0.5.x. This version is updated for version 0.6.0.

1. Unzip and apply the patch.

      unzip stocktake-0.6.0-070906.zip
      cd openbiblio
      patch -p1 < ../stocktake-0.6.0-070906.diff

   where it is assumed the stocktake patch is located one directory level above your
   openbiblio install.  You can first test the patch with

      patch -p1 --dry-run < ../stocktake-0.6.0-070906.diff

   to make sure the patch will apply cleanly.

2. Create the tables in the database.

      sed s/%prfx%/your_prefix/ install/sql/stocktake_item.sql | mysql --user=obiblio_user --password=obiblio_password your_prefixOpenBiblio
      sed s/%prfx%/your_prefix/ install/sql/stocktake.sql | mysql --user=obiblio_user --password=obiblio_password your_prefixOpenBiblio

   where your_prefix is your openbiblio database prefix, obiblio_user is your
   database username, obiblio_password is the corresponding password, and
   your_prefixOpenBiblio is your openbiblio database.

   The use of a prefix is a 'trick' to allow you to have several databases if
   your hosting company only allows you to have one.  Most users probably don't
   use a prefix so for most users these command would simply be

      sed s/%prfx%// install/sql/stocktake_item.sql | mysql --user=obiblio_user --password=obiblio_password OpenBiblio
      sed s/%prfx%// install/sql/stocktake.sql | mysql --user=obiblio_user --password=obiblio_password OpenBiblio

   where obiblio_user is your database username, obiblio_password is the
   corresponding password, and OpenBiblio is your openbiblio database.
   your_prefixOpenBiblio is your openbiblio database.

   Alternatively to piping the ouput of sed into mysql, you can edit the files
   install/sql/stocktake_item.sql and install/sql/stocktake.sql and import them
   into your openbiblio database.  Change the %prfx% on the first line of each
   file to your database prefix (or delete it if not using a prefix) and then
   import these into your database

      mysql --user=obiblio_user --password=obiblio_password your_prefixOpenBiblio < install/sql/stocktake_item.sql
      mysql --user=obiblio_user --password=obiblio_password your_prefixOpenBiblio < install/sql/stocktake.sql

   or simply

      mysql --user=obiblio_user --password=obiblio_password OpenBiblio < install/sql/stocktake_item.sql
      mysql --user=obiblio_user --password=obiblio_password OpenBiblio < install/sql/stocktake.sql

   if not using a prefix.

Matt Boytim
maboytim at yahoo dot com