# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1533215678 -7200
# Node ID e4bf72cda62e95603868907204b932d202fce343
# Parent  ac760b0f22a98d1c396283048c6ac3c8dd22fb16
Added new table password_reset_requests to schema pw_reset.

diff -r ac760b0f22a9 -r e4bf72cda62e schema/auth.sql
--- a/schema/auth.sql	Thu Aug 02 13:06:39 2018 +0200
+++ b/schema/auth.sql	Thu Aug 02 15:14:38 2018 +0200
@@ -37,6 +37,7 @@
 GRANT USAGE ON SCHEMA pw_reset TO pw_reset;
 GRANT SELECT (username, email_address) ON pw_reset.list_users TO pw_reset;
 GRANT UPDATE (pw) ON pw_reset.list_users TO pw_reset;
+GRANT INSERT, SELECT, DELETE ON pw_reset.password_reset_requests TO pw_reset;
 
 
 --
diff -r ac760b0f22a9 -r e4bf72cda62e schema/gemma.sql
--- a/schema/gemma.sql	Thu Aug 02 13:06:39 2018 +0200
+++ b/schema/gemma.sql	Thu Aug 02 15:14:38 2018 +0200
@@ -166,7 +166,15 @@
 
 
 -- Namespace intended to be the only one that pw_reset can access
-CREATE SCHEMA pw_reset;
+CREATE SCHEMA pw_reset
+    CREATE TABLE password_reset_requests (
+        hash varchar(32) PRIMARY KEY,
+        issued timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+        username varchar NOT NULL
+            REFERENCES internal.user_profiles(username)
+                ON DELETE CASCADE
+    )
+;
 
 
 -- Namespace for waterway data that can change in a running system