PhoenixKit.Migrations.Postgres.V187 (phoenix_kit v2.29.1)

Copy Markdown View Source

V187: phoenix_kit_access_attempts — every try at the website password gate.

Why

The gate (Website access settings) is a hard block: a blank page with a password prompt before anyone sees anything. The agency wants to know what happens at that door — whether a bot is brute-forcing it, or the client who swears the password "doesn't work" is mistyping it or has caps lock on. So each attempt is kept with a verdict — correct, case (right letters, wrong case), close (a few characters off), unrelated, empty — where from, with what browser, and when. What was typed is kept as the "keep what was typed" setting says: everything (the default — the agency wants to see exactly what was typed), only a case/close near miss, or nothing. The lockout counts failures per address from here too.

What it does

One table, no foreign keys, an index on (address, inserted_at) for the lockout count. Rolling back drops it.

Summary

Functions

down(opts)

up(opts)