{"slug":"site-reviews","name":"Site Reviews","description":"Site Reviews is a complete review management solution that integrates with WooCommerce and SureCart and works similarly to reviews on Amazon, Tripadvi …","author":"Gemini Labs","active_installs":60000,"version":"8.0.13","wp_org_url":"https://wordpress.org/plugins/site-reviews/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"actionscheduler_actions","full_table_name":"wp_actionscheduler_actions","description":"Stores actionscheduler actions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_actionscheduler_actions` (\\n  `action_id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `hook` varchar(191) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `scheduled_date_gmt` datetime DEFAULT '0000-00-00 00:00:00',\\n  `scheduled_date_local` datetime DEFAULT '0000-00-00 00:00:00',\\n  `priority` tinyint unsigned NOT NULL DEFAULT '10',\\n  `args` varchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `schedule` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `group_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `attempts` int NOT NULL DEFAULT '0',\\n  `last_attempt_gmt` datetime DEFAULT '0000-00-00 00:00:00',\\n  `last_attempt_local` datetime DEFAULT '0000-00-00 00:00:00',\\n  `claim_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `extended_args` varchar(8000) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  PRIMARY KEY (`action_id`),\\n  KEY `hook_status_scheduled_date_gmt` (`hook`(163),`status`,`scheduled_date_gmt`),\\n  KEY `status_scheduled_date_gmt` (`status`,`scheduled_date_gmt`),\\n  KEY `scheduled_date_gmt` (`scheduled_date_gmt`),\\n  KEY `args` (`args`),\\n  KEY `group_id` (`group_id`),\\n  KEY `last_attempt_gmt` (`last_attempt_gmt`),\\n  KEY `claim_id_status_priority_scheduled_date_gmt` (`claim_id`,`status`,`priority`,`scheduled_date_gmt`),\\n  KEY `status_last_attempt_gmt` (`status`,`last_attempt_gmt`),\\n  KEY `status_claim_id` (`status`,`claim_id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"actionscheduler_claims","full_table_name":"wp_actionscheduler_claims","description":"Stores actionscheduler claims data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_actionscheduler_claims` (\\n  `claim_id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `date_created_gmt` datetime DEFAULT '0000-00-00 00:00:00',\\n  PRIMARY KEY (`claim_id`),\\n  KEY `date_created_gmt` (`date_created_gmt`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"actionscheduler_groups","full_table_name":"wp_actionscheduler_groups","description":"Stores actionscheduler groups data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_actionscheduler_groups` (\\n  `group_id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `slug` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  PRIMARY KEY (`group_id`),\\n  KEY `slug` (`slug`(191))\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"actionscheduler_logs","full_table_name":"wp_actionscheduler_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_actionscheduler_logs` (\\n  `log_id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `action_id` bigint unsigned NOT NULL,\\n  `message` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `log_date_gmt` datetime DEFAULT '0000-00-00 00:00:00',\\n  `log_date_local` datetime DEFAULT '0000-00-00 00:00:00',\\n  PRIMARY KEY (`log_id`),\\n  KEY `action_id` (`action_id`),\\n  KEY `log_date_gmt` (`log_date_gmt`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"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","columns":[],"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"},{"table_name":"glsr_assigned_terms","full_table_name":"wp_glsr_assigned_terms","description":"Stores glsr assigned terms data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_glsr_assigned_terms` (\\n  `rating_id` bigint unsigned NOT NULL,\\n  `term_id` bigint unsigned NOT NULL,\\n  PRIMARY KEY (`rating_id`,`term_id`),\\n  KEY `glsr_assigned_terms_term_id_foreign` (`term_id`),\\n  CONSTRAINT `glsr_assigned_terms_rating_id_foreign` FOREIGN KEY (`rating_id`) REFERENCES `wp_glsr_ratings` (`ID`) ON DELETE CASCADE,\\n  CONSTRAINT `glsr_assigned_terms_term_id_foreign` FOREIGN KEY (`term_id`) REFERENCES `wp_terms` (`term_id`) ON DELETE CASCADE\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"glsr_assigned_users","full_table_name":"wp_glsr_assigned_users","description":"Stores glsr assigned users data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_glsr_assigned_users` (\\n  `rating_id` bigint unsigned NOT NULL,\\n  `user_id` bigint unsigned NOT NULL,\\n  PRIMARY KEY (`rating_id`,`user_id`),\\n  KEY `glsr_assigned_users_user_id_foreign` (`user_id`),\\n  CONSTRAINT `glsr_assigned_users_rating_id_foreign` FOREIGN KEY (`rating_id`) REFERENCES `wp_glsr_ratings` (`ID`) ON DELETE CASCADE,\\n  CONSTRAINT `glsr_assigned_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `wp_users` (`ID`) ON DELETE CASCADE\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"glsr_ratings","full_table_name":"wp_glsr_ratings","description":"Stores glsr ratings data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"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"},{"table_name":"glsr_stats","full_table_name":"wp_glsr_stats","description":"Stores analytics or statistics data.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_glsr_stats` (\\n  `ID` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `rating_id` bigint unsigned NOT NULL,\\n  `continent` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `country` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `region` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `city` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  PRIMARY KEY (`ID`),\\n  UNIQUE KEY `glsr_stats_rating_id_unique` (`rating_id`),\\n  CONSTRAINT `glsr_stats_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"},{"table_name":"glsr_tmp","full_table_name":"wp_glsr_tmp","description":"Stores glsr tmp data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_glsr_tmp` (\\n  `ID` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `data` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  PRIMARY KEY (`ID`),\\n  KEY `type` (`type`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"}],"table_count":10}