{"table_name":"bearmor_activity_log","full_table_name":"wp_bearmor_activity_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_bearmor_activity_log ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, user_id BIGINT UNSIGNED NOT NULL, username VARCHAR(60) NOT NULL, action VARCHAR(50) NOT NULL, object_type VARCHAR(50), object_name VARCHAR(255), ip_address VARCHAR(45), user_agent TEXT, created_at DATETIME NOT NULL, INDEX idx_user_id (user_id), INDEX idx_action (action), INDEX idx_created_at (created_at) ) $charset_collate;\"; dbDelta( $sql );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":true},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"username","type":"VARCHAR(60)","nullable":false,"primary_key":false},{"name":"action","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"object_type","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"object_name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"ip_address","type":"VARCHAR(45)","nullable":true,"primary_key":false},{"name":"user_agent","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"plugin":{"slug":"bearmor-security","name":"Bearmor Security","active_installs":50,"version":"1.0.4","wp_org_url":"https://wordpress.org/plugins/bearmor-security/"}}