Mercurial > gemma
comparison schema/gemma.sql @ 4628:28999c7c0c18
Fill single and multi into survey type table.
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Thu, 10 Oct 2019 17:10:14 +0200 |
| parents | 30bb2d819d57 |
| children | 66fcd898efd9 |
comparison
equal
deleted
inserted
replaced
| 4627:8f38a1bb9b79 | 4628:28999c7c0c18 |
|---|---|
| 323 | 323 |
| 324 CREATE TABLE survey_types ( | 324 CREATE TABLE survey_types ( |
| 325 survey_type varchar PRIMARY KEY | 325 survey_type varchar PRIMARY KEY |
| 326 ); | 326 ); |
| 327 | 327 |
| 328 INSERT INTO survey_types (survey_type) VALUES ('single'), ('multi'); | |
| 329 | |
| 328 CREATE TABLE coverage_types ( | 330 CREATE TABLE coverage_types ( |
| 329 coverage_type varchar PRIMARY KEY | 331 coverage_type varchar PRIMARY KEY |
| 330 ); | 332 ); |
| 331 | 333 |
| 332 CREATE TABLE limiting_factors ( | 334 CREATE TABLE limiting_factors ( |