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 (
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)