schema_0_9_10
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Last revisionBoth sides next revision | ||
schema_0_9_10 [2008/11/02 17:30] – daniel | schema_0_9_10 [2008/11/02 18: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 | + | 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 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 22:30 by daniel