diff flys-backend/doc/schema/postgresql-spatial.sql @ 5289:f6478773a5bb

postgresql-spatial.sql: Fixed table definition.
author Felix Wolfsteller <felix.wolfsteller@intevation.de>
date Thu, 14 Mar 2013 12:24:29 +0100
parents 170f514a4f29
children 3dc4c2798212
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql-spatial.sql	Thu Mar 14 12:24:06 2013 +0100
+++ b/flys-backend/doc/schema/postgresql-spatial.sql	Thu Mar 14 12:24:29 2013 +0100
@@ -112,8 +112,8 @@
     river_id int REFERENCES rivers(id) ON DELETE CASCADE,
     -- XXX Should we use the ranges table instead?
     name             VARCHAR(64),
-    range_id         INT REFERENCES ranges(id);
-    time_interval_id INT REFERENCES time_intervals(id);
+    range_id         INT REFERENCES ranges(id),
+    time_interval_id int REFERENCES time_intervals(id),
     projection       VARCHAR(32),
     srid	    int  NOT NULL,
     elevation_state  VARCHAR(32),

http://dive4elements.wald.intevation.org