{"table_name":"clearfund_categories","full_table_name":"wp_clearfund_categories","description":"Stores clearfund categories data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_clearfund_categories ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL DEFAULT '', `slug` varchar(100) NOT NULL DEFAULT '', `icon` varchar(50) NOT NULL DEFAULT '', `color` varchar(7) NOT NULL DEFAULT '#4A90D9', `description` text, `goal_usd` decimal(10,2) NOT NULL DEFAULT 0.00, `goal_deadline` date DEFAULT NULL, `sort_order` int(11) NOT NULL DEFAULT 0, `active` tinyint(1) NOT NULL DEFAULT 1, `high_priority` tinyint(1) NOT NULL DEFAULT 0, `priority_note` varchar(255) NOT NULL DEFAULT '', `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `slug` (`slug`) ) $charset;\" );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"slug","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"icon","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"color","type":"varchar(7)","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"goal_usd","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"goal_deadline","type":"date","nullable":true,"primary_key":false},{"name":"sort_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"active","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"high_priority","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"priority_note","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","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/"}}