diff db_schema/stammdaten_schema.sql @ 965:ad69878b7280

Authorize status change only for matching user. Matching means belonging to the MessStelle respectively Netzbetreiber of the probe.
author Tom Gottfried <tom@intevation.de>
date Wed, 01 Jun 2016 15:25:08 +0200
parents 379480a94c81
children 69b954343acc
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql	Mon May 30 16:11:24 2016 +0200
+++ b/db_schema/stammdaten_schema.sql	Wed Jun 01 15:25:08 2016 +0200
@@ -140,7 +140,7 @@
 
 CREATE TABLE mess_stelle (
     id character varying(5) PRIMARY KEY,
-    netzbetreiber_id character varying(2),
+    netzbetreiber_id character varying(2) NOT NULL,
     beschreibung character varying(300),
     mess_stelle character varying(60),
     mst_typ character varying(1),
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)