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 ( |