wp_ec_subscription_plan_tier
StaticStores ec subscription plan tier data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑tier_id | int(11) | NO |
| subscription_plan_id | int(11) | NO |
| tier_order | int(11) | NO |
| tier_name | varchar(255) | NO |
| tier_description | text | YES |
| button_label | varchar(255) | NO |
| is_popular | tinyint(1) | NO |
| trial_days | int(11) | NO |
| signup_fee | float(15,3) | NO |
| features | longtext | YES |
| tier_status | varchar(20) | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS ec_subscription_plan_tier ( tier_id int(11) NOT NULL AUTO_INCREMENT, subscription_plan_id int(11) NOT NULL DEFAULT '0', tier_order int(11) NOT NULL DEFAULT '0', tier_name varchar(255) NOT NULL DEFAULT '', tier_description text NULL, button_label varchar(255) NOT NULL DEFAULT '', is_popular tinyint(1) NOT NULL DEFAULT '0', trial_days int(11) NOT NULL DEFAULT '0', signup_fee float(15,3) NOT NULL DEFAULT '0.000', features longtext NULL, tier_status varchar(20) NOT NULL DEFAULT 'active', PRIMARY KEY (tier_id), KEY subscription_plan_id (subscription_plan_id) ) $collate;" );
Safe to delete?
If you have uninstalled WP EasyCart: Shopping Cart and 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_subscription_plan_tier`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP EasyCart: Shopping Cart and eCommerce Store