Differences

This shows you the differences between two versions of the page.

--- schema_0_9_10 [2008/11/02 17:30] – daniel
+++ schema_0_9_10 [2008/11/02 22:30] (current) – daniel
@@ Line 1: / Line 1: @@
+====== Schema creation script ======
 Below is the SQL script for PostgreSQL that creates from scratch all the database objects.
-Before running it through psql, the preconditions are:
+Before running it through psql, those preconditions should be met:
   * The database should exist and have UTF8 encoding (''createdb -E UTF8 name_of_database'' in shell or ''CREATE DATABASE name_of_database ENCODING 'UTF8''' under psql)
   * The plpgsql language should be enabled (''createlang -d name_of_database plpgsql'' external command or ''CREATE LANGUAGE plpgsql'' under psql)
+  * The current directory should contain the SQL files that are referenced at the end of the script. These are the definitions of plpgsql functions.
+This script as well as all the SQL files are available in [[http://www.manitou-mail.org/source/manitou-sql-0.9.10.tar.gz]]
 <code sql>
@@ Line 269: / Line 275: @@
 );
 CREATE UNIQUE INDEX jobs_pk_idx ON jobs_queue(job_id);
 CREATE SEQUENCE seq_tag_id;