wp_ec_checkout_event
StaticStores ec checkout event data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑event_id | bigint(20) unsigned | NO |
| created_at | datetime | YES |
| event_type | varchar(20) | NO |
| reason | varchar(40) | NO |
| place | varchar(20) | NO |
| gateway | varchar(40) | NO |
| session_key | varchar(24) | NO |
| ip_key | varchar(24) | NO |
| email_key | varchar(24) | NO |
| card_key | varchar(24) | NO |
| ip_display | varchar(48) | NO |
| email_display | varchar(100) | NO |
| card_display | varchar(40) | NO |
| user_id | int(11) | NO |
| order_id | int(11) | NO |
| amount | float(15,3) | NO |
| ref | varchar(100) | NO |
| detail | varchar(255) | NO |
| in_attack | tinyint(1) | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS ec_checkout_event ( event_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, created_at datetime DEFAULT NULL, event_type varchar(20) NOT NULL DEFAULT '', reason varchar(40) NOT NULL DEFAULT '', place varchar(20) NOT NULL DEFAULT '', gateway varchar(40) NOT NULL DEFAULT '', session_key varchar(24) NOT NULL DEFAULT '', ip_key varchar(24) NOT NULL DEFAULT '', email_key varchar(24) NOT NULL DEFAULT '', card_key varchar(24) NOT NULL DEFAULT '', ip_display varchar(48) NOT NULL DEFAULT '', email_display varchar(100) NOT NULL DEFAULT '', card_display varchar(40) NOT NULL DEFAULT '', user_id int(11) NOT NULL DEFAULT '0', order_id int(11) NOT NULL DEFAULT '0', amount float(15,3) NOT NULL DEFAULT '0.000', ref varchar(100) NOT NULL DEFAULT '', detail varchar(255) NOT NULL DEFAULT '', in_attack tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (event_id), KEY created_at (created_at), KEY event_type (event_type,created_at), KEY session_key (session_key,created_at), KEY ip_key (ip_key,created_at), KEY email_key (email_key,created_at), KEY card_key (card_key,created_at), KEY ref (ref) ) $collate;"; $wpdb->query( $sql );
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_event`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP EasyCart: Shopping Cart and eCommerce Store