{"table_name":"famtree_persons","full_table_name":"wp_famtree_persons","description":"Stores famtree persons data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_famtree_persons ( id mediumint(9) NOT NULL AUTO_INCREMENT, root boolean DEFAULT FALSE, firstName varchar(55) DEFAULT '' NOT NULL, surNames varchar(55) DEFAULT '' NOT NULL, lastName varchar(55) DEFAULT '' NOT NULL, birthName varchar(55) DEFAULT '' NOT NULL, birthday date NULL DEFAULT NULL, deathday date NULL DEFAULT NULL, portraitId mediumint(9) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql );","columns":[{"name":"id","type":"mediumint(9)","nullable":false,"primary_key":true},{"name":"root","type":"boolean","nullable":true,"primary_key":false},{"name":"firstName","type":"varchar(55)","nullable":false,"primary_key":false},{"name":"surNames","type":"varchar(55)","nullable":false,"primary_key":false},{"name":"lastName","type":"varchar(55)","nullable":false,"primary_key":false},{"name":"birthName","type":"varchar(55)","nullable":false,"primary_key":false},{"name":"birthday","type":"date","nullable":true,"primary_key":false},{"name":"deathday","type":"date","nullable":true,"primary_key":false},{"name":"portraitId","type":"mediumint(9)","nullable":true,"primary_key":false}],"plugin":{"slug":"famtree","name":"FamTree","active_installs":10,"version":"1.5.1","wp_org_url":"https://wordpress.org/plugins/famtree/"}}