Mercurial > gemma

log schema/gemma.sql @ 5708:83d8d11a069d sr-v2

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
less more | (0) -120 tip
age author description
Sat, 10 Feb 2024 14:58:39 +0100 Sascha L. Teichmann Extend schema to hold version of the mesh_index. sr-v2
Fri, 15 Dec 2023 18:17:40 +0100 Sascha Wilde relenc is now optional in DMV data.
Wed, 04 Oct 2023 18:53:55 +0200 Sascha Wilde Fix check_sr_in_bn_area trigger function to only use staging_done bn.
Tue, 21 Sep 2021 15:31:26 +0200 Sascha L. Teichmann Added a active column to users. deactivate-users
Fri, 09 Jul 2021 22:03:44 +0200 Sascha L. Teichmann Make GeoServer layer sounding_results_marking_points_geoserver working. marking-single-beam
Thu, 08 Jul 2021 10:53:26 +0200 Sascha L. Teichmann schema: geography supports MULTIPOINTZ as modifier. marking-single-beam
Wed, 07 Jul 2021 18:14:04 +0200 Sascha L. Teichmann Dont loose Z values in markings. marking-single-beam
Tue, 06 Jul 2021 00:30:39 +0200 Sascha L. Teichmann Add schema change for marking vessel single beam scans. marking-single-beam
Sun, 04 Jul 2021 11:38:30 +0200 Sascha L. Teichmann Merged default into extended-report branch. extented-report
Sun, 04 Jul 2021 11:36:39 +0200 Sascha L. Teichmann Backed out changeset fe3f651bb03d ... wrong branch. extented-report
Sun, 04 Jul 2021 10:52:56 +0200 Sascha L. Teichmann Remove octree_index and octree_checksum column from schema. extented-report
Thu, 01 Jul 2021 21:56:50 +0200 Sascha L. Teichmann Added a table to store SQL update scripts for aggregated data. extented-report
Thu, 17 Jun 2021 20:48:24 +0200 Sascha L. Teichmann Merged default into extented-report branch. extented-report
Sat, 29 May 2021 17:19:03 +0200 Sascha L. Teichmann Added report_reciever column to user_profiles table. extented-report
Sun, 04 Jul 2021 11:37:37 +0200 Sascha L. Teichmann Remove octree_index and octree_checksum column from schema.
Wed, 19 May 2021 16:48:04 +0200 Sascha L. Teichmann Added new ZPG exception column to sounding result table. zpg-exception
Tue, 31 Mar 2020 18:59:28 +0200 Tom Gottfried Keep historic data of fairway dimensions
Tue, 31 Mar 2020 12:50:30 +0200 Tom Gottfried Prevent equal axis geometries with intersecting validity
Fri, 27 Mar 2020 12:24:25 +0100 Tom Gottfried Merge default into queued-stage-done queued-stage-done
Thu, 26 Mar 2020 14:41:23 +0100 Tom Gottfried Prioritize review jobs on selection queued-stage-done
Tue, 24 Mar 2020 12:53:45 +0100 Sascha L. Teichmann Added new reviewed state. queued-stage-done
Wed, 25 Mar 2020 18:10:02 +0100 Tom Gottfried Prevent duplicate fairway areas
Wed, 18 Mar 2020 19:19:09 +0100 Tom Gottfried Improve feedback if geometry cannot be stored
Wed, 18 Mar 2020 18:42:30 +0100 Tom Gottfried Store fairway dimensions as MultiPolygon
Fri, 13 Mar 2020 17:34:59 +0100 Tom Gottfried Keep historic data of waterway axis
Wed, 11 Mar 2020 17:11:23 +0100 Tom Gottfried Store axis as MultiLinestring
Wed, 11 Mar 2020 11:24:20 +0100 Tom Gottfried Amend trigger function wmst-config
Fri, 06 Mar 2020 11:48:11 +0100 Sascha L. Teichmann Added support for WMS-Time in configuring the GeoServer. wmst-config
Fri, 28 Feb 2020 18:35:07 +0100 Tom Gottfried Add index to speed up fairway marks imports a bit fairway-marks-import
Fri, 28 Feb 2020 16:18:44 +0100 Tom Gottfried Follow-up of rev. 1b309a8e7673 for DAYMAR fairway-marks-import
Fri, 28 Feb 2020 13:50:50 +0100 Tom Gottfried Fixup rev. 1b309a8e7673 fairway-marks-import
Fri, 28 Feb 2020 13:43:52 +0100 Tom Gottfried Follow-up of rev. 1b309a8e7673 for BOYLAT fairway-marks-import
Thu, 27 Feb 2020 21:05:09 +0100 Tom Gottfried Distinguish more clearly between BCNLAT HYDRO and IENC features fairway-marks-import
Wed, 26 Feb 2020 12:18:15 +0100 Tom Gottfried Keep the history of fairway marks fairway-marks-import
Mon, 17 Feb 2020 18:38:45 +0100 Tom Gottfried Add missing fairway mark types fairway-marks-import
Fri, 14 Feb 2020 17:31:17 +0100 Sascha L. Teichmann Added database models for group layers. fairway-marks-import
Fri, 14 Feb 2020 13:01:45 +0100 Tom Gottfried Add missing BOYCAR attribute fairway-marks-import
Fri, 14 Feb 2020 12:14:36 +0100 Tom Gottfried Add import for fairway marks of type BOYLAT fairway-marks-import
Fri, 14 Feb 2020 07:41:43 +0100 Sascha L. Teichmann Geo styles as ZIP: Forgot to change the schema itself. fairway-marks-import
Mon, 10 Feb 2020 18:47:27 +0100 Tom Gottfried Add import for fairway marks of type BOYCAR fairway-marks-import
Mon, 10 Feb 2020 18:11:52 +0100 Tom Gottfried Fix handling of attribute dirimp fairway-marks-import
Mon, 10 Feb 2020 14:56:43 +0100 Tom Gottfried Use table inheritance to define common fairway marks attributes fairway-marks-import
Fri, 31 Jan 2020 16:53:06 +0100 Tom Gottfried Merge branch default into fairway-marks-import fairway-marks-import
Fri, 24 Jan 2020 17:37:41 +0100 Tom Gottfried Merge branch default into fairway-marks-import fairway-marks-import
Tue, 14 Jan 2020 18:24:51 +0100 Tom Gottfried Prevent importing non-distinct fairway marks fairway-marks-import
Tue, 14 Jan 2020 15:01:42 +0100 Tom Gottfried Draft implementation of fairway marks import fairway-marks-import
Fri, 31 Jan 2020 15:48:52 +0100 Tom Gottfried Backout changesets 5c12b7cdc58c and 8a4c98b80fbd
Fri, 24 Jan 2020 17:33:12 +0100 Tom Gottfried Make constraint trigger work in sessions with empty search_path
Fri, 24 Jan 2020 16:48:59 +0100 Tom Gottfried Make CHECK constraint work in sessions with empty search_path
Wed, 04 Dec 2019 13:35:34 +0100 Sascha Wilde Allow "Measured" and "Forecast" values to coexist for the same time and gauge.
Thu, 14 Nov 2019 14:53:15 +0100 Tom Gottfried Explaining comment on constraint triggers
Fri, 18 Oct 2019 17:55:12 +0200 Tom Gottfried Hide sys_admin accounts to waterway admins
Fri, 18 Oct 2019 15:45:48 +0200 Tom Gottfried Generally disallow the same section name for different countries
Fri, 18 Oct 2019 15:34:34 +0200 Sascha L. Teichmann Added a 'changed' column to the import.imports table.
Fri, 18 Oct 2019 12:04:04 +0200 Tom Gottfried Authorize sections based on country of creator
Thu, 17 Oct 2019 18:56:59 +0200 Tom Gottfried Avoid creating user profiles without matching role
Thu, 17 Oct 2019 16:36:58 +0200 Tom Gottfried Remove obsolete comment
Thu, 17 Oct 2019 13:08:49 +0200 Tom Gottfried Backed out changeset 9279fdb7a422
Thu, 17 Oct 2019 12:55:13 +0200 Tom Gottfried Ensure unique names of sections and stretches
Tue, 15 Oct 2019 15:59:38 +0200 Tom Gottfried Fix identifiers in layers generated from SQL views
Sun, 13 Oct 2019 19:22:36 +0200 Sascha L. Teichmann Started with conversion tool. stree-experiment
Thu, 10 Oct 2019 17:10:14 +0200 Sascha L. Teichmann Fill single and multi into survey type table.
Wed, 09 Oct 2019 16:40:18 +0200 Tom Gottfried Merge default into geoserver_sql_views geoserver_sql_views
Fri, 04 Oct 2019 16:40:04 +0200 Tom Gottfried Merge default into geoserver_sql_views geoserver_sql_views
Fri, 20 Sep 2019 15:35:16 +0200 Tom Gottfried Merge default into geoserver_sql_views geoserver_sql_views
Mon, 09 Sep 2019 17:24:07 +0200 Tom Gottfried Merge default into geoserver_sql_views geoserver_sql_views
Fri, 06 Sep 2019 11:58:03 +0200 Tom Gottfried Add possibility to configure SRS for GeoServer SQL view geoserver_sql_views
Thu, 05 Sep 2019 11:33:01 +0200 Tom Gottfried Separate schema and table name geoserver_sql_views
Tue, 03 Sep 2019 18:00:50 +0200 Tom Gottfried Do not try to execute NULL as a subquery geoserver_sql_views
Mon, 02 Sep 2019 18:45:15 +0200 Tom Gottfried Add field for GeoServer SQL view definition geoserver_sql_views
Tue, 08 Oct 2019 13:02:21 +0200 Sascha L. Teichmann Adjusted templating for iso areas. iso-areas
Tue, 08 Oct 2019 12:10:55 +0200 Sascha L. Teichmann Removed old contours from backend and database. iso-areas
Mon, 07 Oct 2019 12:37:17 +0200 Sascha L. Teichmann Added caching table for iso areas of sounding differences. iso-areas
Wed, 02 Oct 2019 16:43:34 +0200 Sascha L. Teichmann Added table to to store iso areas of sounding results. iso-areas
Mon, 23 Sep 2019 12:59:48 +0200 Sascha Wilde Changed fa data to accept "position" as strings, not a 2char "position_code"
Fri, 20 Sep 2019 13:22:45 +0200 Tom Gottfried Fix forecast accuracy values and improve performance
Thu, 12 Sep 2019 18:13:47 +0200 Sascha Wilde Use stretches as areas of responsibility. stretches-for-responsibility
Mon, 09 Sep 2019 16:13:26 +0200 Tom Gottfried Remove VIEW columns ignored by GeoServer
Wed, 21 Aug 2019 16:17:46 +0200 Bernhard Reiter Remove unused systemconf.feature_colours from backend
Wed, 07 Aug 2019 10:27:11 +0200 Tom Gottfried Enable faster access to import logs
Mon, 05 Aug 2019 16:45:48 +0200 Tom Gottfried Schema qualify tables in function body
Thu, 01 Aug 2019 19:12:47 +0200 Sascha Wilde Enable better error handling for referenced gauges/bottlenecks constraints.
Thu, 01 Aug 2019 17:07:01 +0200 Sascha Wilde Merged default request_hist_bns
Thu, 01 Aug 2019 17:02:09 +0200 Tom Gottfried Bulk-delete tracked entries per table
Tue, 30 Jul 2019 13:14:47 +0200 Sascha Wilde Change constraints for bottlenecks to include staging_done flag. request_hist_bns
Fri, 26 Jul 2019 16:49:54 +0200 Sascha Wilde Merged default historization_ng
Fri, 26 Jul 2019 10:50:22 +0200 Sascha L. Teichmann Merged default into timezone branch. timezone
Fri, 26 Jul 2019 10:38:24 +0200 Sascha L. Teichmann Fixed broken schema statement.
Fri, 26 Jul 2019 09:57:29 +0200 Sascha L. Teichmann Reapplied timezone patch to database schema. timezone
Thu, 25 Jul 2019 18:19:24 +0200 Sascha Wilde Merged default historization_ng
Thu, 25 Jul 2019 18:12:14 +0200 Sascha L. Teichmann Reverted 4160:419f28898db0 in default.
Thu, 25 Jul 2019 17:39:40 +0200 Sascha Wilde Merged default historization_ng
Thu, 25 Jul 2019 16:45:07 +0200 Sascha L. Teichmann Added time zones to import queue tables.
Thu, 25 Jul 2019 13:20:32 +0200 Sascha Wilde Merged default historization_ng
Thu, 25 Jul 2019 12:36:07 +0200 Sascha Wilde Fixed c&p errors in gemma schema. historization_ng
Thu, 25 Jul 2019 12:33:19 +0200 Sascha Wilde Adapted references to bottlenecks from fairway_availability in DB schema. historization_ng
Thu, 25 Jul 2019 08:16:34 +0200 Tom Gottfried date_info has to be provided by the data source
Wed, 24 Jul 2019 16:15:21 +0200 Sascha Wilde WIP: Remove references to bottleneck validity in DB schema. historization_ng
Wed, 24 Jul 2019 13:29:31 +0200 Sascha Wilde Added trigger constraints to ensure matching gauges for gauge measurements. historization_ng
Wed, 24 Jul 2019 13:00:37 +0200 Sascha Wilde WIP: Finished remove references to gauge validity in DB schema. historization_ng
Wed, 24 Jul 2019 11:16:38 +0200 Sascha Wilde Merged historization_ng
Tue, 23 Jul 2019 13:10:51 +0200 Sascha Wilde WIP: Started to remove references to gauge validity. historization_ng
Tue, 23 Jul 2019 16:59:43 +0200 Sascha L. Teichmann Schema: delete only import entry that are for deletion.
Tue, 23 Jul 2019 13:16:41 +0200 Sascha L. Teichmann Import queue: Added a column to the tracking table to delete entries on stage done.
Fri, 19 Jul 2019 14:30:14 +0200 Tom Gottfried Optimize index setup a bit
Thu, 18 Jul 2019 19:57:10 +0200 Tom Gottfried Speed up time based filtering of gauge measurements and predictions
Wed, 17 Jul 2019 16:48:26 +0200 Sascha Wilde Schema: Use SQL instead of PLPGSQL for get_schema_version().
Wed, 17 Jul 2019 12:05:06 +0200 Sascha Wilde Added database schema versioning and db update script.
Tue, 16 Jul 2019 12:38:44 +0200 Sascha L. Teichmann Reworked password reset to be single mailed. pwreset-rework
Thu, 04 Jul 2019 16:30:19 +0200 Sascha Wilde Add wwname to import of virtual distance marks.
Mon, 24 Jun 2019 16:25:17 +0200 Sascha Wilde Fixed typo in gemma schema.
Mon, 24 Jun 2019 16:13:05 +0200 Sascha Wilde Added check trigger to sounding results to ensure they intersect the bn-area.
Sat, 15 Jun 2019 14:36:50 +0200 Tom Gottfried Align bottleneck validity at gauges
Sat, 15 Jun 2019 09:24:28 +0200 Tom Gottfried Use database triggers to move referencing objects to new versions
Thu, 13 Jun 2019 19:13:42 +0200 Tom Gottfried Ensure sounding results are associated to matching bottleneck version
Wed, 12 Jun 2019 18:26:26 +0200 Tom Gottfried Avoid empty validity time ranges
Wed, 12 Jun 2019 18:21:14 +0200 Tom Gottfried Fixup accidental change in rev. 02951a62e8c6
Wed, 12 Jun 2019 17:11:15 +0200 Tom Gottfried 'Historicise' bottlenecks on import
Wed, 05 Jun 2019 18:50:54 +0200 Sascha Wilde Allow same values for depth_reference in SR as in gauges
Wed, 29 May 2019 18:41:35 +0200 Tom Gottfried Prevent non-erased gauge version to have empty validity range
less more | (0) -120 tip