{"table_name":"bearmor_file_checksums","full_table_name":"wp_bearmor_file_checksums","description":"Stores bearmor file checksums data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_bearmor_file_checksums ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, file_path VARCHAR(500) NOT NULL, checksum VARCHAR(64) NOT NULL, file_size BIGINT UNSIGNED, last_checked DATETIME NOT NULL, status ENUM('baseline', 'changed', 'new', 'deleted', 'safe') DEFAULT 'baseline', UNIQUE KEY file_path (file_path), KEY status (status), KEY last_checked (last_checked) ) $charset_collate;\"; dbDelta( $sql );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":true},{"name":"file_path","type":"VARCHAR(500)","nullable":false,"primary_key":false},{"name":"file_size","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"last_checked","type":"DATETIME","nullable":false,"primary_key":false},{"name":"status","type":"ENUM('baseline', 'changed', 'new', 'deleted', 'safe')","nullable":true,"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/"}}