CREATE TABLE actor.usr_password_reset ( uuid TEXT 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 );
<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>