wp_ec_fee

Static

Stores ec fee data created by this plugin.

Column Definitions

ColumnTypeNullable
🔑fee_idint(11)NO
fee_labelvarchar(512)NO
fee_admin_descriptiontextYES
fee_countrytextYES
fee_statetextYES
fee_ziptextYES
fee_citytextYES
fee_categorytextYES
fee_roletextYES
fee_zonetextYES
fee_typeint(11)NO
fee_ratefloat(15,3)NO
fee_pricefloat(15,3)NO
fee_minfloat(15,3)NO
fee_maxfloat(15,3)NO

CREATE TABLE Statement

CREATE TABLE ec_fee ( fee_id int(11) NOT NULL AUTO_INCREMENT, fee_label varchar(512) NOT NULL DEFAULT '', fee_admin_description text, fee_country text, fee_state text, fee_zip text, fee_city text, fee_category text, fee_role text, fee_zone text, fee_type int(11) NOT NULL DEFAULT '1', fee_rate float(15,3) NOT NULL DEFAULT '0.000', fee_price float(15,3) NOT NULL DEFAULT '0.000', fee_min float(15,3) NOT NULL DEFAULT '0.000', fee_max float(15,3) NOT NULL DEFAULT '-1.000', PRIMARY KEY (fee_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_fee`;

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

Other tables from Shopping Cart & eCommerce Store