Hi Ilja,
> There's a small change in the database structure. The messageblks table
> has a field called is_header, which is set to '1' if the messageblock is
> a header block. This field isn't used yet, but will be in future releases.
Could we please add a upgrade file for every database? Entries could be
date, version (dbmail and cvs version of file?) and what to do? This is
for postgres:
ALTER TABLE messageblks ADD COLUMN is_header INT2;
UPDATE messageblks SET is_header=0;
ALTER TABLE messageblks ALTER COLUMN is_header SET DEFAULT '0';
ALTER TABLE messageblks ALTER COLUMN is_header SET NOT NULL;
CREATE INDEX messageblks_physmessage_is_header_idx
ON messageblks(physmessage_id, is_header);
Thomas
--
http://www.tmueller.com for pgp key (95702B3B)
