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 11:44 by daniel