{"table_name":"clearfund_ledger","full_table_name":"wp_clearfund_ledger","description":"Stores clearfund ledger data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_clearfund_ledger ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `event` varchar(40) NOT NULL DEFAULT '', `entity_type` varchar(20) NOT NULL DEFAULT '', `entity_id` bigint(20) unsigned NOT NULL DEFAULT 0, `actor_id` bigint(20) unsigned NOT NULL DEFAULT 0, `payload` longtext NOT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `prev_hash` char(64) NOT NULL DEFAULT '', `hash` char(64) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `entity` (`entity_type`, `entity_id`), KEY `event` (`event`) ) $charset;\" );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"event","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"entity_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"entity_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"actor_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"payload","type":"longtext","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"prev_hash","type":"char(64)","nullable":false,"primary_key":false},{"name":"hash","type":"char(64)","nullable":false,"primary_key":false}],"plugin":{"slug":"clearfund","name":"ClearFund","active_installs":0,"version":"1.27.0","wp_org_url":"https://wordpress.org/plugins/clearfund/"}}