{"slug":"woocommerce","name":"WooCommerce","description":"Everything you need to launch an online store in days and keep it growing for years. From your first sale to millions in revenue, Woo is with you.","author":"Automattic","active_installs":7000000,"version":"11.2.1","wp_org_url":"https://wordpress.org/plugins/woocommerce/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"actionscheduler_actions","full_table_name":"wp_actionscheduler_actions","description":"Stores actionscheduler actions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"actionscheduler_logs","full_table_name":"wp_actionscheduler_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wc_admin_note_actions","full_table_name":"wp_wc_admin_note_actions","description":"Stores wc admin note actions data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"wc_admin_notes","full_table_name":"wp_wc_admin_notes","description":"Stores wc admin notes data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wc_category_lookup","full_table_name":"wp_wc_category_lookup","description":"Stores wc category lookup data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"wc_customer_lookup","full_table_name":"wp_wc_customer_lookup","description":"Stores wc customer lookup data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"wc_download_log","full_table_name":"wp_wc_download_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"wc_email_unsubscribes","full_table_name":"wp_wc_email_unsubscribes","description":"Stores wc email unsubscribes data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wc_order_addresses","full_table_name":"wp_wc_order_addresses","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wc_order_coupon_lookup","full_table_name":"wp_wc_order_coupon_lookup","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wc_order_fulfillment_meta","full_table_name":"wp_wc_order_fulfillment_meta","description":"Stores additional metadata (key-value pairs) for wc order fulfillment records.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"wc_order_fulfillments","full_table_name":"wp_wc_order_fulfillments","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[{"name":"fulfillment_id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"entity_type","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"entity_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"status","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"is_fulfilled","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"date_updated","type":"datetime","nullable":false,"primary_key":false},{"name":"date_deleted","type":"datetime","nullable":true,"primary_key":false},{"name":"fulfillment_id","type":"bigint(20) unsigned","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":"date_updated","type":"datetime","nullable":false,"primary_key":false},{"name":"date_deleted","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_wc_order_fulfillments ( fulfillment_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, entity_type varchar(255) NOT NULL, entity_id bigint(20) unsigned NOT NULL, status varchar(255) NOT NULL, is_fulfilled tinyint(1) NOT NULL DEFAULT 0, date_updated datetime NOT NULL, date_deleted datetime NULL, PRIMARY KEY (fulfillment_id), KEY entity_type_id (entity_type({$max_index_length}), entity_id) ) $collate; CREATE TABLE wp_wc_order_fulfillment_meta ( meta_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, fulfillment_id bigint(20) unsigned NOT NULL, meta_key varchar(255) NULL, meta_value longtext NULL, date_updated datetime NOT NULL, date_deleted datetime NULL, PRIMARY KEY (meta_id), KEY meta_key (meta_key({$max_index_length})), KEY fulfillment_id (fulfillment_id) ) $collate;\"; $database_util->dbdelta( $schema );"},{"table_name":"wc_order_operational_data","full_table_name":"wp_wc_order_operational_data","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wc_order_product_lookup","full_table_name":"wp_wc_order_product_lookup","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"wc_order_stats","full_table_name":"wp_wc_order_stats","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[{"name":"order_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"parent_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"date_created","type":"datetime","nullable":false,"primary_key":false},{"name":"date_created_gmt","type":"datetime","nullable":false,"primary_key":false},{"name":"date_paid","type":"datetime","nullable":true,"primary_key":false},{"name":"date_completed","type":"datetime","nullable":true,"primary_key":false},{"name":"num_items_sold","type":"int(11)","nullable":false,"primary_key":false},{"name":"total_sales","type":"double","nullable":false,"primary_key":false},{"name":"tax_total","type":"double","nullable":false,"primary_key":false},{"name":"shipping_total","type":"double","nullable":false,"primary_key":false},{"name":"net_total","type":"double","nullable":false,"primary_key":false},{"name":"returning_customer","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"customer_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_wc_order_stats ( order_id bigint(20) unsigned NOT NULL, parent_id bigint(20) unsigned DEFAULT 0 NOT NULL, date_created datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, date_created_gmt datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, date_paid datetime DEFAULT '0000-00-00 00:00:00', date_completed datetime DEFAULT '0000-00-00 00:00:00', num_items_sold int(11) DEFAULT 0 NOT NULL, total_sales double DEFAULT 0 NOT NULL, tax_total double DEFAULT 0 NOT NULL, shipping_total double DEFAULT 0 NOT NULL, net_total double DEFAULT 0 NOT NULL, returning_customer tinyint(1) DEFAULT NULL, status varchar(20) NOT NULL, customer_id bigint(20) unsigned NOT NULL\" . ( $should_have_fulfillment_column ? ', fulfillment_status varchar(50) DEFAULT NULL' : '' ) . ', PRIMARY KEY (order_id), KEY date_created (date_created), KEY customer_id (customer_id), KEY status (status)' . ( $should_have_fulfillment_column ? ', KEY fulfillment_status (fulfillment_status)' : '' ) . \", KEY idx_date_paid_status_parent (date_paid, status, parent_id) ) $collate;\"; } /** * Delete obsolete notes. * * @return void */ public static function delete_obsolete_notes() { global $wpdb; $obsolete_notes_names = array( 'wc-admin-welcome-note', 'wc-admin-insight-first-product-and-payment', 'wc-admin-store-notice-setting-moved', 'wc-admin-store-notice-giving-feedback', 'wc-admin-first-downloadable-product', 'wc-admin-learn-more-about-product-settings', 'wc-admin-adding-and-managing-products', 'wc-admin-onboarding-profiler-reminder', 'wc-admin-historical-data', 'wc-admin-manage-store-activity-from-home-screen', 'wc-admin-review-shipping-settings', 'wc-admin-home-screen-feedback', 'wc-admin-update-store-details', 'wc-admin-effortless-payments-by-mollie', 'wc-admin-google-ads-and-marketing', 'wc-admin-insight-first-sale', 'wc-admin-marketing-intro', 'wc-admin-draw-attention', 'wc-admin-welcome-to-woocommerce-for-store-users', 'wc-admin-need-some-inspiration', 'wc-admin-choose-niche', 'wc-admin-start-dropshipping-business', 'wc-admin-filter-by-product-variations-in-reports', 'wc-admin-learn-more-about-variable-products', 'wc-admin-getting-started-ecommerce-webinar', 'wc-admin-navigation-feedback', 'wc-admin-navigation-feedback-follow-up', 'wc-admin-set-up-additional-payment-types', 'wc-admin-deactivate-plugin', 'wc-admin-complete-store-details', 'wc-admin-choosing-a-theme', );"},{"table_name":"wc_order_tax_lookup","full_table_name":"wp_wc_order_tax_lookup","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wc_orders","full_table_name":"wp_wc_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wc_orders_meta","full_table_name":"wp_wc_orders_meta","description":"Stores additional metadata (key-value pairs) for wc orders records.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wc_product_attributes_lookup","full_table_name":"wp_wc_product_attributes_lookup","description":"Stores product records and related data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"wc_product_download_directories","full_table_name":"wp_wc_product_download_directories","description":"Stores product records and related data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"wc_product_meta_lookup","full_table_name":"wp_wc_product_meta_lookup","description":"Stores additional metadata (key-value pairs) for wc product meta lookup records.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"wc_rate_limits","full_table_name":"wp_wc_rate_limits","description":"Stores wc rate limits data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wc_reserved_stock","full_table_name":"wp_wc_reserved_stock","description":"Stores wc reserved stock data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"order_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"product_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"stock_quantity","type":"double","nullable":false,"primary_key":false},{"name":"timestamp","type":"datetime","nullable":false,"primary_key":false},{"name":"expires","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_wc_reserved_stock ( `order_id` bigint(20) NOT NULL, `product_id` bigint(20) NOT NULL, `stock_quantity` double NOT NULL DEFAULT 0, `timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `expires` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`order_id`, `product_id`), KEY product_id_expires (product_id, expires) ) $collate; \" );"},{"table_name":"wc_stock_notifications","full_table_name":"wp_wc_stock_notifications","description":"Stores wc stock notifications data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wc_tax_rate_classes","full_table_name":"wp_wc_tax_rate_classes","description":"Stores wc tax rate classes data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"wc_webhooks","full_table_name":"wp_wc_webhooks","description":"Stores wc webhooks data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"woocommerce_api_keys","full_table_name":"wp_woocommerce_api_keys","description":"Stores woocommerce api keys data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"woocommerce_attribute_taxonomies","full_table_name":"wp_woocommerce_attribute_taxonomies","description":"Stores woocommerce attribute taxonomies data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"woocommerce_downloadable_product_permissions","full_table_name":"wp_woocommerce_downloadable_product_permissions","description":"Stores product records and related data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"woocommerce_log","full_table_name":"wp_woocommerce_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"woocommerce_order_itemmeta","full_table_name":"wp_woocommerce_order_itemmeta","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"woocommerce_order_items","full_table_name":"wp_woocommerce_order_items","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"woocommerce_payment_tokenmeta","full_table_name":"wp_woocommerce_payment_tokenmeta","description":"Stores access tokens for authentication or API access.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"woocommerce_payment_tokens","full_table_name":"wp_woocommerce_payment_tokens","description":"Stores access tokens for authentication or API access.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"woocommerce_sessions","full_table_name":"wp_woocommerce_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[{"name":"session_id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"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) unsigned","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"description","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"permissions","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"consumer_key","type":"char(64)","nullable":false,"primary_key":false},{"name":"consumer_secret","type":"char(43)","nullable":false,"primary_key":false},{"name":"nonces","type":"longtext","nullable":true,"primary_key":false},{"name":"truncated_key","type":"char(7)","nullable":false,"primary_key":false},{"name":"last_access","type":"datetime","nullable":true,"primary_key":false},{"name":"attribute_name","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"attribute_label","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"attribute_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"attribute_orderby","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"attribute_public","type":"int(1)","nullable":false,"primary_key":false},{"name":"download_id","type":"varchar(36)","nullable":false,"primary_key":false},{"name":"product_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"order_key","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"user_email","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"downloads_remaining","type":"varchar(9)","nullable":true,"primary_key":false},{"name":"access_granted","type":"datetime","nullable":false,"primary_key":false},{"name":"access_expires","type":"datetime","nullable":true,"primary_key":false},{"name":"download_count","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"order_item_name","type":"text","nullable":false,"primary_key":false},{"name":"order_item_type","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"order_item_id","type":"bigint(20) unsigned","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":"tax_rate_country","type":"varchar(2)","nullable":false,"primary_key":false},{"name":"tax_rate_state","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"tax_rate","type":"varchar(8)","nullable":false,"primary_key":false},{"name":"tax_rate_name","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"tax_rate_priority","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"tax_rate_compound","type":"int(1)","nullable":false,"primary_key":false},{"name":"tax_rate_shipping","type":"int(1)","nullable":false,"primary_key":false},{"name":"tax_rate_order","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"tax_rate_class","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"location_code","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"tax_rate_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"location_type","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"zone_name","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"zone_order","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"zone_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"location_code","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"location_type","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"instance_id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"method_id","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"method_order","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"is_enabled","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"gateway_id","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"token","type":"text","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"type","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"is_default","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"payment_token_id","type":"bigint(20) unsigned","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":"timestamp","type":"datetime","nullable":false,"primary_key":false},{"name":"level","type":"smallint(4)","nullable":false,"primary_key":false},{"name":"source","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"message","type":"longtext","nullable":false,"primary_key":false},{"name":"context","type":"longtext","nullable":true,"primary_key":false},{"name":"status","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"name","type":"text","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"delivery_url","type":"text","nullable":false,"primary_key":false},{"name":"secret","type":"text","nullable":false,"primary_key":false},{"name":"topic","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"date_created","type":"datetime","nullable":false,"primary_key":false},{"name":"date_created_gmt","type":"datetime","nullable":false,"primary_key":false},{"name":"date_modified","type":"datetime","nullable":false,"primary_key":false},{"name":"date_modified_gmt","type":"datetime","nullable":false,"primary_key":false},{"name":"api_version","type":"smallint(4)","nullable":false,"primary_key":false},{"name":"failure_count","type":"smallint(10)","nullable":false,"primary_key":false},{"name":"pending_delivery","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"timestamp","type":"datetime","nullable":false,"primary_key":false},{"name":"permission_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"user_ip_address","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"sku","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"global_unique_id","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"virtual","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"downloadable","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"min_price","type":"decimal(19,4)","nullable":true,"primary_key":false},{"name":"max_price","type":"decimal(19,4)","nullable":true,"primary_key":false},{"name":"onsale","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"stock_quantity","type":"double","nullable":true,"primary_key":false},{"name":"stock_status","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"rating_count","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"average_rating","type":"decimal(3,2)","nullable":true,"primary_key":false},{"name":"total_sales","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"tax_status","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"tax_class","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"slug","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"product_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"stock_quantity","type":"double","nullable":false,"primary_key":false},{"name":"timestamp","type":"datetime","nullable":false,"primary_key":false},{"name":"expires","type":"datetime","nullable":false,"primary_key":false},{"name":"rate_limit_key","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"rate_limit_expiry","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"rate_limit_remaining","type":"smallint(10)","nullable":false,"primary_key":false},{"name":"url","type":"varchar(256)","nullable":false,"primary_key":false},{"name":"enabled","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"product_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"variation_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"customer_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"date_created","type":"datetime","nullable":false,"primary_key":false},{"name":"product_qty","type":"int(11)","nullable":false,"primary_key":false},{"name":"product_net_revenue","type":"double","nullable":false,"primary_key":false},{"name":"product_gross_revenue","type":"double","nullable":false,"primary_key":false},{"name":"coupon_amount","type":"double","nullable":false,"primary_key":false},{"name":"tax_amount","type":"double","nullable":false,"primary_key":false},{"name":"shipping_amount","type":"double","nullable":false,"primary_key":false},{"name":"shipping_tax_amount","type":"double","nullable":false,"primary_key":false},{"name":"tax_rate_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"order_item_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"date_created","type":"datetime","nullable":false,"primary_key":false},{"name":"shipping_tax","type":"double","nullable":false,"primary_key":false},{"name":"order_tax","type":"double","nullable":false,"primary_key":false},{"name":"total_tax","type":"double","nullable":false,"primary_key":false},{"name":"taxable_amount","type":"double","nullable":false,"primary_key":false},{"name":"coupon_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"date_created","type":"datetime","nullable":false,"primary_key":false},{"name":"discount_amount","type":"double","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"locale","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"title","type":"longtext","nullable":false,"primary_key":false},{"name":"content","type":"longtext","nullable":false,"primary_key":false},{"name":"content_data","type":"longtext","nullable":true,"primary_key":false},{"name":"status","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"source","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"date_created","type":"datetime","nullable":false,"primary_key":false},{"name":"date_reminder","type":"datetime","nullable":true,"primary_key":false},{"name":"is_snoozable","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"layout","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"image","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"is_deleted","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_read","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"icon","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"note_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"label","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"query","type":"longtext","nullable":false,"primary_key":false},{"name":"status","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"actioned_text","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"nonce_action","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"nonce_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"username","type":"varchar(60)","nullable":false,"primary_key":false},{"name":"first_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"last_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"date_last_active","type":"timestamp","nullable":true,"primary_key":false},{"name":"date_registered","type":"timestamp","nullable":true,"primary_key":false},{"name":"country","type":"char(2)","nullable":false,"primary_key":false},{"name":"postcode","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"city","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"state","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"billing_phone","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"shipping_phone","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"category_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_woocommerce_sessions ( session_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, session_key char(32) NOT NULL, session_value longtext NOT NULL, session_expiry bigint(20) unsigned NOT NULL, PRIMARY KEY (session_id), KEY session_expiry (session_expiry), UNIQUE KEY session_key (session_key) ) $collate; CREATE TABLE wp_woocommerce_api_keys ( key_id bigint(20) unsigned NOT NULL auto_increment, user_id bigint(20) unsigned NOT NULL, description varchar(200) NULL, permissions varchar(10) NOT NULL, consumer_key char(64) NOT NULL, consumer_secret char(43) NOT NULL, nonces longtext NULL, truncated_key char(7) NOT NULL, last_access datetime NULL default null, PRIMARY KEY (key_id), KEY consumer_key (consumer_key), KEY consumer_secret (consumer_secret) ) $collate; CREATE TABLE wp_woocommerce_attribute_taxonomies ( attribute_id bigint(20) unsigned NOT NULL auto_increment, attribute_name varchar(200) NOT NULL, attribute_label varchar(200) NULL, attribute_type varchar(20) NOT NULL, attribute_orderby varchar(20) NOT NULL, attribute_public int(1) NOT NULL DEFAULT 1, PRIMARY KEY (attribute_id), KEY attribute_name (attribute_name(20)) ) $collate; CREATE TABLE wp_woocommerce_downloadable_product_permissions ( permission_id bigint(20) unsigned NOT NULL auto_increment, download_id varchar(36) NOT NULL, product_id bigint(20) unsigned NOT NULL, order_id bigint(20) unsigned NOT NULL DEFAULT 0, order_key varchar(200) NOT NULL, user_email varchar(200) NOT NULL, user_id bigint(20) unsigned NULL, downloads_remaining varchar(9) NULL, access_granted datetime NOT NULL default '0000-00-00 00:00:00', access_expires datetime NULL default null, download_count bigint(20) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (permission_id), KEY download_order_key_product (product_id,order_id,order_key(16),download_id), KEY download_order_product (download_id,order_id,product_id), KEY order_id (order_id), KEY user_order_remaining_expires (user_id,order_id,downloads_remaining,access_expires), KEY idx_user_email (user_email(100)) ) $collate; CREATE TABLE wp_woocommerce_order_items ( order_item_id bigint(20) unsigned NOT NULL auto_increment, order_item_name text NOT NULL, order_item_type varchar(200) NOT NULL DEFAULT '', order_id bigint(20) unsigned NOT NULL, PRIMARY KEY (order_item_id), KEY order_id (order_id) ) $collate; CREATE TABLE wp_woocommerce_order_itemmeta ( meta_id bigint(20) unsigned NOT NULL auto_increment, order_item_id bigint(20) unsigned NOT NULL, meta_key varchar(255) default NULL, meta_value longtext NULL, PRIMARY KEY (meta_id), KEY order_item_id (order_item_id), KEY meta_key (meta_key(32)) ) $collate; CREATE TABLE wp_woocommerce_tax_rates ( tax_rate_id bigint(20) unsigned NOT NULL auto_increment, tax_rate_country varchar(2) NOT NULL DEFAULT '', tax_rate_state varchar(200) NOT NULL DEFAULT '', tax_rate varchar(8) NOT NULL DEFAULT '', tax_rate_name varchar(200) NOT NULL DEFAULT '', tax_rate_priority bigint(20) unsigned NOT NULL, tax_rate_compound int(1) NOT NULL DEFAULT 0, tax_rate_shipping int(1) NOT NULL DEFAULT 1, tax_rate_order bigint(20) unsigned NOT NULL, tax_rate_class varchar(200) NOT NULL DEFAULT '', PRIMARY KEY (tax_rate_id), KEY tax_rate_country (tax_rate_country), KEY tax_rate_state (tax_rate_state(2)), KEY tax_rate_class (tax_rate_class(10)), KEY tax_rate_priority (tax_rate_priority) ) $collate; CREATE TABLE wp_woocommerce_tax_rate_locations ( location_id bigint(20) unsigned NOT NULL auto_increment, location_code varchar(200) NOT NULL, tax_rate_id bigint(20) unsigned NOT NULL, location_type varchar(40) NOT NULL, PRIMARY KEY (location_id), KEY tax_rate_id (tax_rate_id), KEY location_type_code (location_type(10),location_code(20)) ) $collate; CREATE TABLE wp_woocommerce_shipping_zones ( zone_id bigint(20) unsigned NOT NULL auto_increment, zone_name varchar(200) NOT NULL, zone_order bigint(20) unsigned NOT NULL, PRIMARY KEY (zone_id), KEY zone_order_id (zone_order, zone_id) ) $collate; CREATE TABLE wp_woocommerce_shipping_zone_locations ( location_id bigint(20) unsigned NOT NULL auto_increment, zone_id bigint(20) unsigned NOT NULL, location_code varchar(200) NOT NULL, location_type varchar(40) NOT NULL, PRIMARY KEY (location_id), KEY zone_id (zone_id), KEY location_type_code (location_type(10),location_code(20)) ) $collate; CREATE TABLE wp_woocommerce_shipping_zone_methods ( zone_id bigint(20) unsigned NOT NULL, instance_id bigint(20) unsigned NOT NULL auto_increment, method_id varchar(200) NOT NULL, method_order bigint(20) unsigned NOT NULL, is_enabled tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (instance_id), KEY zone_id (zone_id), KEY method_id (method_id(20)) ) $collate; CREATE TABLE wp_woocommerce_payment_tokens ( token_id bigint(20) unsigned NOT NULL auto_increment, gateway_id varchar(200) NOT NULL, token text NOT NULL, user_id bigint(20) unsigned NOT NULL DEFAULT '0', type varchar(200) NOT NULL, is_default tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (token_id), KEY user_id (user_id) ) $collate; CREATE TABLE wp_woocommerce_payment_tokenmeta ( meta_id bigint(20) unsigned NOT NULL auto_increment, payment_token_id bigint(20) unsigned NOT NULL, meta_key varchar(255) NULL, meta_value longtext NULL, PRIMARY KEY (meta_id), KEY payment_token_id (payment_token_id), KEY meta_key (meta_key(32)) ) $collate; CREATE TABLE wp_woocommerce_log ( log_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, timestamp datetime NOT NULL, level smallint(4) NOT NULL, source varchar(200) NOT NULL, message longtext NOT NULL, context longtext NULL, PRIMARY KEY (log_id), KEY level (level) ) $collate; CREATE TABLE wp_wc_webhooks ( webhook_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, status varchar(200) NOT NULL, name text NOT NULL, user_id bigint(20) unsigned NOT NULL, delivery_url text NOT NULL, secret text NOT NULL, topic varchar(200) NOT NULL, date_created datetime NOT NULL DEFAULT '0000-00-00 00:00:00', date_created_gmt datetime NOT NULL DEFAULT '0000-00-00 00:00:00', date_modified datetime NOT NULL DEFAULT '0000-00-00 00:00:00', date_modified_gmt datetime NOT NULL DEFAULT '0000-00-00 00:00:00', api_version smallint(4) NOT NULL, failure_count smallint(10) NOT NULL DEFAULT '0', pending_delivery tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (webhook_id), KEY user_id (user_id) ) $collate; CREATE TABLE wp_wc_download_log ( download_log_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, timestamp datetime NOT NULL, permission_id bigint(20) unsigned NOT NULL, user_id bigint(20) unsigned NULL, user_ip_address varchar(100) NULL DEFAULT '', PRIMARY KEY (download_log_id), KEY permission_id (permission_id), KEY timestamp (timestamp) ) $collate; CREATE TABLE wp_wc_product_meta_lookup ( `product_id` bigint(20) NOT NULL, `sku` varchar(100) NULL default '', `global_unique_id` varchar(100) NULL default '', `virtual` tinyint(1) NULL default 0, `downloadable` tinyint(1) NULL default 0, `min_price` decimal(19,4) NULL default NULL, `max_price` decimal(19,4) NULL default NULL, `onsale` tinyint(1) NULL default 0, `stock_quantity` double NULL default NULL, `stock_status` varchar(100) NULL default 'instock', `rating_count` bigint(20) NULL default 0, `average_rating` decimal(3,2) NULL default 0.00, `total_sales` bigint(20) NULL default 0, `tax_status` varchar(100) NULL default 'taxable', `tax_class` varchar(100) NULL default '', PRIMARY KEY (`product_id`), KEY `virtual` (`virtual`), KEY `downloadable` (`downloadable`), KEY `stock_status` (`stock_status`), KEY `stock_quantity` (`stock_quantity`), KEY `onsale` (`onsale`), KEY min_max_price (`min_price`, `max_price`), KEY sku (sku(50)), KEY global_unique_id (global_unique_id(50)) ) $collate; CREATE TABLE wp_wc_tax_rate_classes ( tax_rate_class_id bigint(20) unsigned NOT NULL auto_increment, name varchar(200) NOT NULL DEFAULT '', slug varchar(200) NOT NULL DEFAULT '', PRIMARY KEY (tax_rate_class_id), UNIQUE KEY slug (slug($max_index_length)) ) $collate; CREATE TABLE wp_wc_reserved_stock ( `order_id` bigint(20) NOT NULL, `product_id` bigint(20) NOT NULL, `stock_quantity` double NOT NULL DEFAULT 0, `timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `expires` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`order_id`, `product_id`), KEY product_id_expires (product_id, expires) ) $collate; CREATE TABLE wp_wc_rate_limits ( rate_limit_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, rate_limit_key varchar(200) NOT NULL, rate_limit_expiry bigint(20) unsigned NOT NULL, rate_limit_remaining smallint(10) NOT NULL DEFAULT '0', PRIMARY KEY (rate_limit_id), UNIQUE KEY rate_limit_key (rate_limit_key($max_index_length)) ) $collate; $product_attributes_lookup_table_creation_sql CREATE TABLE wp_wc_product_download_directories ( url_id bigint(20) unsigned NOT NULL auto_increment, url varchar(256) NOT NULL, enabled tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (url_id), KEY url (url($max_index_length)) ) $collate; $order_stats_table_schema CREATE TABLE wp_wc_order_product_lookup ( order_item_id bigint(20) unsigned NOT NULL, order_id bigint(20) unsigned NOT NULL, product_id bigint(20) unsigned NOT NULL, variation_id bigint(20) unsigned NOT NULL, customer_id bigint(20) unsigned NULL, date_created datetime $datetime_default NOT NULL, product_qty int(11) NOT NULL, product_net_revenue double DEFAULT 0 NOT NULL, product_gross_revenue double DEFAULT 0 NOT NULL, coupon_amount double DEFAULT 0 NOT NULL, tax_amount double DEFAULT 0 NOT NULL, shipping_amount double DEFAULT 0 NOT NULL, shipping_tax_amount double DEFAULT 0 NOT NULL, PRIMARY KEY (order_item_id, order_id), KEY order_id (order_id), KEY product_id (product_id), KEY customer_id (customer_id), KEY date_created (date_created), KEY customer_product_date (customer_id, product_id, date_created) ) $collate; CREATE TABLE wp_wc_order_tax_lookup ( order_id bigint(20) unsigned NOT NULL, tax_rate_id bigint(20) unsigned NOT NULL, order_item_id bigint(20) unsigned NOT NULL DEFAULT 0, date_created datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, shipping_tax double DEFAULT 0 NOT NULL, order_tax double DEFAULT 0 NOT NULL, total_tax double DEFAULT 0 NOT NULL, taxable_amount double DEFAULT 0 NOT NULL, PRIMARY KEY (order_id, tax_rate_id, order_item_id), KEY tax_rate_id (tax_rate_id), KEY date_created (date_created) ) $collate; CREATE TABLE wp_wc_order_coupon_lookup ( order_id bigint(20) unsigned NOT NULL, coupon_id bigint(20) NOT NULL, date_created datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, discount_amount double DEFAULT 0 NOT NULL, PRIMARY KEY (order_id, coupon_id), KEY coupon_id (coupon_id), KEY date_created (date_created) ) $collate; CREATE TABLE wp_wc_admin_notes ( note_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, type varchar(20) NOT NULL, locale varchar(20) NOT NULL, title longtext NOT NULL, content longtext NOT NULL, content_data longtext NULL default null, status varchar(200) NOT NULL, source varchar(200) NOT NULL, date_created datetime NOT NULL default '0000-00-00 00:00:00', date_reminder datetime NULL default null, is_snoozable tinyint(1) DEFAULT 0 NOT NULL, layout varchar(20) DEFAULT '' NOT NULL, image varchar(200) NULL DEFAULT NULL, is_deleted tinyint(1) DEFAULT 0 NOT NULL, is_read tinyint(1) DEFAULT 0 NOT NULL, icon varchar(200) NOT NULL default 'info', PRIMARY KEY (note_id) ) $collate; CREATE TABLE wp_wc_admin_note_actions ( action_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, note_id bigint(20) unsigned NOT NULL, name varchar(255) NOT NULL, label varchar(255) NOT NULL, query longtext NOT NULL, status varchar(255) NOT NULL, actioned_text varchar(255) NOT NULL, nonce_action varchar(255) NULL DEFAULT NULL, nonce_name varchar(255) NULL DEFAULT NULL, PRIMARY KEY (action_id), KEY note_id (note_id) ) $collate; CREATE TABLE wp_wc_customer_lookup ( customer_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned DEFAULT NULL, username varchar(60) DEFAULT '' NOT NULL, first_name varchar(255) NOT NULL, last_name varchar(255) NOT NULL, email varchar(100) NULL default NULL, date_last_active timestamp NULL default null, date_registered timestamp NULL default null, country char(2) DEFAULT '' NOT NULL, postcode varchar(20) DEFAULT '' NOT NULL, city varchar(100) DEFAULT '' NOT NULL, state varchar(100) DEFAULT '' NOT NULL, billing_phone varchar(100) DEFAULT '' NOT NULL, shipping_phone varchar(100) DEFAULT '' NOT NULL, PRIMARY KEY (customer_id), UNIQUE KEY user_id (user_id), KEY email (email) ) $collate; CREATE TABLE wp_wc_category_lookup ( category_tree_id bigint(20) unsigned NOT NULL, category_id bigint(20) unsigned NOT NULL, PRIMARY KEY (category_tree_id,category_id) ) $collate; $hpos_table_schema; $stock_notifications_table_schema; \"; return $tables; } /** * Return a list of WooCommerce tables. Used to make sure all WC tables are dropped when uninstalling the plugin * in a single site or multi site environment. * * @return array WC tables. */ public static function get_tables() { global $wpdb; $tables = array( \"wp_wc_download_log\", \"wp_wc_product_download_directories\", \"wp_wc_product_meta_lookup\", \"wp_wc_tax_rate_classes\", \"wp_wc_webhooks\", \"wp_woocommerce_api_keys\", \"wp_woocommerce_attribute_taxonomies\", \"wp_woocommerce_downloadable_product_permissions\", \"wp_woocommerce_log\", \"wp_woocommerce_order_itemmeta\", \"wp_woocommerce_order_items\", \"wp_woocommerce_payment_tokenmeta\", \"wp_woocommerce_payment_tokens\", \"wp_woocommerce_sessions\", \"wp_woocommerce_shipping_zone_locations\", \"wp_woocommerce_shipping_zone_methods\", \"wp_woocommerce_shipping_zones\", \"wp_woocommerce_tax_rate_locations\", \"wp_woocommerce_tax_rates\", \"wp_wc_reserved_stock\", \"wp_wc_rate_limits\", \"wp_wc_product_attributes_lookup\", \"wp_wc_stock_notifications\", \"wp_wc_stock_notificationmeta\", /* * No longer created: the abandoned cart recovery feature that owned this table was * removed in 11.2.0. It stays listed here so that a site which uninstalls before the * removal migration has run is not left with an orphaned table. */ \"wp_wc_email_unsubscribes\", // WCA Tables. \"wp_wc_order_stats\", \"wp_wc_order_product_lookup\", \"wp_wc_order_tax_lookup\", \"wp_wc_order_coupon_lookup\", \"wp_wc_admin_notes\", \"wp_wc_admin_note_actions\", \"wp_wc_customer_lookup\", \"wp_wc_category_lookup\", \"wp_wc_order_fulfillments\", \"wp_wc_order_fulfillment_meta\", // HPOS. \"wp_wc_orders\", \"wp_wc_order_addresses\", \"wp_wc_order_operational_data\", \"wp_wc_orders_meta\", );"},{"table_name":"woocommerce_shipping_flat_rate_boxes","full_table_name":"wp_woocommerce_shipping_flat_rate_boxes","description":"Stores woocommerce shipping flat rate boxes data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"woocommerce_shipping_table_rates","full_table_name":"wp_woocommerce_shipping_table_rates","description":"Stores woocommerce shipping table rates data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"woocommerce_shipping_zone_locations","full_table_name":"wp_woocommerce_shipping_zone_locations","description":"Stores woocommerce shipping zone locations data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"woocommerce_shipping_zone_methods","full_table_name":"wp_woocommerce_shipping_zone_methods","description":"Stores woocommerce shipping zone methods data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"woocommerce_shipping_zones","full_table_name":"wp_woocommerce_shipping_zones","description":"Stores woocommerce shipping zones data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"woocommerce_tax_rate_locations","full_table_name":"wp_woocommerce_tax_rate_locations","description":"Stores woocommerce tax rate locations data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"woocommerce_tax_rates","full_table_name":"wp_woocommerce_tax_rates","description":"Stores woocommerce tax rates data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":42}