====== pears.SetNulLogoffTimes ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
CREATE EVENT "pears"."SetNulLogoffTimes" TYPE "DatabaseStart"  ENABLE 
HANDLER
begin
  update "DatabaseLoginAttempts" set "LogOffTime" = "lesser"("dateadd"("minute",-1,current timestamp),cast("dateadd"("day",1,"date"("loginattempttime")) as timestamp))
    where "LogOffTime" is null
end
</code>