view schema/updates/1000/01.pwreset.sql @ 5095:e21cbb9768a2

Prevent duplicate fairway areas In principal, there can be only one or no fairway area at each point on the map. Since polygons from real data will often be topologically inexact, just disallow equal geometries. This will also help to avoid importing duplicates with concurrent imports, once the history of fairway dimensions will be preserved.
author Tom Gottfried <tom@intevation.de>
date Wed, 25 Mar 2020 18:10:02 +0100
parents 7b7c324b318f
children
line wrap: on
line source

GRANT INSERT, DELETE, UPDATE ON sys_admin.password_reset_requests TO sys_admin;

ALTER TABLE sys_admin.password_reset_requests
  ADD CONSTRAINT password_reset_requests_username_key UNIQUE(username);