{"slug":"book-review","name":"Book Review","description":"Spend more time reading","author":"Donna Peplinskie (a11n)","active_installs":300,"version":"2.3.9","wp_org_url":"https://wordpress.org/plugins/book-review/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"book_review_custom_link_urls","full_table_name":"wp_book_review_custom_link_urls","description":"Stores book review custom link urls data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"post_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"custom_link_id","type":"int","nullable":false,"primary_key":false},{"name":"url","type":"varchar(200)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_book_review_custom_link_urls ( post_id bigint(20) NOT NULL, custom_link_id int NOT NULL, url varchar(200), UNIQUE KEY id (post_id, custom_link_id) ) $charset_collate;\"; dbDelta( $sql );"},{"table_name":"book_review_custom_links","full_table_name":"wp_book_review_custom_links","description":"Stores book review custom links data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"custom_link_id","type":"int","nullable":false,"primary_key":true},{"name":"text","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"image_url","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"active","type":"int(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_book_review_custom_links ( custom_link_id int NOT NULL AUTO_INCREMENT, text varchar(100) NOT NULL, image_url varchar(200), active int(1) NOT NULL DEFAULT 1, UNIQUE KEY id (custom_link_id) ) $charset_collate;\"; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );"}],"table_count":2}