{"table_name":"emr_login_logs","full_table_name":"wp_emr_login_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS wp_emr_login_logs ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT UNSIGNED DEFAULT NULL, username_attempt VARCHAR(60) DEFAULT NULL, event_type VARCHAR(10) NOT NULL DEFAULT 'login', ip_address VARCHAR(45) DEFAULT NULL, user_agent VARCHAR(500) DEFAULT NULL, login_at DATETIME NOT NULL, PRIMARY KEY (id), KEY idx_user (user_id), KEY idx_login_at (login_at), KEY idx_event (event_type) ) $c;\" );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"username_attempt","type":"VARCHAR(60)","nullable":true,"primary_key":false},{"name":"event_type","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"ip_address","type":"VARCHAR(45)","nullable":true,"primary_key":false},{"name":"user_agent","type":"VARCHAR(500)","nullable":true,"primary_key":false},{"name":"login_at","type":"DATETIME","nullable":false,"primary_key":false}],"plugin":{"slug":"employee-roster","name":"EmpRoster","active_installs":0,"version":"2.8.35","wp_org_url":"https://wordpress.org/plugins/employee-roster/"}}