PHP Classes

File: SQL File

Recommend this page to a friend!
  Packages of Matthew Asham   Binkterm PHP   database/migrations/v1.11.0.85_packet_bbs_login_attempts_username.sql   Download  
File: database/migrations/v1.11.0.85_packet_bbs_login_attempts_username.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Binkterm PHP
Bulletin board system based on the Web
Author: By
Last change:
Date: 5 days ago
Size: 477 bytes
 

Contents

Class file image Download 
-- Add username tracking to PacketBBS login attempts for cross-node rate limiting.
-- Allows blocking brute-force attempts against a single account arriving from
-- multiple different source nodes, not just per-node blocking.
ALTER TABLE packet_bbs_login_attempts ADD COLUMN IF NOT EXISTS username VARCHAR(100);
CREATE INDEX IF NOT EXISTS idx_packet_bbs_login_attempts_username
    ON packet_bbs_login_attempts (username, success, attempted_at)
    WHERE username IS NOT NULL;