Manitou-Mail Wiki

This is an old revision of the document!

---

Below is the SQL script for PostgreSQL that upgrades the schema from 0.9.10 to 0.9.11.

This script as well as all the SQL files are available in http://www.manitou-mail.org/source/manitou-sql-0.9.11.tar.gz

-- This SQL script upgrades the database schema for manitou-mail
-- from 0.9.10 to 0.9.11 version
 
\SET ON_ERROR_STOP 1
 
BEGIN;
 
CREATE TABLE filter_log (
 expr_id INT,   -- No reference to filter_expr, we don't want any constraint here
 mail_id INT,   -- No reference to mail to be able to delete mail without touching this table
 hit_date timestamptz DEFAULT now()
);
 
ALTER TABLE filter_expr ADD direction CHAR(1) DEFAULT 'I';
 
ALTER TABLE attachments ADD mime_content_id text;
 
UPDATE runtime_info SET rt_value='0.9.11' WHERE rt_key='schema_version';
 
END;