Mercurial > lada > lada-server
diff 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 |
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql Mon Jul 04 14:23:59 2016 +0200 +++ b/db_schema/stammdaten_schema.sql Mon Jul 04 14:30:40 2016 +0200 @@ -110,6 +110,14 @@ ); +CREATE TABLE betriebsart ( + id serial PRIMARY KEY, + name character varying(30) NOT NULL +); +INSERT INTO betriebsart VALUES(0, 'Normal-/Routinebetrieb'); +INSERT INTO betriebsart VALUES(1, 'Störfall-/Intensivbetrieb'); + + CREATE TABLE staat ( id serial PRIMARY KEY, staat character varying(50) NOT NULL,