User Tools

Site Tools


schema_0_9_13_upgrade

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;
schema_0_9_13_upgrade.txt · Last modified: 2009/08/08 13:44 by daniel