wp_ec_order_fee

Static

Stores order records and related transaction data.

Column Definitions

ColumnTypeNullable
🔑order_fee_idint(11)NO
order_idint(11)NO
fee_labelvarchar(512)NO
fee_ratefloat(15,3)NO
fee_totalfloat(15,3)NO

CREATE TABLE Statement

CREATE TABLE ec_order_fee ( order_fee_id int(11) NOT NULL AUTO_INCREMENT, order_id int(11) NOT NULL DEFAULT '0', fee_label varchar(512) NOT NULL DEFAULT '', fee_rate float(15,3) NOT NULL DEFAULT '0.000', fee_total float(15,3) NOT NULL DEFAULT '0.000', PRIMARY KEY (order_fee_id), KEY order_id (order_id) ) $collate;" );

Safe to delete?

If you have uninstalled Shopping Cart & eCommerce Store, 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_ec_order_fee`;

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

Other tables from Shopping Cart & eCommerce Store