Mercurial > lada > lada-server
comparison db_schema/stammdaten_schema.sql @ 1025:8e5dcf7156c5 schema-update
Added table betriebsart
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Mon, 04 Jul 2016 14:30:40 +0200 |
| parents | 5fdc6feabedb |
| children | b29098d201c2 |
comparison
equal
deleted
inserted
replaced
| 1024:2fb787017b7f | 1025:8e5dcf7156c5 |
|---|---|
| 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 betriebsart ( | |
| 114 id serial PRIMARY KEY, | |
| 115 name character varying(30) NOT NULL | |
| 116 ); | |
| 117 INSERT INTO betriebsart VALUES(0, 'Normal-/Routinebetrieb'); | |
| 118 INSERT INTO betriebsart VALUES(1, 'Störfall-/Intensivbetrieb'); | |
| 119 | |
| 120 | |
| 113 CREATE TABLE staat ( | 121 CREATE TABLE staat ( |
| 114 id serial PRIMARY KEY, | 122 id serial PRIMARY KEY, |
| 115 staat character varying(50) NOT NULL, | 123 staat character varying(50) NOT NULL, |
| 116 hkl_id smallint NOT NULL, | 124 hkl_id smallint NOT NULL, |
| 117 staat_iso character varying(2) NOT NULL, | 125 staat_iso character varying(2) NOT NULL, |