Mercurial > gemma
changeset 577:e6c9d2da2e20
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 | d5626dd370a4 |
children | 61af85a432bf |
files | schema/gemma.sql schema/tap_tests_data.sql |
diffstat | 2 files changed, 5 insertions(+), 5 deletions(-) [+] |
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)
--- a/schema/tap_tests_data.sql Wed Sep 05 18:35:49 2018 +0200 +++ b/schema/tap_tests_data.sql Wed Sep 05 19:13:37 2018 +0200 @@ -17,7 +17,7 @@ INSERT INTO users.list_users VALUES ( 'sys_admin', 'test_sys_admin1', 'sys_admin1$', 'AT', NULL, 'zzz'); -INSERT INTO waterway.limiting_factors VALUES ('depth'), ('width'); +INSERT INTO limiting_factors VALUES ('depth'), ('width'); INSERT INTO waterway.gauges ( location, function_code, objname, geom, zero_point, source_organization)