log schema/auth.sql @ 2672:b997e1fd1d3d import-overview-rework

age author description
Thu, 07 Mar 2019 15:55:25 +0100 Sascha L. Teichmann Schema: Added caching schema containing the sounding differences.
Thu, 14 Feb 2019 15:11:00 +0100 Sascha L. Teichmann Ajjusted RLS for user templates.
Wed, 13 Feb 2019 16:59:38 +0100 Sascha Wilde sysadmin users shall be able to create new stretches w/o restrictions.
Wed, 13 Feb 2019 10:52:14 +0100 Tom Gottfried Remove debris and associate templates to country
Fri, 08 Feb 2019 11:02:05 +0100 Sascha L. Teichmann Print templates: Stubbed endpoints under /api/templates/print/{name}
Wed, 30 Jan 2019 23:57:51 +0100 Sascha L. Teichmann Waterway profiles import: Implemented the parsing of the data lines of the CSV file and stored the values into the database.
Thu, 24 Jan 2019 12:56:31 +0100 Tom Gottfried Move import queue to its own database namespace
Wed, 23 Jan 2019 16:25:43 +0100 Tom Gottfried Fix area generation from multipolygon input
Fri, 18 Jan 2019 18:15:41 +0100 Sascha L. Teichmann Fixed RLS policy for waterway.stretches.
Fri, 18 Jan 2019 12:11:50 +0100 Sascha L. Teichmann Fixed RLS for stretches table.
Thu, 17 Jan 2019 19:22:49 +0100 Tom Gottfried Fix policies interfering badly with integrity checks
Thu, 17 Jan 2019 18:15:15 +0100 Tom Gottfried Simplify RLS policies on import jobs
Thu, 17 Jan 2019 09:27:28 +0100 Raimund Renkert Added RLS for responsibility area on fairway dimensions.
Wed, 16 Jan 2019 18:12:41 +0100 Tom Gottfried Sync access to import config attributes to import config
Wed, 16 Jan 2019 17:30:13 +0100 Tom Gottfried Move not only authentication related functions to own file
Mon, 14 Jan 2019 17:43:28 +0100 Tom Gottfried Row level security for import jobs
Fri, 11 Jan 2019 17:43:26 +0100 Sascha L. Teichmann RLS gauge_measurements: Another attempt.
Fri, 11 Jan 2019 16:48:14 +0100 Sascha L. Teichmann (Approved) gauge measurement import: Fixed row level security.
Wed, 09 Jan 2019 15:53:48 +0100 Sascha L. Teichmann Configured imports: Allow sys_admin access to import_configuation.
Thu, 20 Dec 2018 12:05:30 +0100 Raimund Renkert Updated database schema for gauge meaurement imports.
Wed, 19 Dec 2018 18:12:03 +0100 Tom Gottfried Cleanup GRANTs for waterway_admin
Wed, 19 Dec 2018 16:48:00 +0100 Sascha L. Teichmann Added grants to waterway.bottlenecks to waterway.admin to pass declining of imports.
Mon, 10 Dec 2018 15:55:10 +0100 Sascha L. Teichmann Add table to store import configuration.
Mon, 26 Nov 2018 15:21:34 +0100 Sascha L. Teichmann Added missing rights and fixed trigger function.
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
Tue, 20 Nov 2018 00:51:33 +0100 Sascha L. Teichmann Improved performance of row level security check on users responsibility areas
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:08:57 +0100 Tom Gottfried Remove obsolete GRANT to sys_admin
Wed, 24 Oct 2018 16:21:44 +0200 Sascha L. Teichmann Added endpoint to delete job from import queue.
Sun, 30 Sep 2018 11:49:23 +0200 Sascha L. Teichmann More on uploading styles to gemma. geo-style
Fri, 28 Sep 2018 11:51:06 +0200 Sascha Wilde Added end point to set style (colour) information for feature.
Fri, 28 Sep 2018 10:56:03 +0200 Sascha Wilde Added end point to get style (colour) information for feature.
Mon, 24 Sep 2018 11:36:30 +0200 Sascha L. Teichmann Granted rights to sys_admin on waterway.sounding_results_contour_lines.
Thu, 23 Aug 2018 16:41:44 +0200 Tom Gottfried Purge password reset role
Wed, 22 Aug 2018 16:48:56 +0200 Tom Gottfried Add metamorphic database role and user e.g. for GeoServer
Thu, 09 Aug 2018 15:45:16 +0200 Tom Gottfried Store spatial data as geography
Mon, 06 Aug 2018 15:19:05 +0200 Tom Gottfried Add staging feature to more tables
Thu, 02 Aug 2018 19:25:30 +0200 Tom Gottfried Allow Waterway User to update a limited set of profile attributes
Thu, 02 Aug 2018 15:14:38 +0200 Sascha L. Teichmann Added new table password_reset_requests to schema pw_reset.
Thu, 02 Aug 2018 13:06:39 +0200 Tom Gottfried Add special role for password reset
Wed, 01 Aug 2018 18:16:14 +0200 Tom Gottfried Lock out the PUBLIC more rigorously
Wed, 01 Aug 2018 17:35:12 +0200 Tom Gottfried Place functions in more matching schemas
Wed, 01 Aug 2018 15:49:38 +0200 Tom Gottfried Use SQL UPDATE to update users
Mon, 30 Jul 2018 11:38:09 +0200 Tom Gottfried Make user_profiles table invisible for users
Fri, 27 Jul 2018 19:03:56 +0200 Tom Gottfried Enable listing of users for all roles with appropriate filters
Thu, 26 Jul 2018 19:33:42 +0200 Tom Gottfried Add view to list user profiles with role
Mon, 23 Jul 2018 16:40:21 +0200 Tom Gottfried Remove obsolete GRANT on user_profiles
Fri, 20 Jul 2018 17:28:16 +0200 Tom Gottfried Introduce database schemas as privilege-based namespaces
Wed, 18 Jul 2018 16:48:27 +0200 Tom Gottfried Beautify SQL
Tue, 17 Jul 2018 19:08:18 +0200 Tom Gottfried Improve RLS policies for template data
Tue, 17 Jul 2018 18:21:56 +0200 Tom Gottfried Add missing privilege for waterway_admin
Tue, 17 Jul 2018 16:50:16 +0200 Tom Gottfried Make schema for templates more realistic
Fri, 13 Jul 2018 14:56:32 +0200 Tom Gottfried Allow waterway_admin to see profiles of users in same country
Thu, 12 Jul 2018 16:30:01 +0200 Tom Gottfried Automate running DB-tests with an extra database
Tue, 26 Jun 2018 16:20:04 +0200 Sascha L. Teichmann s/wamos/gemma/g on database schema.
Tue, 26 Jun 2018 16:14:59 +0200 Sascha L. Teichmann Moved schema stuff to own subfolder. base auth.sql@63cafb14177c