Differences

This shows you the differences between two versions of the page.

--- dev:proposal:self_serve_password_reset [2010/03/28 18:17] – created dbs
+++ dev:proposal:self_serve_password_reset [2022/02/10 13:34] (current) – external edit 127.0.0.1
@@ Line 4: / Line 4: @@
   * UUID::Tiny (trunk already requires this)
 ===== Schema =====
 <code sql>CREATE TABLE actor.usr_password_reset (
   uuid TEXT NOT NULL,
-  usr BIGINT NOT NULL,
+  usr BIGINT NOT NULL REFERENCES actor.usr(id) DEFERRABLE INITIALLY DEFERRED,
   request_time TIMESTAMP NOT NULL DEFAULT NOW(),
   has_been_reset BOOLEAN NOT NULL DEFAULT false
 );
+</code>
+===== Fieldmapper =====
+<code xml><class id="aupr" controller="open-ils.cstore" oils_obj:fieldmapper="actor::usr_password_reset" oils_persist:tablename="actor.usr_password_reset" reporter:label="User password reset requests">
+  <fields oils_persist:primary="uuid">
+    <field reporter:label="UUID" name="uuid" reporter:datatype="text"/>
+    <field reporter:label="User" name="usr" reporter:datatype="link"/>
+    <field reporter:label="Request Time" name="request_time" reporter:datatype="timestamp"/>
+    <field reporter:label="Was Reset?" name="has_been_reset" reporter:datatype="bool"/>
+  </fields>
+  <links>
+    <link field="usr" reltype="has_a" key="id" class="au"/>
+  </links>
+</class></code>
 </code>