{"table_name":"catfolders","full_table_name":"wp_catfolders","description":"Stores catfolders data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_catfolders ( id int(11) unsigned NOT NULL AUTO_INCREMENT, title varchar(250) NOT NULL, parent int(11) unsigned NOT NULL DEFAULT 0, type varchar(20) NOT NULL DEFAULT 'attachment', ord int(11) unsigned NULL DEFAULT 0, created_by bigint(20) NOT NULL DEFAULT 0, PRIMARY KEY (id) ) $collate; CREATE TABLE wp_catfolders_posts ( folder_id int(11) unsigned NOT NULL, post_id bigint(20) unsigned NOT NULL, UNIQUE KEY `folder_post` (`folder_id`,`post_id`) ) $collate; \"; return $tables; } public static function updatePluginVersion() { update_option( 'catf_version', CATF_VERSION );","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"title","type":"varchar(250)","nullable":false,"primary_key":false},{"name":"parent","type":"int(11) unsigned","nullable":false,"primary_key":false},{"name":"type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"ord","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"created_by","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"post_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false}],"plugin":{"slug":"catfolders","name":"CatFolders – WordPress Media Library Folders & Categories","active_installs":6000,"version":"2.5.4","wp_org_url":"https://wordpress.org/plugins/catfolders/"}}