====== Update instructions ======


===== From 0.1.x to 0.1.6 =====
Between release 0.1.5 and 0.1.6-dev the database structure has changed in some parts. The table "photos" got a new column called "id" now. Plus the "UPSERT"-functions are now bound to a schema. Therefor the recommended way to update is like following:

  * Run the latest installr.pl with the latest contrib/pixlr.sql
  * Log into your PostgreSQL database
  * Remove the photos table:
    <code sql>DROP TABLE <yourschema>.photos;</code>
  * Run the SQL script that has been created by installr:
    <code sql>\i contrib/pixlr.sql</code>

That's it. Now your tables should be up-to-date. Finally run pixlrback.pl to re-insert your photos from you flickr account.
Another change from 0.1.5 to 0.1.6-dev is the possibity to decide wether you want the description to be HTML escaped or not. Therefor a new variable has been added:

  * [% DESCRIPTION %] - This variable prints the description as HTML escaped version
  * [% DESC_NONESC %] - This variable prints a non-escaped description, which makes it possible to use HTML-Tags in the text

Please adjust your template accordingly. The standard template will use escaped HTML by default.

===== From 0.1.x to 0.1.5 =====
There nothing to update so far. Simply copy the files of the new version into your Pixlr directory. All you need to adjust is the conf/pixlr.conf. This can be easily done be running installr.pl. The newly created conf/pixlr.conf.installr holds all variables that are needed. Simply compare your current pixlr.conf and the one created by installr.pl.