===============
 Upgrading Nag
===============

:Last update:   $Date: 2011/01/24 18:33:11 $
:Revision:      $Revision: 1.1.8.14 $
:Contact:       nag@lists.horde.org


These are instructions to upgrade from earlier Nag versions. Please backup
your existing data before running any of the steps described below. You can't
use the updated data with your old Nag version anymore.


Upgrading Nag from 2.3.x to 2.3.7
=================================

New Experimental SQL Share Driver Support
-----------------------------------------

A new, better scaling, experimental SQL Horde_Share driver has been added in
Horde 3.3.12. This driver offers significant performance improvements over the
existing SQL driver, but it has not received the same level of testing.  In
order to make use of this driver, you must be using Horde 3.3.12 or later.

Execute the provided SQL script to add the new tables needed for this driver,
e.g.::

   mysql --user=root --password=<MySQL-root-password> <db name> < scripts/upgrades/sharesng.sql

If you want to use the new SQL Share driver, you must also execute the
provided PHP script to migrate your existing share data to the new format::

   php scripts/upgrades/convert_sql_shares_to_sqlng.php


Upgrading Nag from 2.2.x to 2.3.x
=================================

Some fields in the SQL share driver tables have been changed. Execute the
provided SQL script to update your database if you are using the native SQL
share driver.

   mysql --user=root --password=<MySQL-root-password>  <db name> < scripts/upgrades/2.2_to_2.3.sql


Upgrading Nag from 2.1.x to 2.2.x
=================================


SQL Backends
------------

A few new fields have been added to the default SQL table layout.

Execute the provided SQL script to update your data to the new Nag version,
e.g.::

   mysql --user=root --password=<MySQL-root-password> <db name> < scripts/upgrades/2.1_to_2.2.sql

You also have to execute the provided PHP script::

   php scripts/upgrades/2006-04-18_add_creator_and_assignee_fields.php


New Beta SQL Share Driver Support
---------------------------------

A new beta-level SQL Horde_Share driver has been added in Horde 3.2. This driver
offers significant performance improvements over the existing Datatree driver,
but it has not received the same level of testing, thus the beta designation.
In order to make use of this driver, you must be using Horde 3.2-RC3 or
later. The new tables needed for this driver already should have been created
by the step above.

If you want to use the new SQL Share driver, you must also execute the
provided PHP script to migrate your existing share data to the new format::

   php scripts/upgrades/convert_datatree_shares_to_sql.php


Upgrading Nag from 1.1.x to 2.0.x
=================================


SQL Backends
------------

Two new fields have been added to the default SQL table layout.  The new
``task_uid`` field provides a global unique ID to task items, the
``task_alarm`` allows you to set alarm notification on due dates.

Execute the provided SQL script to update your data to the new Nag version::

   mysql --user=root --password=<MySQL-root-password> <db name> < scripts/upgrades/1.1_to_2.0.mysql.sql


Categories
----------

Categories are now being maintained centrally for all Horde applications that
support them.  To convert the old task categories execute the provided PHP
script::

   php scripts/upgrades/2004-05-13_convert_categories_to_strings.php
