# HG changeset patch # User Raimund Renkert # Date 1467389253 -7200 # Node ID 1f23867d69e9fd6c4761982c9753f9ba0c657682 # Parent f77a9e85b1228c780daac6d7d75c2d1a64628c7f Removed duplicated defaults. diff -r f77a9e85b122 -r 1f23867d69e9 db_schema/lada_schema.sql --- 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: --