diff flys-artifacts/doc/conf/datacage.sql @ 988:dbe39e1fb5e7

Datacage: Add collection items at initial scan. flys-artifacts/trunk@2420 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 28 Jul 2011 15:59:38 +0000
parents 8094ba4ab873
children e573c4715d81
line wrap: on
line diff
--- a/flys-artifacts/doc/conf/datacage.sql	Thu Jul 28 15:34:26 2011 +0000
+++ b/flys-artifacts/doc/conf/datacage.sql	Thu Jul 28 15:59:38 2011 +0000
@@ -24,7 +24,7 @@
     state VARCHAR(256)     NOT NULL
 );
 
-CREATE SEQUENCE COLLECTIONS_ITEMS_ID_SEQ;
+CREATE SEQUENCE COLLECTION_ITEMS_ID_SEQ;
 
 CREATE TABLE collection_items (
     id            INT PRIMARY KEY NOT NULL,
@@ -68,7 +68,7 @@
 -- DROP SEQUENCE USERS_ID_SEQ;
 -- DROP SEQUENCE COLLECTIONS_ID_SEQ;
 -- DROP SEQUENCE ARTIFACTS_ID_SEQ;
--- DROP SEQUENCE COLLECTIONS_ITEMS_ID_SEQ;
+-- DROP SEQUENCE COLLECTION_ITEMS_ID_SEQ;
 -- DROP SEQUENCE ARTIFACT_DATA_ID_SEQ;
 -- DROP SEQUENCE OUTS_ID_SEQ;
 -- DROP SEQUENCE FACETS_ID_SEQ;

http://dive4elements.wald.intevation.org