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 revision Previous revision
Last revision Both sides next revision
schema_0_9_10 [2008/11/02 18:30]
daniel
schema_0_9_10 [2008/11/02 19:20]
daniel
Line 1: Line 1:
 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 272:
 ); );
 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.txt ยท Last modified: 2008/11/02 23:30 by daniel