Mercurial > gemma
comparison schema/gemma.sql @ 567:f3452ce5c056
Make table writable for data import
Lookup tables will probably be filled with data during import and
thus should reside in the waterway schema, which is accordingly
authorised. Touch only the one table relevant for bottlenecks here, as
other data might be handled differently. Lookup tables referenced
in out-commented columns not touched, as it is not yet clarified
whether these columns will be removed completely. countries not touched
neither, because it will be filled from different source and demo-data
should have everything necessary to start importing bottlenecks.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Tue, 04 Sep 2018 21:41:45 +0200 |
| parents | 3af7ca761f6a |
| children | ad07846b09d1 |
comparison
equal
deleted
inserted
replaced
| 566:5e45f441aed6 | 567:f3452ce5c056 |
|---|---|
| 150 survey_type varchar PRIMARY KEY | 150 survey_type varchar PRIMARY KEY |
| 151 ); | 151 ); |
| 152 | 152 |
| 153 CREATE TABLE coverage_types ( | 153 CREATE TABLE coverage_types ( |
| 154 coverage_type varchar PRIMARY KEY | 154 coverage_type varchar PRIMARY KEY |
| 155 ); | |
| 156 | |
| 157 CREATE TABLE limiting_factors ( | |
| 158 limiting_factor varchar PRIMARY KEY | |
| 159 ); | 155 ); |
| 160 | 156 |
| 161 CREATE TABLE measure_types ( | 157 CREATE TABLE measure_types ( |
| 162 measure_type varchar PRIMARY KEY | 158 measure_type varchar PRIMARY KEY |
| 163 ); | 159 ); |
| 345 FOR EACH ROW EXECUTE PROCEDURE update_date_info() | 341 FOR EACH ROW EXECUTE PROCEDURE update_date_info() |
| 346 | 342 |
| 347 -- | 343 -- |
| 348 -- Bottlenecks | 344 -- Bottlenecks |
| 349 -- | 345 -- |
| 346 CREATE TABLE limiting_factors ( | |
| 347 limiting_factor varchar PRIMARY KEY | |
| 348 ) | |
| 349 | |
| 350 -- XXX: Nullability differs between DRC (attributes marked "O") and WSDL | 350 -- XXX: Nullability differs between DRC (attributes marked "O") and WSDL |
| 351 -- (minOccurs=0; nillable seems to be set arbitrarily as even bottleneck_id and | 351 -- (minOccurs=0; nillable seems to be set arbitrarily as even bottleneck_id and |
| 352 -- fk_g_fid (both mandatory, i.e. marked "M" in DRC) have nillable="true" in WSDL) | 352 -- fk_g_fid (both mandatory, i.e. marked "M" in DRC) have nillable="true" in WSDL) |
| 353 CREATE TABLE bottlenecks ( | 353 CREATE TABLE bottlenecks ( |
| 354 bottleneck_id varchar PRIMARY KEY, | 354 bottleneck_id varchar PRIMARY KEY, |