wp_ec_checkout_field
StaticStores ec checkout field data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| field_key | varchar(64) | NO |
| field_type | varchar(32) | NO |
| placement | varchar(32) | NO |
| label | text | YES |
| settings | longtext | YES |
| conditions | longtext | YES |
| sort_order | int(11) | NO |
| status | varchar(16) | NO |
| created_date | datetime | YES |
| modified_date | datetime | YES |
| session_id | varchar(100) | NO |
| field_key | varchar(64) | NO |
| field_value | longtext | YES |
| modified_date | datetime | YES |
| order_id | int(11) | NO |
| orderdetail_id | int(11) | NO |
| repeat_index | int(11) | NO |
| field_key | varchar(64) | NO |
| field_type | varchar(32) | NO |
| field_label | text | YES |
| field_value | longtext | YES |
| display_value | longtext | YES |
| show_on | varchar(255) | NO |
| field_status | varchar(16) | NO |
| is_personal | tinyint(1) | NO |
| sort_order | int(11) | NO |
| created_date | datetime | YES |
| modified_date | datetime | YES |
| user_id | int(11) | NO |
| field_key | varchar(64) | NO |
| field_value | longtext | YES |
| modified_date | datetime | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS ec_checkout_field ( checkout_field_id int(11) NOT NULL AUTO_INCREMENT, field_key varchar(64) NOT NULL DEFAULT '', field_type varchar(32) NOT NULL DEFAULT 'text', placement varchar(32) NOT NULL DEFAULT 'order_notes', label text, settings longtext, conditions longtext, sort_order int(11) NOT NULL DEFAULT '0', status varchar(16) NOT NULL DEFAULT 'active', created_date datetime DEFAULT NULL, modified_date datetime DEFAULT NULL, PRIMARY KEY (checkout_field_id), UNIQUE KEY field_key (field_key), KEY placement_sort (placement,sort_order) ) $collate;", 'ec_tempcart_field' => "CREATE TABLE IF NOT EXISTS ec_tempcart_field ( tempcart_field_id int(11) NOT NULL AUTO_INCREMENT, session_id varchar(100) NOT NULL DEFAULT '', field_key varchar(64) NOT NULL DEFAULT '', field_value longtext, modified_date datetime DEFAULT NULL, PRIMARY KEY (tempcart_field_id), UNIQUE KEY session_field (session_id,field_key), KEY modified_date (modified_date) ) $collate;", 'ec_order_field' => "CREATE TABLE IF NOT EXISTS ec_order_field ( order_field_id int(11) NOT NULL AUTO_INCREMENT, order_id int(11) NOT NULL DEFAULT '0', orderdetail_id int(11) NOT NULL DEFAULT '0', repeat_index int(11) NOT NULL DEFAULT '0', checkout_field_id int(11) NOT NULL DEFAULT '0', field_key varchar(64) NOT NULL DEFAULT '', field_type varchar(32) NOT NULL DEFAULT '', field_label text, field_value longtext, display_value longtext, show_on varchar(255) NOT NULL DEFAULT '', field_status varchar(16) NOT NULL DEFAULT '', is_personal tinyint(1) NOT NULL DEFAULT '0', sort_order int(11) NOT NULL DEFAULT '0', created_date datetime DEFAULT NULL, modified_date datetime DEFAULT NULL, PRIMARY KEY (order_field_id), KEY order_id (order_id), KEY field_key (field_key) ) $collate;", 'ec_user_field' => "CREATE TABLE IF NOT EXISTS ec_user_field ( user_field_id int(11) NOT NULL AUTO_INCREMENT, user_id int(11) NOT NULL DEFAULT '0', field_key varchar(64) NOT NULL DEFAULT '', field_value longtext, modified_date datetime DEFAULT NULL, PRIMARY KEY (user_field_id), UNIQUE KEY user_field (user_id,field_key) ) $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_checkout_field`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP EasyCart: Shopping Cart and eCommerce Store