I upgraded from 2.0.7, and found during my upgrade that the table for referencesfield was missing. I added it manually, but I'd like to know if it's correct. (It seems to work.)

The following is the lines I added to the add_header_tables.pgsql file in order to get this table.

CREATE SEQUENCE dbmail_referencesfield_idnr_seq;
CREATE TABLE dbmail_referencesfield (
       physmessage_id  INT8 NOT NULL
                       REFERENCES dbmail_physmessage(id)
                       ON UPDATE CASCADE ON DELETE CASCADE,
id INT8 DEFAULT nextval('dbmail_referencesfield_idnr_seq'),
       referencesfield VARCHAR(255) NOT NULL DEFAULT '',
       PRIMARY KEY (id)
);
CREATE UNIQUE INDEX dbmail_referencesfield_1 ON dbmail_referencesfield(physmessage_id, id);

Thanks,
-Joe

Reply via email to