Mercurial > lada > lada-server
diff db_schema/stammdaten_schema.sql @ 1119:d1d7d684800c
Switch back to 1-based id of betriebsart.
The client still assumes this and probably legacy data, too.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 28 Oct 2016 11:58:52 +0200 |
| parents | 2f42a7607bbd |
| children | b49c1fb84040 |
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql Fri Oct 28 11:07:43 2016 +0200 +++ b/db_schema/stammdaten_schema.sql Fri Oct 28 11:58:52 2016 +0200 @@ -111,11 +111,11 @@ CREATE TABLE betriebsart ( - id serial PRIMARY KEY, + id smallint PRIMARY KEY, name character varying(30) NOT NULL ); -INSERT INTO betriebsart VALUES(0, 'Normal-/Routinebetrieb'); -INSERT INTO betriebsart VALUES(1, 'Störfall-/Intensivbetrieb'); +INSERT INTO betriebsart VALUES(1, 'Normal-/Routinebetrieb'); +INSERT INTO betriebsart VALUES(2, 'Störfall-/Intensivbetrieb'); CREATE TABLE staat (