wp_woo_sr_orders
StaticStores order records and related transaction data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| order_id | bigint(20) unsigned | NO |
| created_date | date | NO |
| created_time | time | NO |
| status | ENUM('wc-pending' ,'wc-processing' ,'wc-on-hold' ,'wc-completed' ,'wc-cancelled' ,'wc-refunded' ,'wc-failed') | YES |
| type | ENUM('shop_order','shop_order_refund') | NO |
| parent_id | bigint(20) | NO |
| total | decimal(10,2) | NO |
| currency | varchar(5) | NO |
| discount | decimal(10,2) | NO |
| cart_discount | decimal(10,2) | NO |
| shipping | decimal(10,2) | NO |
| shipping_tax | decimal(10,2) | NO |
| shipping_method | varchar(50) | NO |
| tax | decimal(10,2) | NO |
| qty | smallint(5) unsigned | NO |
| payment_method | varchar(20) | NO |
| user_id | bigint(20) | NO |
| billing_email | varchar(255) | NO |
| customer_name | varchar(255) | NO |
| billing_country | varchar(20) | NO |
| trash | BIT(1) | NO |
| meta_values | longtext | NO |
| update_flag | BIT(1) | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_woo_sr_orders ( `order_id` bigint(20) unsigned NOT NULL, `created_date` date NOT NULL DEFAULT '0000-00-00', `created_time` time NOT NULL DEFAULT '00:00:00', `status` ENUM('wc-pending' ,'wc-processing' ,'wc-on-hold' ,'wc-completed' ,'wc-cancelled' ,'wc-refunded' ,'wc-failed'), `type` ENUM('shop_order','shop_order_refund') NOT NULL DEFAULT 'shop_order', `parent_id` bigint(20) NOT NULL DEFAULT '0', `total` decimal(10,2) NOT NULL DEFAULT '0.00', `currency` varchar(5) NOT NULL, `discount` decimal(10,2) NOT NULL DEFAULT '0.00', `cart_discount` decimal(10,2) NOT NULL DEFAULT '0.00', `shipping` decimal(10,2) NOT NULL DEFAULT '0.00', `shipping_tax` decimal(10,2) NOT NULL DEFAULT '0.00', `shipping_method` varchar(50) NOT NULL, `tax` decimal(10,2) NOT NULL DEFAULT '0.00', `qty` smallint(5) unsigned NOT NULL DEFAULT '0', `payment_method` varchar(20) NOT NULL, `user_id` bigint(20) NOT NULL DEFAULT '0', `billing_email` varchar(255) NOT NULL, `customer_name` varchar(255) NOT NULL, `billing_country` varchar(20) NOT NULL, `trash` BIT(1) NOT NULL DEFAULT 0, `meta_values` longtext NOT NULL, `update_flag` BIT(1) NOT NULL DEFAULT 0, PRIMARY KEY (`order_id`), KEY `parent_id` (`parent_id`), KEY `currency` (`currency`), KEY `date_and_status` (`created_date`,`status`) ) $collate;"; $wpdb->query($query);Safe to delete?
If you have uninstalled Smart Reporter For WooCommerce and WP eCommerce, 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_woo_sr_orders`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Smart Reporter For WooCommerce and WP eCommerce