wp_woo_sr_order_items
StaticStores order records and related transaction data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| order_item_id | bigint(20) | NO |
| order_date | date | NO |
| order_time | time | NO |
| order_is_sale | tinyint(1) | NO |
| product_id | bigint(20) | NO |
| variation_id | bigint(20) | NO |
| order_id | bigint(20) | NO |
| type | enum('S','D','R') | NO |
| qty | smallint(6) | NO |
| total | decimal(10,2) | 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_order_items ( `order_item_id` bigint(20) NOT NULL, `order_date` date NOT NULL DEFAULT '0000-00-00', `order_time` time NOT NULL DEFAULT '00:00:00', `order_is_sale` tinyint(1) NOT NULL DEFAULT '1', `product_id` bigint(20) NOT NULL DEFAULT '0', `variation_id` bigint(20) NOT NULL DEFAULT '0', `order_id` bigint(20) NOT NULL, `type` enum('S','D','R') NOT NULL, `qty` smallint(6) NOT NULL, `total` decimal(10,2) 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_item_id`), KEY `composite` (`order_date`,`order_is_sale`,`type`,`product_id`) ) $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_order_items`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Smart Reporter For WooCommerce and WP eCommerce