Conflux Lite upgrade guide by Indrek Jarve <indrek|at|inversion.ee>
Please send bug reports, suggestions and so on to the above address.

In general, upgrading Conflux Lite simply means writing over old module files
with new ones. However, there are certain versions that require more
work. These versions are described below:

1. Upgrading to v1.0-7 or higher from any earlier version

   Version 1.0-7 fixed a locale handing bug in the database functions,
   so you must replace these functions.

   1. Locate the SQL subfolder in the folder you installed Conflux Lite
   2. Load schemaupdate-for-pre1.0-7.sql from that folder to the conflux
      database as superuser. For example:

      psql conflux postgres < schemaupdate-for-pre1.0-7.sql

2. Upgrading to v1.0-8 or higher from any earlier version

   Version 1.0-8 fixed a trigger bug in the database functions,
   so you must replace these functions.

   1. Locate the SQL subfolder in the folder you installed Conflux Lite
   2. Load schemaupdate-for-pre1.0-8.sql from that folder to the conflux
      database as superuser. For example:

      psql conflux postgres < schemaupdate-for-pre1.0-8.sql


3. Upgrading to v1.1.0rc1 or higher from pre1.1rc1 versions

   1. Locate the SQL subfolder in the folder you installed Conflux Lite
   2. Load schemaupdate-for-pre1.1.0rc1.sql from that folder to the conflux
      database as superuser. For example:

      psql conflux postgres < schemaupdate-for-pre1.0.0rc1.sql


4. Upgrading to v1.1.0rc2 or higher from pre1.1rc2 versions

   1. Locate the SQL subfolder in the folder you installed Conflux Lite
   2. Load schemaupdate-for-pre1.1.0rc2.sql from that folder to the conflux
      database as superuser. For example:

      psql conflux postgres < schemaupdate-for-pre1.0.0rc2.sql

5. Upgrading to v1.1.0rc4 or higher from pre1.1rc4 versions

   1. Locate the SQL subfolder in the folder you installed Conflux Lite
   2. Load schemaupdate-for-pre1.1.0rc4.sql from that folder to the conflux
      database as superuser. For example:

      psql conflux postgres < schemaupdate-for-pre1.0.0rc4.sql

   3. After the install go to the lib/ folder and run convert_categories.py:
        cd <libpath>/lib/ 
        python convert_categories.py
      This will move your old discussion threads from the organization-based schema
        to the category-based schema.