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