Mercurial > gemma

diff schema/gemma.sql @ 577:e6c9d2da2e20

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Backed out changeset f3452ce5c056 Lookup tables will be filled from enumerations in XSD describing the respective SOAP-interfaces.
author Tom Gottfried <tom@intevation.de>
date Wed, 05 Sep 2018 19:13:37 +0200
parents ad07846b09d1
children 642df1164aca
line wrap: on
line diff
--- a/schema/gemma.sql	Wed Sep 05 18:35:49 2018 +0200
+++ b/schema/gemma.sql	Wed Sep 05 19:13:37 2018 +0200
@@ -138,6 +138,10 @@
     coverage_type varchar PRIMARY KEY
 );
 
+CREATE TABLE limiting_factors (
+    limiting_factor varchar PRIMARY KEY
+);
+
 CREATE TABLE measure_types (
     measure_type varchar PRIMARY KEY
 );
@@ -327,10 +331,6 @@
     --
     -- Bottlenecks
     --
-    CREATE TABLE limiting_factors (
-        limiting_factor varchar PRIMARY KEY
-    )
-
     -- XXX: Nullability differs between DRC (attributes marked "O") and WSDL
     -- (minOccurs=0; nillable seems to be set arbitrarily as even bottleneck_id and
     -- fk_g_fid (both mandatory, i.e. marked "M" in DRC) have nillable="true" in WSDL)