Database migration to 0.6.0

Print

Version 0.6.0 and up support adding a user comment to faxes (in both sent and received tables). If the read/unread state is saved in a database table (as described in Setting up YajHFC for small workgroups), this table needs 2 new columns where this comment can be saved.

Quick summary

If you are using PostgreSQL and your table is called ReadState, run the following SQL commands:

ALTER TABLE ReadState ADD COLUMN comment VARCHAR(200);
ALTER TABLE ReadState ADD COLUMN last_modified TIMESTAMP;
ALTER TABLE ReadState ALTER COLUMN isread drop not null;

Then go to Servers->(your server)->Read/unread state + comment, click Configure... and set the new fields for Comment and Last Modified.

Longer explanation

Versions starting with 0.6.0 expect the following columns to be present:

Field Data type Present before 0.6.0?
Fax file name VARCHAR(20) Yes
Read/Unread state BOOLEAN Yes
Comment VARCHAR(200) No
Last modified TIMESTAMP No

You will need to add the 2 new columns to the table.