1CREATE TABLE IF NOT EXISTS security_notifications (2 id TEXT PRIMARY KEY,3 incident_name TEXT NOT NULL,4 action TEXT NOT NULL,5 window_bucket INTEGER NOT NULL,6 subject TEXT NOT NULL,7 text TEXT NOT NULL,8 html TEXT,9 created_at INTEGER NOT NULL,10 sent_at INTEGER,11 attempts INTEGER NOT NULL DEFAULT 0,12 last_error TEXT13);1415CREATE INDEX IF NOT EXISTS idx_security_notifications_pending16 ON security_notifications(created_at)17 WHERE sent_at IS NULL;