log db_schema/lada_schema.sql @ 1006:599bd9462e62 schema-update

age author description
Mon, 04 Jul 2016 08:52:13 +0200 Raimund Renkert Removed duplicated netzbetreiber column. (mst_id already contains the schema-update
Fri, 01 Jul 2016 19:53:56 +0200 Raimund Renkert Moved comments to the end of the file. schema-update
Fri, 01 Jul 2016 19:51:41 +0200 Raimund Renkert Added index for "child"-tables and removed index for probe. schema-update
Fri, 01 Jul 2016 19:47:21 +0200 Raimund Renkert Moved messung.status FK constraint. schema-update
Fri, 01 Jul 2016 19:46:11 +0200 Raimund Renkert Updated trigger and functions. schema-update
Fri, 01 Jul 2016 19:04:49 +0200 Raimund Renkert Moved trigger creation to table definition. schema-update
Fri, 01 Jul 2016 19:01:32 +0200 Raimund Renkert Moved FK constraints into table definition. schema-update
Fri, 01 Jul 2016 18:17:23 +0200 Raimund Renkert Reordered table creation to allow inline definition of FKs. schema-update
Fri, 01 Jul 2016 18:11:48 +0200 Raimund Renkert Moved unique constraints into table definition. schema-update
Fri, 01 Jul 2016 18:07:33 +0200 Raimund Renkert Removed duplicated defaults. schema-update
Fri, 01 Jul 2016 18:04:21 +0200 Raimund Renkert Declare primary keys in tabel definition. schema-update
Fri, 01 Jul 2016 18:00:29 +0200 Raimund Renkert Removed obsolete search_path statements. schema-update
Fri, 01 Jul 2016 17:59:24 +0200 Raimund Renkert Replaced explicit sequences by serials. schema-update
Fri, 01 Jul 2016 17:46:39 +0200 Raimund Renkert Replaced translation tables for probe and messung with id_alt columns. schema-update
Fri, 01 Jul 2016 17:39:12 +0200 Raimund Renkert Removed schema 'bund'. schema-update
Fri, 01 Jul 2016 17:36:06 +0200 Tom Gottfried Make ID for Messregime an integer.
Fri, 01 Jul 2016 14:18:00 +0200 Tom Gottfried Complement mandatory fields for messprogramm.
Fri, 29 Apr 2016 16:40:26 +0200 Raimund Renkert merged.
Fri, 29 Apr 2016 16:38:33 +0200 Raimund Renkert Use databse triggers for update on field 'letzteAenderung'.
Fri, 15 Apr 2016 10:18:24 +0200 Tom Gottfried Added missing UNIQUE-Constraint.
Fri, 08 Apr 2016 17:17:06 +0200 Tom Gottfried We need a wider range to allow arbitrary input formated +-9.99e+-99
Wed, 23 Mar 2016 18:52:09 +0100 Tom Gottfried probe and messprogramm always need a mst_id and labor_mst_id.
Wed, 23 Mar 2016 13:07:11 +0100 Tom Gottfried Improve readability of DDL for messprogramm table.
Wed, 23 Mar 2016 12:47:16 +0100 Tom Gottfried Improve readability of DDL for probe tables.
Mon, 14 Mar 2016 10:18:24 +0100 Raimund Renkert Added labor_mst_id column to messprogramm.
Fri, 05 Feb 2016 17:01:28 +0100 Tom Gottfried Reorganise database setup scripts.
Wed, 27 Jan 2016 14:49:19 +0100 Raimund Renkert Updated db schema for filter queries.
Fri, 18 Dec 2015 17:32:30 +0100 Raimund Renkert Fixed database function.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)