wp_aieo_order_attribution
StaticStores order records and related transaction data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| order_id | bigint(20) unsigned | NO |
| channel | varchar(255) | YES |
| utm_source | varchar(255) | YES |
| utm_medium | varchar(255) | YES |
| utm_campaign | varchar(255) | YES |
| utm_term | varchar(255) | YES |
| utm_content | varchar(255) | YES |
| origin | varchar(12) | YES |
| updated_at | datetime | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_aieo_order_attribution` ( `order_id` bigint(20) unsigned NOT NULL, `channel` varchar(255) DEFAULT NULL, `utm_source` varchar(255) DEFAULT NULL, `utm_medium` varchar(255) DEFAULT NULL, `utm_campaign` varchar(255) DEFAULT NULL, `utm_term` varchar(255) DEFAULT NULL, `utm_content` varchar(255) DEFAULT NULL, `origin` varchar(12) DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`order_id`), KEY `idx_channel` (`channel`), KEY `idx_origin` (`origin`) ) ENGINE
Safe to delete?
If you have uninstalled AI eShop Optimizer, 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_aieo_order_attribution`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from AI eShop Optimizer