Mercurial > gemma

log schema/gemma.sql @ 2451:960550ccca55

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
less more | (0) -100 -60 tip
age author description
Fri, 01 Mar 2019 16:28:24 +0100 Sascha Wilde Added gauges layer.
Fri, 01 Mar 2019 12:24:37 +0100 Sascha Wilde depth_reference in sounding data must be more permissive.
Wed, 27 Feb 2019 16:20:22 +0100 Tom Gottfried Using a table in a view before it is created is not possible
Wed, 27 Feb 2019 14:02:28 +0100 Sascha Wilde Don't hard code the available water level ref. systems.
Fri, 22 Feb 2019 18:02:23 +0100 Tom Gottfried Validate country and hectometre in ISRS code
Thu, 21 Feb 2019 14:43:45 +0100 Sascha L. Teichmann Schema: Dropped wrong constraints in gauges.geodref.
Thu, 21 Feb 2019 10:46:38 +0100 Sascha L. Teichmann Print templates: Removed primary key from templates table and add a unique constraint to template name and country instead to make possible that different countries can use templates with same name.
Tue, 19 Feb 2019 17:27:35 +0100 Sascha Wilde Added geoserver config for stretches layer.
Tue, 19 Feb 2019 13:45:39 +0100 Bjoern Schilberg schema/gemma.sql: Added to gm_waterlevel bottlenecks_geoserver view.
Mon, 18 Feb 2019 19:38:48 +0100 Tom Gottfried Warn on import of unknown reference level codes
Mon, 18 Feb 2019 18:45:12 +0100 Tom Gottfried Cleanup schema for reference water levels
Mon, 18 Feb 2019 12:12:12 +0100 Sascha Wilde Use distance marks from wamos db in map.
Fri, 15 Feb 2019 14:08:42 +0100 Bjoern Schilberg schema/gemma.sql: Added fairway_availability.critical and date_info to bottlenecks_geoserver view.
Thu, 14 Feb 2019 15:11:00 +0100 Sascha L. Teichmann Ajjusted RLS for user templates.
Wed, 13 Feb 2019 10:52:14 +0100 Tom Gottfried Remove debris and associate templates to country
Fri, 08 Feb 2019 17:55:42 +0100 Sascha Wilde Removed trigger to update date_info on gauge_measurements.
Fri, 08 Feb 2019 16:20:26 +0100 Sascha Wilde Fixed de-duplication (primary geoserver id) for virt dist marks.
Fri, 08 Feb 2019 12:50:42 +0100 Sascha Wilde Changed geoserver primary key for distance_marks_geoserver to 'id'.
Fri, 08 Feb 2019 11:02:05 +0100 Sascha L. Teichmann Print templates: Stubbed endpoints under /api/templates/print/{name}
Thu, 07 Feb 2019 12:23:05 +0100 Tom Gottfried Waterway profiles have to match a distance mark
Wed, 06 Feb 2019 15:42:32 +0100 Tom Gottfried Fix constraints on waterway profiles
Wed, 06 Feb 2019 15:35:30 +0100 Tom Gottfried Flatten location code in distance marks view
Thu, 31 Jan 2019 17:22:19 +0100 Sascha Wilde Changed bottlenecks_geoserver view and added config to prevent duplications.
Thu, 31 Jan 2019 16:32:18 +0100 Sascha L. Teichmann Waterway profiles import: Restructured code a bit in preparation of downloading Profile geometries from WFS first (needs to be done).
Thu, 31 Jan 2019 12:40:54 +0100 Tom Gottfried Fix exclusion constraint for waterway profiles
Wed, 30 Jan 2019 17:26:51 +0100 Tom Gottfried Add missing NOT NULL constraints
Wed, 30 Jan 2019 17:11:10 +0100 Sascha L. Teichmann Waterway profile import: Added import stub and changed database.
Wed, 30 Jan 2019 10:01:45 +0100 Sascha L. Teichmann Merged default into branch. unify_imports
Tue, 29 Jan 2019 12:36:45 +0100 Tom Gottfried Fix column type to match referenced column unify_imports
Fri, 25 Jan 2019 16:07:09 +0100 Sascha L. Teichmann This breaks this branch!!!! Starting to remove the old persistent layer for configured imports. unify_imports
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.
less more | (0) -100 -60 tip