{"table_name":"glsr_assigned_posts","full_table_name":"wp_glsr_assigned_posts","description":"Stores glsr assigned posts data created by this plugin.","detection_method":"both","confidence":"high","create_sql":"CREATE TABLE `wp_glsr_assigned_posts` (\\n  `rating_id` bigint unsigned NOT NULL,\\n  `post_id` bigint unsigned NOT NULL,\\n  `is_published` tinyint(1) NOT NULL DEFAULT '1',\\n  PRIMARY KEY (`rating_id`,`post_id`),\\n  KEY `glsr_assigned_posts_post_id_foreign` (`post_id`),\\n  CONSTRAINT `glsr_assigned_posts_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `wp_posts` (`ID`) ON DELETE CASCADE,\\n  CONSTRAINT `glsr_assigned_posts_rating_id_foreign` FOREIGN KEY (`rating_id`) REFERENCES `wp_glsr_ratings` (`ID`) ON DELETE CASCADE\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci","columns":[],"plugin":{"slug":"site-reviews","name":"Site Reviews","active_installs":60000,"version":"8.0.13","wp_org_url":"https://wordpress.org/plugins/site-reviews/"}}