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.12 to 0.9.13.

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

-- This SQL script upgrades the database schema for manitou-mail
-- from 0.9.12 to 0.9.13 version
 
\SET ON_ERROR_STOP 1
 
BEGIN;
ALTER TABLE body DROP COLUMN textsize;
ALTER TABLE body ADD bodyhtml TEXT;
 
UPDATE runtime_info SET rt_value='0.9.13' WHERE rt_key='schema_version';
 
END;