{"table_name":"glsr_ratings","full_table_name":"wp_glsr_ratings","description":"Stores glsr ratings data created by this plugin.","detection_method":"both","confidence":"high","create_sql":"CREATE TABLE `wp_glsr_ratings` (\\n  `ID` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `review_id` bigint unsigned NOT NULL,\\n  `rating` int NOT NULL DEFAULT '0',\\n  `type` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT 'local',\\n  `is_approved` tinyint(1) NOT NULL DEFAULT '0',\\n  `is_pinned` tinyint(1) NOT NULL DEFAULT '0',\\n  `is_flagged` tinyint(1) NOT NULL DEFAULT '0',\\n  `is_verified` tinyint(1) NOT NULL DEFAULT '0',\\n  `name` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `email` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `avatar` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `ip_address` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `url` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `terms` tinyint(1) NOT NULL DEFAULT '1',\\n  `score` int NOT NULL DEFAULT '0',\\n  PRIMARY KEY (`ID`),\\n  UNIQUE KEY `glsr_ratings_review_id_unique` (`review_id`),\\n  KEY `glsr_ratings_rating_type_is_pinned_index` (`rating`,`type`,`is_pinned`),\\n  KEY `glsr_ratings_rating_type_is_approved_index` (`rating`,`type`,`is_approved`),\\n  KEY `glsr_ratings_ip_address_index` (`ip_address`),\\n  KEY `glsr_ratings_is_flagged_index` (`is_flagged`),\\n  CONSTRAINT `glsr_ratings_review_id_foreign` FOREIGN KEY (`review_id`) REFERENCES `wp_posts` (`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/"}}