Mercurial > dive4elements > river
diff 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 |
line wrap: on
line diff
--- a/flys-artifacts/doc/conf/datacage.sql Wed Aug 10 14:20:31 2011 +0000 +++ b/flys-artifacts/doc/conf/datacage.sql Wed Aug 10 14:57:12 2011 +0000 @@ -10,18 +10,20 @@ CREATE SEQUENCE COLLECTIONS_ID_SEQ; CREATE TABLE collections ( - id INT PRIMARY KEY NOT NULL, - gid UUID NOT NULL UNIQUE, - user_id INT NOT NULL REFERENCES users(id) ON DELETE CASCADE, - name VARCHAR(256) NOT NULL + id INT PRIMARY KEY NOT NULL, + gid UUID NOT NULL UNIQUE, + user_id INT NOT NULL REFERENCES users(id) ON DELETE CASCADE, + name VARCHAR(256) NOT NULL, + creation TIMESTAMP NOT NULL ); CREATE SEQUENCE ARTIFACTS_ID_SEQ; CREATE TABLE artifacts ( - id INT PRIMARY KEY NOT NULL, - gid UUID NOT NULL UNIQUE, - state VARCHAR(256) NOT NULL + id INT PRIMARY KEY NOT NULL, + gid UUID NOT NULL UNIQUE, + state VARCHAR(256) NOT NULL, + creation TIMESTAMP NOT NULL ); CREATE SEQUENCE COLLECTION_ITEMS_ID_SEQ;