wp_affiliate_spending

Static

Stores affiliate spending data created by this plugin.

Column Definitions

Column	Type	Nullable
🔑id	int(11)	NO
user_id	int(11)	NO
order_id	int(11)	NO
total_spent	decimal(10,2)	NO
currency	varchar(255)	NO
comment	text	NO
creation_date	datetime	NO

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS `wp_affiliate_spending` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT 'Affiliate User Id', `order_id` int(11) NOT NULL COMMENT 'Order ID', `total_spent` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'Spent Total', `currency` varchar(255) NOT NULL COMMENT 'Currency of amount', `comment` text NOT NULL, `creation_date` datetime NOT NULL COMMENT 'Creation Date', PRIMARY KEY (`id`), UNIQUE KEY `order_id` (`order_id`), KEY `user_id` (`user_id`) ) ENGINE

Safe to delete?

If you have uninstalled Simple Affiliate for WooCommerce, 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_affiliate_spending`;

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

Other tables from Simple Affiliate for WooCommerce

wp_affiliate_earnings