User Tools

Site Tools


schema_0_9_10

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
schema_0_9_10 [2008/11/02 17:30] danielschema_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. 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 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 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> <code sql>
Line 269: Line 275:
 ); );
 CREATE UNIQUE INDEX jobs_pk_idx ON jobs_queue(job_id); CREATE UNIQUE INDEX jobs_pk_idx ON jobs_queue(job_id);
- 
  
 CREATE SEQUENCE seq_tag_id; CREATE SEQUENCE seq_tag_id;
schema_0_9_10.1225647042.txt.gz · Last modified: 2008/11/02 17:30 by daniel