Mercurial > lada > lada-server
comparison db_schema/stammdaten_schema.sql @ 1018:178ac8ee17c0 schema-update
Fixed typos.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Mon, 04 Jul 2016 12:10:44 +0200 |
| parents | dd86066d7515 |
| children | 3779455b621c 042437ce8f51 |
comparison
equal
deleted
inserted
replaced
| 1017:dd86066d7515 | 1018:178ac8ee17c0 |
|---|---|
| 103 | 103 |
| 104 CREATE TABLE umwelt ( | 104 CREATE TABLE umwelt ( |
| 105 id character varying(3) PRIMARY KEY, | 105 id character varying(3) PRIMARY KEY, |
| 106 beschreibung character varying(300), | 106 beschreibung character varying(300), |
| 107 umwelt_bereich character varying(80) NOT NULL, | 107 umwelt_bereich character varying(80) NOT NULL, |
| 108 meh_id integer REFERENCES mess_einheit | 108 meh_id integer REFERENCES mess_einheit, |
| 109 UNIQUE (umwelt_bereich); | 109 UNIQUE (umwelt_bereich) |
| 110 ); | 110 ); |
| 111 | 111 |
| 112 | 112 |
| 113 CREATE TABLE staat ( | 113 CREATE TABLE staat ( |
| 114 id serial PRIMARY KEY, | 114 id serial PRIMARY KEY, |
| 261 ); | 261 ); |
| 262 | 262 |
| 263 | 263 |
| 264 CREATE TABLE lada_user ( | 264 CREATE TABLE lada_user ( |
| 265 id serial PRIMARY KEY, | 265 id serial PRIMARY KEY, |
| 266 name character varying(80) NOT NULL | 266 name character varying(80) NOT NULL, |
| 267 UNIQUE (name); | 267 UNIQUE (name) |
| 268 ); | 268 ); |
| 269 | 269 |
| 270 | 270 |
| 271 CREATE TABLE query ( | 271 CREATE TABLE query ( |
| 272 id serial PRIMARY KEY, | 272 id serial PRIMARY KEY, |
| 428 CREATE TABLE proben_zusatz ( | 428 CREATE TABLE proben_zusatz ( |
| 429 id character varying(3) PRIMARY KEY, | 429 id character varying(3) PRIMARY KEY, |
| 430 meh_id integer REFERENCES mess_einheit, | 430 meh_id integer REFERENCES mess_einheit, |
| 431 beschreibung character varying(50) NOT NULL, | 431 beschreibung character varying(50) NOT NULL, |
| 432 zusatzwert character varying(7) NOT NULL, | 432 zusatzwert character varying(7) NOT NULL, |
| 433 eudf_keyword character varying(40) | 433 eudf_keyword character varying(40), |
| 434 UNIQUE (eudf_keyword); | 434 UNIQUE (eudf_keyword) |
| 435 ); | 435 ); |
| 436 | 436 |
| 437 | 437 |
| 438 CREATE TABLE probenart ( | 438 CREATE TABLE probenart ( |
| 439 id serial PRIMARY KEY, | 439 id serial PRIMARY KEY, |