schema_0_9_10
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
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. | Below is the SQL script for PostgreSQL that creates from scratch all the database objects. | ||
- | Before running it through psql, the preconditions | + | Before running it through psql, those preconditions |
* The database should exist and have UTF8 encoding ('' | * The database should exist and have UTF8 encoding ('' | ||
* The plpgsql language should be enabled ('' | * The plpgsql language should be enabled ('' | ||
+ | * 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:// | ||
<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