wp_ec_order_transaction
StaticStores order records and related transaction data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑transaction_id | bigint(20) | NO |
| order_id | int(11) | NO |
| txn_type | varchar(10) | NO |
| amount | float(15,3) | NO |
| created_at | datetime | YES |
| source | varchar(40) | NO |
| gateway | varchar(40) | NO |
| reference | varchar(100) | NO |
| reason | varchar(255) | NO |
| details | text | YES |
| order_log_id | int(11) | NO |
| data | text | YES |
| version | varchar(64) | NO |
| updated_at | datetime | YES |
| product_id | int(11) | NO |
| variant_id | int(11) | NO |
| views | int(11) | NO |
| add_to_carts | int(11) | NO |
| term | varchar(100) | NO |
| searches | int(11) | NO |
| results | int(11) | NO |
| stat_date | date | NO |
| steps | varchar(40) | NO |
| step | varchar(20) | NO |
| sessions | int(11) | NO |
| source_type | varchar(20) | NO |
| visits | int(11) | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS ec_order_transaction ( transaction_id bigint(20) NOT NULL AUTO_INCREMENT, order_id int(11) NOT NULL DEFAULT '0', txn_type varchar(10) NOT NULL DEFAULT 'payment', amount float(15,3) NOT NULL DEFAULT '0.000', created_at datetime DEFAULT NULL, source varchar(40) NOT NULL DEFAULT '', gateway varchar(40) NOT NULL DEFAULT '', reference varchar(100) NOT NULL DEFAULT '', reason varchar(255) NOT NULL DEFAULT '', details text, order_log_id int(11) NOT NULL DEFAULT '0', PRIMARY KEY (transaction_id), KEY order_id (order_id), KEY txn_type_created (txn_type,created_at) ) $collate;", 'ec_report_day' => "CREATE TABLE IF NOT EXISTS ec_report_day ( stat_date date NOT NULL, data text, version varchar(64) NOT NULL DEFAULT '', updated_at datetime DEFAULT NULL, PRIMARY KEY (stat_date) ) $collate;", 'ec_report_product_day' => "CREATE TABLE IF NOT EXISTS ec_report_product_day ( stat_date date NOT NULL, product_id int(11) NOT NULL DEFAULT '0', variant_id int(11) NOT NULL DEFAULT '0', views int(11) NOT NULL DEFAULT '0', add_to_carts int(11) NOT NULL DEFAULT '0', PRIMARY KEY (stat_date,product_id,variant_id), KEY product_id (product_id) ) $collate;", 'ec_report_search_day' => "CREATE TABLE IF NOT EXISTS ec_report_search_day ( stat_date date NOT NULL, term varchar(100) NOT NULL DEFAULT '', searches int(11) NOT NULL DEFAULT '0', results int(11) NOT NULL DEFAULT '0', PRIMARY KEY (stat_date,term) ) $collate;", 'ec_report_session' => "CREATE TABLE IF NOT EXISTS ec_report_session ( session_key char(32) NOT NULL DEFAULT '', stat_date date NOT NULL, steps varchar(40) NOT NULL DEFAULT '', PRIMARY KEY (session_key), KEY stat_date (stat_date) ) $collate;", 'ec_report_step_day' => "CREATE TABLE IF NOT EXISTS ec_report_step_day ( stat_date date NOT NULL, step varchar(20) NOT NULL DEFAULT '', sessions int(11) NOT NULL DEFAULT '0', PRIMARY KEY (stat_date,step) ) $collate;", 'ec_report_visit_day' => "CREATE TABLE IF NOT EXISTS ec_report_visit_day ( stat_date date NOT NULL, source_type varchar(20) NOT NULL DEFAULT '', visits int(11) NOT NULL DEFAULT '0', PRIMARY KEY (stat_date,source_type) ) $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_order_transaction`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP EasyCart: Shopping Cart and eCommerce Store