log schema/gemma.sql @ 2015:b4ba751e70a1

age author description
Tue, 29 Jan 2019 12:36:45 +0100 Tom Gottfried Fix column type to match referenced column
Thu, 24 Jan 2019 12:56:31 +0100 Tom Gottfried Move import queue to its own database namespace
Wed, 23 Jan 2019 17:59:15 +0100 Sascha L. Teichmann Merged.
Wed, 23 Jan 2019 17:58:57 +0100 Sascha L. Teichmann Imports: Made retries and the waiting between the attempts configurable.
Wed, 23 Jan 2019 17:46:50 +0100 Tom Gottfried Ensure geometries in database are valid OGC simple features
Wed, 23 Jan 2019 16:25:43 +0100 Tom Gottfried Fix area generation from multipolygon input
Wed, 23 Jan 2019 11:20:14 +0100 Sascha L. Teichmann Imports: Added the new state 'unchanged' which can be issued by the imports to indicate that the database is not modified by the particular imports.
Tue, 22 Jan 2019 18:22:57 +0100 Sascha Wilde Added view for publishing bottlenecks
Mon, 21 Jan 2019 11:44:31 +0100 Sascha L. Teichmann Better suited GeoServer view for waterway.stretches.
Fri, 18 Jan 2019 17:13:12 +0100 Sascha L. Teichmann Stretch import: Added forgotten source file.
Fri, 18 Jan 2019 12:00:59 +0100 Sascha L. Teichmann Schema: Replaced sections_stretches table with a pure stretches table.
Thu, 17 Jan 2019 13:15:22 +0100 Raimund Renkert Adjusted database schema for distance marks importer.
Wed, 16 Jan 2019 17:20:19 +0100 Tom Gottfried Remove superfluous schema qualifiers in definition of the schema itself
Wed, 16 Jan 2019 12:56:54 +0100 Sascha L. Teichmann Schema: Adjust gauges once again to be in sync with RIS index.
Wed, 16 Jan 2019 12:42:34 +0100 Sascha L. Teichmann Backed out changeset 332e42a2088d (no staging needed).
Wed, 16 Jan 2019 12:42:19 +0100 Sascha L. Teichmann Backed out changeset f1351a58da35 (no staging needed)
Wed, 16 Jan 2019 11:31:36 +0100 Sascha L. Teichmann SQL: typo fix.
Wed, 16 Jan 2019 11:28:33 +0100 Sascha L. Teichmann DB schema: Made primary key of waterway.gauges an integer for staging purposes.
Wed, 16 Jan 2019 10:36:22 +0100 Sascha Wilde Removed all unique geohash indexes as they prevent updates of data.
Fri, 11 Jan 2019 18:32:59 +0100 Sascha L. Teichmann Gauge measurements: Add an unique constraint so there could only
Fri, 11 Jan 2019 16:48:14 +0100 Sascha L. Teichmann (Approved) gauge measurement import: Fixed row level security.
Fri, 11 Jan 2019 12:10:23 +0100 Sascha L. Teichmann Gauge measurement import: Added reference_code column.
Thu, 10 Jan 2019 17:21:51 +0100 Sascha L. Teichmann Import queue: Removed auto_accept from imports table, too.
Thu, 10 Jan 2019 16:19:26 +0100 Sascha L. Teichmann Import queue: Auto acceptance is now a property of the import kind itself and is not configurable any more.
Tue, 08 Jan 2019 13:35:44 +0100 Sascha L. Teichmann Imports: Made imports re-runnable if they fail.
Mon, 07 Jan 2019 13:23:39 +0100 Sascha L. Teichmann Import configuration: [WIP] Added table for extra configuration attributes.
Thu, 27 Dec 2018 23:23:36 +0100 Sascha L. Teichmann Waterway axis: Removed unique geohash index.
Fri, 21 Dec 2018 15:56:28 +0100 Raimund Renkert Implemented first version of fairway availability import.
Thu, 20 Dec 2018 13:45:32 +0100 Sascha L. Teichmann Import queue: Implemented auto-accept and email sending.
Thu, 20 Dec 2018 12:05:30 +0100 Raimund Renkert Updated database schema for gauge meaurement imports.
Thu, 13 Dec 2018 18:37:35 +0100 Sascha L. Teichmann Added GET to /api/imports/scheduler.
Wed, 12 Dec 2018 19:21:02 +0100 Sascha L. Teichmann Made bottleneck primary key an int. Attention: This may break something!
Mon, 10 Dec 2018 15:55:10 +0100 Sascha L. Teichmann Add table to store import configuration.
Thu, 06 Dec 2018 15:37:06 +0100 Sascha Wilde Fixed date of latest measurement in bottlenecks list.
Fri, 30 Nov 2018 15:56:34 +0100 Sascha Wilde Add configuration of primary key metadata used by geoserver.
Wed, 28 Nov 2018 09:52:34 +0100 Sascha L. Teichmann Imports: An Import (e.g. a sounding result import) can now write a 'summary' of a successful import. This is done if the import switches to to state 'pending'.
Mon, 26 Nov 2018 17:14:56 +0100 Sascha L. Teichmann Removed bad trigger ... works in wrong direction.
Mon, 26 Nov 2018 15:21:34 +0100 Sascha L. Teichmann Added missing rights and fixed trigger function.
Mon, 26 Nov 2018 09:01:21 +0100 Fadi Abbud merges
Fri, 23 Nov 2018 13:46:47 +0100 Fadi Abbud add headers for licensing to some schema files
Sat, 24 Nov 2018 16:22:28 +0100 Sascha L. Teichmann Added missing copyright headers and authors in schema related files.
Fri, 23 Nov 2018 10:35:39 +0100 Fadi Abbud add headers for licensing to some schema files
Fri, 23 Nov 2018 09:35:10 +0100 Fadi Abbud add headers for licensing to some schema files
Thu, 22 Nov 2018 12:25:01 +0100 Tom Gottfried Accept only well-formed XML documents as style in database
Sun, 18 Nov 2018 18:29:25 +0100 Sascha L. Teichmann Added a signer who makes the final decison on an import.
Fri, 16 Nov 2018 18:35:09 +0100 Sascha L. Teichmann Implemented the db stuff of the review process. Needs testing.
Fri, 16 Nov 2018 12:15:51 +0100 Sascha L. Teichmann The imort queue has now six states:
Wed, 14 Nov 2018 13:12:41 +0100 Sascha L. Teichmann Propagate deletion of imports through the track_imports table.
Wed, 14 Nov 2018 12:23:10 +0100 Sascha L. Teichmann Track successfull imports in a separate table to be able to remove them later.
Wed, 07 Nov 2018 18:13:02 +0100 Tom Gottfried Delete contour lines with their sounding result
Wed, 07 Nov 2018 17:54:50 +0100 Tom Gottfried Store octrees along with sounding results
Mon, 29 Oct 2018 10:44:51 +0100 Sascha L. Teichmann Added waterway.bottleneck_overview view to database schema.
Tue, 23 Oct 2018 11:32:47 +0200 Sascha L. Teichmann Fixed schema definition of import queue.
Mon, 22 Oct 2018 16:54:34 +0200 Sascha L. Teichmann Persist job queue in database. WIP. persistent-import-queue
Mon, 22 Oct 2018 13:03:38 +0200 Sascha L. Teichmann Added tables for importer queue and respective logging. persistent-import-queue
Sat, 13 Oct 2018 14:26:40 +0200 Tom Gottfried Store virtual and physical distance marks separately
Wed, 10 Oct 2018 00:16:31 +0200 Sascha L. Teichmann Merged default into geo-style branch. geo-style
Mon, 08 Oct 2018 15:18:26 +0200 Tom Gottfried Add categories of distance marks
Mon, 08 Oct 2018 14:48:58 +0200 Sascha L. Teichmann Merged default into geo-style branch. geo-style
Mon, 08 Oct 2018 14:41:56 +0200 Tom Gottfried Remove obsolete comments