comparison artifact-database/doc/schema-pg.sql @ 156:a76de72ad6d1

Added stubs for the collection handling in db backend. Added missing attribute column to the collection item table. artifacts/trunk@1381 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 03 Mar 2011 09:53:02 +0000
parents caf9f456f7e3
children a85d889a1b0d
comparison
equal deleted inserted replaced
155:f797093c60bd 156:a76de72ad6d1
43 43
44 CREATE TABLE collection_items ( 44 CREATE TABLE collection_items (
45 id int PRIMARY KEY NOT NULL, 45 id int PRIMARY KEY NOT NULL,
46 collection_id int NOT NULL REFERENCES collections(id), 46 collection_id int NOT NULL REFERENCES collections(id),
47 artifact_id int NOT NULL REFERENCES artifacts(id), 47 artifact_id int NOT NULL REFERENCES artifacts(id),
48 attribute BINARY,
48 UNIQUE (collection_id, artifact_id) 49 UNIQUE (collection_id, artifact_id)
49 ); 50 );
50 51
51 COMMIT; 52 COMMIT;

http://dive4elements.wald.intevation.org