{"slug":"ghostables-defender-lite","name":"Ghostables Defender Lite","description":"Active security for WordPress: vulnerability scanning, file integrity, hardening checklist, two-factor authentication, and a tamper-evident audit log.","author":"ghostables","active_installs":0,"version":"0.1.6","wp_org_url":"https://wordpress.org/plugins/ghostables-defender-lite/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"gdef_lite_audit","full_table_name":"wp_gdef_lite_audit","description":"Stores gdef lite audit data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":true},{"name":"created_at","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"actor_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"actor_login","type":"VARCHAR(190)","nullable":false,"primary_key":false},{"name":"ip","type":"VARCHAR(45)","nullable":false,"primary_key":false},{"name":"category","type":"VARCHAR(40)","nullable":false,"primary_key":false},{"name":"action","type":"VARCHAR(80)","nullable":false,"primary_key":false},{"name":"severity","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"target","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"detail","type":"TEXT","nullable":true,"primary_key":false},{"name":"prev_hash","type":"CHAR(64)","nullable":false,"primary_key":false},{"name":"row_hash","type":"CHAR(64)","nullable":false,"primary_key":false},{"name":"created_at","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"engine","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"severity","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"subject","type":"VARCHAR(190)","nullable":false,"primary_key":false},{"name":"title","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"body","type":"TEXT","nullable":true,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"resolved_at","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"path","type":"VARCHAR(500)","nullable":false,"primary_key":false},{"name":"sha256","type":"CHAR(64)","nullable":false,"primary_key":false},{"name":"size","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"mtime","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"recorded_at","type":"INT UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_gdef_lite_audit ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, created_at INT UNSIGNED NOT NULL, actor_id BIGINT UNSIGNED NOT NULL DEFAULT 0, actor_login VARCHAR(190) NOT NULL DEFAULT '', ip VARCHAR(45) NOT NULL DEFAULT '', category VARCHAR(40) NOT NULL, action VARCHAR(80) NOT NULL, severity TINYINT UNSIGNED NOT NULL DEFAULT 1, target VARCHAR(255) NOT NULL DEFAULT '', detail TEXT NULL, prev_hash CHAR(64) NOT NULL DEFAULT '', row_hash CHAR(64) NOT NULL DEFAULT '', KEY created_at (created_at), KEY category (category) ) {$charset};\"; $findings = \"CREATE TABLE wp_gdef_lite_findings ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, created_at INT UNSIGNED NOT NULL, engine VARCHAR(20) NOT NULL, severity VARCHAR(10) NOT NULL DEFAULT 'low', subject VARCHAR(190) NOT NULL, title VARCHAR(255) NOT NULL, body TEXT NULL, status VARCHAR(20) NOT NULL DEFAULT 'open', resolved_at INT UNSIGNED NULL, KEY engine_status (engine, status), KEY created_at (created_at) ) {$charset};\"; $baseline = \"CREATE TABLE wp_gdef_lite_baseline ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, path VARCHAR(500) NOT NULL, sha256 CHAR(64) NOT NULL, size BIGINT UNSIGNED NOT NULL DEFAULT 0, mtime INT UNSIGNED NOT NULL DEFAULT 0, recorded_at INT UNSIGNED NOT NULL, UNIQUE KEY path (path(255)) ) {$charset};\"; dbDelta( $audit );"},{"table_name":"gdef_lite_baseline","full_table_name":"wp_gdef_lite_baseline","description":"Stores gdef lite baseline data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"gdef_lite_findings","full_table_name":"wp_gdef_lite_findings","description":"Stores gdef lite findings data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":3}