wp_analytics_visitor_consent
StaticStores analytics visitor consent data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| uuid | char(36) | NO |
| visitor_uuid | char(36) | NO |
| consent_uuid | char(36) | YES |
| consent | int | YES |
| datetime | datetime | YES |
| expiration | datetime | YES |
CREATE TABLE Statement
CREATE TABLE `wp_analytics_visitor_consent` ( `uuid` char(36) NOT NULL, `visitor_uuid` char(36) NOT NULL, `consent_uuid` char(36) DEFAULT NULL, `consent` int DEFAULT NULL, `datetime` datetime DEFAULT NULL, `expiration` datetime DEFAULT NULL, PRIMARY KEY (`uuid`), KEY `analytics_visitor_consent_1` (`visitor_uuid`), KEY `analytics_visitor_consent_2` (`consent_uuid`), CONSTRAINT `analytics_visitor_consent_1` FOREIGN KEY (`visitor_uuid`) REFERENCES `wp_analytics_visitors` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `analytics_visitor_consent_2` FOREIGN KEY (`consent_uuid`) REFERENCES `wp_analytics_consent` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE
Safe to delete?
If you have uninstalled AesirX Analytics, 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_analytics_visitor_consent`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from AesirX Analytics