🗄️What WP Table Is This?
Home / Site Reviews / wp_glsr_assigned_terms

wp_glsr_assigned_terms

Verified

Stores glsr assigned terms data created by this plugin.

CREATE TABLE Statement

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

Safe to delete?

If you have uninstalled Site Reviews, this table is generally safe to remove. However, always back up your database first.

Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.

How to remove this table

DROP TABLE IF EXISTS `wp_glsr_assigned_terms`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from Site Reviews