This too will be remedied in 2.1.4.
Joe Love wrote:
> 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
>
> _______________________________________________
> Dbmail mailing list
> [email protected]
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
--
________________________________________________________________
Paul Stevens mailto:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
The Netherlands________________________________http://www.nfg.nl