Mercurial > dive4elements > river
comparison flys-artifacts/doc/conf/datacage.sql @ 1025:02c327ffbad7
Datacage: Extended schema for artifacts and collections
to have creation times, too.
flys-artifacts/trunk@2484 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Wed, 10 Aug 2011 14:57:12 +0000 |
parents | aabcca7aeb6c |
children | a007a4368768 |
comparison
equal
deleted
inserted
replaced
1024:ba88157c6aa3 | 1025:02c327ffbad7 |
---|---|
8 ); | 8 ); |
9 | 9 |
10 CREATE SEQUENCE COLLECTIONS_ID_SEQ; | 10 CREATE SEQUENCE COLLECTIONS_ID_SEQ; |
11 | 11 |
12 CREATE TABLE collections ( | 12 CREATE TABLE collections ( |
13 id INT PRIMARY KEY NOT NULL, | 13 id INT PRIMARY KEY NOT NULL, |
14 gid UUID NOT NULL UNIQUE, | 14 gid UUID NOT NULL UNIQUE, |
15 user_id INT NOT NULL REFERENCES users(id) ON DELETE CASCADE, | 15 user_id INT NOT NULL REFERENCES users(id) ON DELETE CASCADE, |
16 name VARCHAR(256) NOT NULL | 16 name VARCHAR(256) NOT NULL, |
17 creation TIMESTAMP NOT NULL | |
17 ); | 18 ); |
18 | 19 |
19 CREATE SEQUENCE ARTIFACTS_ID_SEQ; | 20 CREATE SEQUENCE ARTIFACTS_ID_SEQ; |
20 | 21 |
21 CREATE TABLE artifacts ( | 22 CREATE TABLE artifacts ( |
22 id INT PRIMARY KEY NOT NULL, | 23 id INT PRIMARY KEY NOT NULL, |
23 gid UUID NOT NULL UNIQUE, | 24 gid UUID NOT NULL UNIQUE, |
24 state VARCHAR(256) NOT NULL | 25 state VARCHAR(256) NOT NULL, |
26 creation TIMESTAMP NOT NULL | |
25 ); | 27 ); |
26 | 28 |
27 CREATE SEQUENCE COLLECTION_ITEMS_ID_SEQ; | 29 CREATE SEQUENCE COLLECTION_ITEMS_ID_SEQ; |
28 | 30 |
29 CREATE TABLE collection_items ( | 31 CREATE TABLE collection_items ( |