Mercurial > lada > lada-server
changeset 1025:8e5dcf7156c5 schema-update
Added table betriebsart
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Mon, 04 Jul 2016 14:30:40 +0200 |
| parents | 2fb787017b7f |
| children | d77178ccbcbc |
| files | db_schema/stammdaten_schema.sql |
| diffstat | 1 files changed, 8 insertions(+), 0 deletions(-) [+] |
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,