{"slug":"aesirx-analytics","name":"AesirX Analytics","description":"Enhance website tracking with the AesirX Analytics WordPress plugin, using privacy-friendly first-party analytics for accurate insights.","author":"AesirX","active_installs":100,"version":"5.0.1","wp_org_url":"https://wordpress.org/plugins/aesirx-analytics/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"analytics_consent","full_table_name":"wp_analytics_consent","description":"Stores analytics consent data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"uuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"wallet_uuid","type":"char(36)","nullable":true,"primary_key":false},{"name":"web3id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"consent","type":"int","nullable":false,"primary_key":false},{"name":"datetime","type":"datetime","nullable":false,"primary_key":false},{"name":"expiration","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_analytics_consent` ( `uuid` char(36) NOT NULL, `wallet_uuid` char(36) DEFAULT NULL, `web3id` varchar(255) DEFAULT NULL, `consent` int NOT NULL, `datetime` datetime NOT NULL, `expiration` datetime DEFAULT NULL, PRIMARY KEY (`uuid`), KEY `analytics_consent_1` (`wallet_uuid`), CONSTRAINT `analytics_consent_1` FOREIGN KEY (`wallet_uuid`) REFERENCES `wp_analytics_wallet` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE"},{"table_name":"analytics_conversion","full_table_name":"wp_analytics_conversion","description":"Stores analytics conversion data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(10) UNSIGNED","nullable":false,"primary_key":true},{"name":"uuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"flow_uuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"order_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"extension","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"revenue_total","type":"INT(10) UNSIGNED","nullable":false,"primary_key":false},{"name":"revenue_subtotal","type":"INT(10) UNSIGNED","nullable":false,"primary_key":false},{"name":"revenue_tax","type":"INT(10) UNSIGNED","nullable":false,"primary_key":false},{"name":"revenue_discount","type":"INT(10) UNSIGNED","nullable":false,"primary_key":false},{"name":"revenue_shipping","type":"INT(10) UNSIGNED","nullable":false,"primary_key":false},{"name":"conversion_type","type":"varchar(255)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_analytics_conversion` ( `id` int(10) UNSIGNED AUTO_INCREMENT UNIQUE KEY NOT NULL, `uuid` char(36) NOT NULL, `flow_uuid` char(36) NOT NULL, `order_id` varchar(255) DEFAULT NULL, `extension` varchar(255) NOT NULL, `revenue_total` INT(10) UNSIGNED NOT NULL, `revenue_subtotal` INT(10) UNSIGNED NOT NULL, `revenue_tax` INT(10) UNSIGNED NOT NULL, `revenue_discount` INT(10) UNSIGNED NOT NULL, `revenue_shipping` INT(10) UNSIGNED NOT NULL, `conversion_type` varchar(255) NOT NULL, UNIQUE KEY `idx_unique` (`extension`, `conversion_type`, `uuid`, `order_id`), UNIQUE KEY `uuid` (`uuid`) ) ENGINE"},{"table_name":"analytics_conversion_item","full_table_name":"wp_analytics_conversion_item","description":"Stores analytics conversion item data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT(10) UNSIGNED","nullable":false,"primary_key":true},{"name":"conversion_uuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"sku","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"price","type":"INT(10) UNSIGNED","nullable":false,"primary_key":false},{"name":"quantity","type":"INT(10) UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_analytics_conversion_item` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `conversion_uuid` char(36) NOT NULL, `sku` VARCHAR(255) NOT NULL, `name` VARCHAR(255) NOT NULL, `price` INT(10) UNSIGNED NOT NULL, `quantity` INT(10) UNSIGNED NOT NULL, PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"analytics_event_attributes","full_table_name":"wp_analytics_event_attributes","description":"Stores analytics event attributes data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT(11) UNSIGNED","nullable":false,"primary_key":true},{"name":"event_uuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"value","type":"varchar(255)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_analytics_event_attributes` ( `id` INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, `event_uuid` char(36) NOT NULL, `name` varchar(255) NOT NULL, `value` varchar(255) NOT NULL, KEY `idx_uuid` (`event_uuid`) ) ENGINE"},{"table_name":"analytics_events","full_table_name":"wp_analytics_events","description":"Stores analytics events data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"uuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"flow_uuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"visitor_uuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"url","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"referer","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"start","type":"datetime","nullable":false,"primary_key":false},{"name":"end","type":"datetime","nullable":false,"primary_key":false},{"name":"event_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"event_type","type":"varchar(255)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_analytics_events` ( `uuid` char(36) NOT NULL, `flow_uuid` char(36) NOT NULL, `visitor_uuid` char(36) NOT NULL, `url` varchar(255) NOT NULL, `referer` varchar(255) DEFAULT NULL, `start` datetime NOT NULL, `end` datetime NOT NULL, `event_name` varchar(255) NOT NULL, `event_type` varchar(255) NOT NULL, PRIMARY KEY (`uuid`), KEY `visitor_uuid` (`visitor_uuid`), KEY `flow_uuid` (`flow_uuid`), INDEX `idx_start_end` (`start`, `end`) ) ENGINE"},{"table_name":"analytics_flows","full_table_name":"wp_analytics_flows","description":"Stores analytics flows data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT(11) UNSIGNED","nullable":false,"primary_key":true},{"name":"uuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"visitor_uuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"start","type":"datetime","nullable":false,"primary_key":false},{"name":"end","type":"datetime","nullable":false,"primary_key":false},{"name":"multiple_events","type":"TINYINT(1)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_analytics_flows` ( `id` INT(11) UNSIGNED AUTO_INCREMENT UNIQUE KEY NOT NULL, `uuid` char(36) NOT NULL, `visitor_uuid` char(36) NOT NULL, `start` datetime NOT NULL, `end` datetime NOT NULL, `multiple_events` TINYINT(1) DEFAULT 0, PRIMARY KEY (`uuid`), KEY `visitor_uuid` (`visitor_uuid`), INDEX `idx_start_end` (`start`, `end`) ) ENGINE"},{"table_name":"analytics_migrations","full_table_name":"wp_analytics_migrations","description":"Stores analytics migrations data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"analytics_visitor_consent","full_table_name":"wp_analytics_visitor_consent","description":"Stores analytics visitor consent data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"uuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"visitor_uuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"consent_uuid","type":"char(36)","nullable":true,"primary_key":false},{"name":"consent","type":"int","nullable":true,"primary_key":false},{"name":"datetime","type":"datetime","nullable":true,"primary_key":false},{"name":"expiration","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"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"},{"table_name":"analytics_visitors","full_table_name":"wp_analytics_visitors","description":"Stores analytics visitors data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"uuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"ip","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"user_agent","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"device","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"browser_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"browser_version","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"domain","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"lang","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"country_code","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"country_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"city","type":"varchar(225)","nullable":true,"primary_key":false},{"name":"isp","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"geo_created_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_analytics_visitors` ( `uuid` char(36) NOT NULL, `ip` varchar(255) NOT NULL, `user_agent` varchar(255) NOT NULL, `device` varchar(255) NOT NULL, `browser_name` varchar(255) NOT NULL, `browser_version` varchar(255) NOT NULL, `domain` varchar(255) NOT NULL, `lang` varchar(255) NOT NULL, `country_code` varchar(255) DEFAULT NULL, `country_name` varchar(255) DEFAULT NULL, `city` varchar(225) DEFAULT NULL, `isp` varchar(255) DEFAULT NULL, `geo_created_at` datetime DEFAULT NULL, PRIMARY KEY (`uuid`), INDEX `idx_domain` (`domain`) ) ENGINE"},{"table_name":"analytics_wallet","full_table_name":"wp_analytics_wallet","description":"Stores analytics wallet data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"uuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"network","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"address","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"nonce","type":"int","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_analytics_wallet` ( `uuid` char(36) NOT NULL, `network` varchar(255) NOT NULL, `address` varchar(255) NOT NULL, `nonce` int DEFAULT NULL, PRIMARY KEY (`uuid`) ) ENGINE"}],"table_count":10}