changeset 997:1f23867d69e9 schema-update

Removed duplicated defaults.
author Raimund Renkert <raimund.renkert@intevation.de>
date Fri, 01 Jul 2016 18:07:33 +0200
parents f77a9e85b122
children c22a99d5c6f1
files db_schema/lada_schema.sql
diffstat 1 files changed, 0 insertions(+), 66 deletions(-) [+]
line wrap: on
line diff
--- a/db_schema/lada_schema.sql	Fri Jul 01 18:04:21 2016 +0200
+++ b/db_schema/lada_schema.sql	Fri Jul 01 18:07:33 2016 +0200
@@ -445,83 +445,6 @@
 
 
 --
--- Name: datum; Type: DEFAULT; Schema: land; Owner: -
---
-
-ALTER TABLE ONLY status_protokoll ALTER COLUMN datum SET DEFAULT now();
-
-
---
--- Name: datum; Type: DEFAULT; Schema: land; Owner: -
---
-
-ALTER TABLE ONLY kommentar_m ALTER COLUMN datum SET DEFAULT now();
-
-
---
--- Name: datum; Type: DEFAULT; Schema: land; Owner: -
---
-
-ALTER TABLE ONLY kommentar_p ALTER COLUMN datum SET DEFAULT now();
-
-
---
--- Name: fertig; Type: DEFAULT; Schema: land; Owner: -
---
-
-ALTER TABLE ONLY messung ALTER COLUMN fertig SET DEFAULT false;
-
-
---
--- Name: letzte_aenderung; Type: DEFAULT; Schema: land; Owner: -
---
-
-ALTER TABLE ONLY messung ALTER COLUMN letzte_aenderung SET DEFAULT now();
-
-
---
--- Name: grenzwertueberschreitung; Type: DEFAULT; Schema: land; Owner: -
---
-
-ALTER TABLE ONLY messwert ALTER COLUMN grenzwertueberschreitung SET DEFAULT false;
-
-
---
--- Name: letzte_aenderung; Type: DEFAULT; Schema: land; Owner: -
---
-
-ALTER TABLE ONLY messwert ALTER COLUMN letzte_aenderung SET DEFAULT now();
-
-
---
--- Name: letzte_aenderung; Type: DEFAULT; Schema: land; Owner: -
---
-
-ALTER TABLE ONLY ortszuordnung ALTER COLUMN letzte_aenderung SET DEFAULT now();
-
-
---
--- Name: datum; Type: DEFAULT; Schema: land; Owner: -
---
-
-ALTER TABLE ONLY status_protokoll ALTER COLUMN datum SET DEFAULT now();
-
-
---
--- Name: tree_modified; Type: DEFAULT; Schema: land; Owner: -
---
-
-ALTER TABLE ONLY status_protokoll ALTER COLUMN tree_modified SET DEFAULT now();
-
-
---
--- Name: letzte_aenderung; Type: DEFAULT; Schema: land; Owner: -
---
-
-ALTER TABLE ONLY zusatz_wert ALTER COLUMN letzte_aenderung SET DEFAULT now();
-
-
---
 -- Name: messwert_messungs_id_messgroesse_id_key; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
 --
 
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)