Mercurial > lada > lada-server
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 1118:5a7488468cb2 | 1119:d1d7d684800c |
|---|---|
| 109 UNIQUE (umwelt_bereich) | 109 UNIQUE (umwelt_bereich) |
| 110 ); | 110 ); |
| 111 | 111 |
| 112 | 112 |
| 113 CREATE TABLE betriebsart ( | 113 CREATE TABLE betriebsart ( |
| 114 id serial PRIMARY KEY, | 114 id smallint PRIMARY KEY, |
| 115 name character varying(30) NOT NULL | 115 name character varying(30) NOT NULL |
| 116 ); | 116 ); |
| 117 INSERT INTO betriebsart VALUES(0, 'Normal-/Routinebetrieb'); | 117 INSERT INTO betriebsart VALUES(1, 'Normal-/Routinebetrieb'); |
| 118 INSERT INTO betriebsart VALUES(1, 'Störfall-/Intensivbetrieb'); | 118 INSERT INTO betriebsart VALUES(2, 'Störfall-/Intensivbetrieb'); |
| 119 | 119 |
| 120 | 120 |
| 121 CREATE TABLE staat ( | 121 CREATE TABLE staat ( |
| 122 id serial PRIMARY KEY, | 122 id serial PRIMARY KEY, |
| 123 staat character varying(50) NOT NULL, | 123 staat character varying(50) NOT NULL, |