{"slug":"famtree","name":"FamTree","description":"This plugin provides a block to manage and visualize family trees (Scaffolded with Create Block tool).","author":"pvogel2","active_installs":10,"version":"1.5.1","wp_org_url":"https://wordpress.org/plugins/famtree/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"famtree_","full_table_name":"wp_famtree_","description":"Stores famtree  data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"famtree_metadata","full_table_name":"wp_famtree_metadata","description":"Stores additional metadata (key-value pairs) for famtree metadata records.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"mediumint(9)","nullable":false,"primary_key":true},{"name":"refId","type":"mediumint(9)","nullable":false,"primary_key":false},{"name":"mediaId","type":"mediumint(9)","nullable":false,"primary_key":false},{"name":"refDate","type":"date","nullable":true,"primary_key":false},{"name":"content","type":"json","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_famtree_metadata ( id mediumint(9) NOT NULL AUTO_INCREMENT, refId mediumint(9) NOT NULL, mediaId mediumint(9) NOT NULL, refDate date NULL DEFAULT NULL, content json NULL DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\"; dbDelta( $sql );"},{"table_name":"famtree_persons","full_table_name":"wp_famtree_persons","description":"Stores famtree persons data created by this plugin.","detection_method":"static","confidence":"high","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}],"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 );"},{"table_name":"famtree_relations","full_table_name":"wp_famtree_relations","description":"Stores famtree relations data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"mediumint(9)","nullable":false,"primary_key":true},{"name":"type","type":"varchar(55)","nullable":true,"primary_key":false},{"name":"start","type":"date","nullable":true,"primary_key":false},{"name":"end","type":"date","nullable":true,"primary_key":false},{"name":"members","type":"json","nullable":false,"primary_key":false},{"name":"children","type":"json","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_famtree_relations ( id mediumint(9) NOT NULL AUTO_INCREMENT, type varchar(55) NULL DEFAULT NULL, start date NULL DEFAULT NULL, end date NULL DEFAULT NULL, members json NOT NULL, children json NOT NULL, PRIMARY KEY (id) ) $charset_collate;\"; dbDelta( $sql );"}],"table_count":4}