log db_schema/stammdaten_schema.sql @ 1008:17e9d1b2d471 schema-update

age author description
Fri, 01 Jul 2016 10:32:44 +0200 Tom Gottfried Fix CHECK-Constraint definition.
Wed, 29 Jun 2016 19:23:50 +0200 Raimund Renkert Added unique constraint to result.query_id and result.data_index and fixed data
Thu, 02 Jun 2016 18:04:44 +0200 Tom Gottfried Add missing FK-constraint.
Wed, 01 Jun 2016 15:25:08 +0200 Tom Gottfried Authorize status change only for matching user.
Tue, 24 May 2016 17:15:44 +0200 Tom Gottfried Use ON DELETE CASCADE to ease removing queries from database.
Fri, 29 Apr 2016 16:38:33 +0200 Raimund Renkert Use databse triggers for update on field 'letzteAenderung'.
Fri, 08 Apr 2016 11:14:09 +0200 Tom Gottfried netzbetreiber_id is mandatory for ort.
Tue, 05 Apr 2016 10:49:13 +0200 Tom Gottfried Set netzbetreiber-specific IDs UNIQUE per netzbetreiber.
Tue, 05 Apr 2016 10:29:55 +0200 Tom Gottfried Set known mandatory fields in stammdaten NOT NULL.
Thu, 24 Mar 2016 15:57:05 +0100 Tom Gottfried Improve readability of DDL for editable stammdaten tables.
Fri, 19 Feb 2016 14:23:58 +0100 Raimund Renkert Removed column 'query_id' from filter_value table.
Mon, 15 Feb 2016 11:33:44 +0100 Tom Gottfried Allow 'editing' of status 'Rückfrage'
Thu, 11 Feb 2016 16:23:38 +0100 Tom Gottfried Available status values need to be filtered by the users functions.
Tue, 09 Feb 2016 15:11:36 +0100 Tom Gottfried Remove unused VIEWs.
Mon, 08 Feb 2016 18:31:08 +0100 Tom Gottfried Add necessary constraints for status workflow.
Mon, 08 Feb 2016 18:23:41 +0100 Tom Gottfried Status workflow definitions are needed and assumed to be given by the server.
Mon, 08 Feb 2016 13:21:42 +0100 Tom Gottfried Put status workflow definitions in one place.
Mon, 08 Feb 2016 12:45:26 +0100 Tom Gottfried Functions are needed and assumed to be given by the server.
Fri, 05 Feb 2016 18:32:03 +0100 Tom Gottfried Use inline primary key definitions and remove autogenerated comments.
Fri, 05 Feb 2016 17:03:31 +0100 Tom Gottfried Whitespace cleanup.
Fri, 05 Feb 2016 17:01:28 +0100 Tom Gottfried Reorganise database setup scripts.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)