Database Schema

Database Tables (5 tables)

wp_ointel_snapshots

sqlid          BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY
score       TINYINT UNSIGNED
results     LONGTEXT  -- JSON: full check results
created_at  DATETIME DEFAULT CURRENT_TIMESTAMP

wp_ointel_alerts_log

sqlid          BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY
type        VARCHAR(50)
message     TEXT
delivered   TINYINT(1) DEFAULT 0
created_at  DATETIME DEFAULT CURRENT_TIMESTAMP

wp_ointel_sessions

sqlid         BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY
user_id    BIGINT UNSIGNED
ip_address VARCHAR(45)
user_agent VARCHAR(500)
logged_in  DATETIME
logged_out DATETIME NULL

wp_ointel_activity

sqlid          BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY
user_id     BIGINT UNSIGNED
action      VARCHAR(100)
object_type VARCHAR(50)
object_id   BIGINT UNSIGNED
details     TEXT
created_at  DATETIME DEFAULT CURRENT_TIMESTAMP

INDEX idx_user_id (user_id)
INDEX idx_created (created_at)

wp_ointel_vuln_cache

sqlplugin_slug VARCHAR(100) PRIMARY KEY
result      TEXT   -- JSON from WPVulnDB
checked_at  DATETIME