wp_marketengine_order_items
StaticStores order records and related transaction data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑order_item_id | bigint(20) | NO |
| order_item_name | longtext | NO |
| order_item_type | varchar(200) | NO |
| order_id | bigint(20) | NO |
| marketengine_order_item_id | bigint(20) | NO |
| meta_key | varchar(255) | YES |
| meta_value | longtext | YES |
| field_name | varchar(20) | NO |
| field_title | longtext | NO |
| field_type | varchar(20) | NO |
| field_input_type | varchar(20) | NO |
| field_placeholder | varchar(200) | NO |
| field_description | longtext | NO |
| field_help_text | longtext | NO |
| field_constraint | varchar(200) | NO |
| field_default_value | varchar(200) | NO |
| count | bigint(20) | NO |
| term_taxonomy_id | bigint(20) | NO |
| term_order | bigint(20) | YES |
| session_key | char(32) | NO |
| session_value | longtext | NO |
| session_expiry | bigint(20) | NO |
| sender | bigint(20) unsigned | NO |
| receiver | bigint(20) unsigned | NO |
| post_date | datetime | NO |
| post_date_gmt | datetime | NO |
| post_content | longtext | NO |
| post_title | text | NO |
| post_excerpt | text | NO |
| post_status | varchar(20) | NO |
| post_password | varchar(20) | NO |
| post_name | varchar(200) | NO |
| post_modified | datetime | NO |
| post_modified_gmt | datetime | NO |
| post_content_filtered | longtext | NO |
| post_parent | bigint(20) unsigned | NO |
| guid | varchar(255) | NO |
| post_type | varchar(20) | NO |
| post_mime_type | varchar(100) | NO |
| message_count | bigint(20) | NO |
| marketengine_message_item_id | bigint(20) | NO |
| meta_key | varchar(255) | YES |
| meta_value | longtext | YES |
CREATE TABLE Statement
CREATE TABLE wp_marketengine_order_items ( order_item_id bigint(20) NOT NULL auto_increment, order_item_name longtext NOT NULL, order_item_type varchar(200) NOT NULL DEFAULT '', order_id bigint(20) NOT NULL, PRIMARY KEY (order_item_id), KEY order_id (order_id) ) $collate; CREATE TABLE wp_marketengine_order_itemmeta ( meta_id bigint(20) NOT NULL auto_increment, marketengine_order_item_id bigint(20) NOT NULL, meta_key varchar(255) NULL, meta_value longtext NULL, PRIMARY KEY (meta_id), KEY marketengine_order_item_id (marketengine_order_item_id), KEY meta_key (meta_key) ) $collate; CREATE TABLE wp_marketengine_custom_fields ( field_id bigint(20) NOT NULL auto_increment, field_name varchar(20) NOT NULL UNIQUE, field_title longtext NOT NULL, field_type varchar(20) NOT NULL, field_input_type varchar(20) NOT NULL, field_placeholder varchar(200) NOT NULL default '', field_description longtext NOT NULL default '', field_help_text longtext NOT NULL default '', field_constraint varchar(200) NOT NULL default '', field_default_value varchar(200) NOT NULL default '', count bigint(20) NOT NULL default 0, PRIMARY KEY (field_id) ) $collate; CREATE TABLE wp_marketengine_fields_relationship ( field_id bigint(20) NOT NULL, term_taxonomy_id bigint(20) NOT NULL, term_order bigint(20) NULL, PRIMARY KEY (field_id, term_taxonomy_id) ) $collate; CREATE TABLE wp_marketengine_sessions ( session_id bigint(20) NOT NULL AUTO_INCREMENT, session_key char(32) NOT NULL, session_value longtext NOT NULL, session_expiry bigint(20) NOT NULL, UNIQUE KEY session_id (session_id), PRIMARY KEY (session_key) ) $collate; CREATE TABLE wp_marketengine_message_item ( ID bigint(20) unsigned NOT NULL auto_increment, sender bigint(20) unsigned NOT NULL default '0', receiver bigint(20) unsigned NOT NULL default '0', post_date datetime NOT NULL default '0000-00-00 00:00:00', post_date_gmt datetime NOT NULL default '0000-00-00 00:00:00', post_content longtext NOT NULL, post_title text NOT NULL, post_excerpt text NOT NULL, post_status varchar(20) NOT NULL default 'sent', post_password varchar(20) NOT NULL default '', post_name varchar(200) NOT NULL default '', post_modified datetime NOT NULL default '0000-00-00 00:00:00', post_modified_gmt datetime NOT NULL default '0000-00-00 00:00:00', post_content_filtered longtext NOT NULL, post_parent bigint(20) unsigned NOT NULL default '0', guid varchar(255) NOT NULL default '', post_type varchar(20) NOT NULL default 'message', post_mime_type varchar(100) NOT NULL default '', message_count bigint(20) NOT NULL default '0', PRIMARY KEY (ID), KEY post_name (post_name($max_index_length)), KEY type_status_date (post_status,post_date,ID), KEY post_parent (post_parent), KEY sender (sender) ) $collate; CREATE TABLE wp_marketengine_message_itemmeta ( meta_id bigint(20) NOT NULL auto_increment, marketengine_message_item_id bigint(20) NOT NULL, meta_key varchar(255) NULL, meta_value longtext NULL, PRIMARY KEY (meta_id), KEY marketengine_message_item_id (marketengine_message_item_id), KEY meta_key (meta_key) ) $collate; "; dbDelta($schemas);
Safe to delete?
If you have uninstalled MarketEngine, 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_marketengine_order_items`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from MarketEngine