{"slug":"marketengine","name":"MarketEngine","description":"A free WordPress plugin that allows you to build a multi vendor marketplace platform for any niche.","author":"EngineThemes","active_installs":10,"version":"1.1","wp_org_url":"https://wordpress.org/plugins/marketengine/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"marketengine_custom_fields","full_table_name":"wp_marketengine_custom_fields","description":"Stores marketengine custom fields data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"marketengine_fields_relationship","full_table_name":"wp_marketengine_fields_relationship","description":"Stores marketengine fields relationship data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"marketengine_message_item","full_table_name":"wp_marketengine_message_item","description":"Stores marketengine message item data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"marketengine_message_itemmeta","full_table_name":"wp_marketengine_message_itemmeta","description":"Stores marketengine message itemmeta data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"marketengine_order_itemmeta","full_table_name":"wp_marketengine_order_itemmeta","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"marketengine_order_items","full_table_name":"wp_marketengine_order_items","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[{"name":"order_item_id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"order_item_name","type":"longtext","nullable":false,"primary_key":false},{"name":"order_item_type","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"marketengine_order_item_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false},{"name":"field_name","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"field_title","type":"longtext","nullable":false,"primary_key":false},{"name":"field_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"field_input_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"field_placeholder","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"field_description","type":"longtext","nullable":false,"primary_key":false},{"name":"field_help_text","type":"longtext","nullable":false,"primary_key":false},{"name":"field_constraint","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"field_default_value","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"count","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"term_taxonomy_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"term_order","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"session_key","type":"char(32)","nullable":false,"primary_key":false},{"name":"session_value","type":"longtext","nullable":false,"primary_key":false},{"name":"session_expiry","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"sender","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"receiver","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"post_date","type":"datetime","nullable":false,"primary_key":false},{"name":"post_date_gmt","type":"datetime","nullable":false,"primary_key":false},{"name":"post_content","type":"longtext","nullable":false,"primary_key":false},{"name":"post_title","type":"text","nullable":false,"primary_key":false},{"name":"post_excerpt","type":"text","nullable":false,"primary_key":false},{"name":"post_status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"post_password","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"post_name","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"post_modified","type":"datetime","nullable":false,"primary_key":false},{"name":"post_modified_gmt","type":"datetime","nullable":false,"primary_key":false},{"name":"post_content_filtered","type":"longtext","nullable":false,"primary_key":false},{"name":"post_parent","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"guid","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"post_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"post_mime_type","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"message_count","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"marketengine_message_item_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false}],"create_sql":"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);"},{"table_name":"marketengine_sessions","full_table_name":"wp_marketengine_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":7}