wp_coderun_oneclickwoo_orders
StaticStores order records and related transaction data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(10) | NO |
| plugin_version | varchar(50) | NO |
| active | tinyint(1) | YES |
| status | tinyint(1) | YES |
| product_id | int(11) | YES |
| product_name | varchar(300) | YES |
| product_meta | mediumtext | YES |
| product_price | double(10,2) | YES |
| product_quantity | int(11) | YES |
| form | longtext | YES |
| sms_log | varchar(400) | YES |
| woo_order_id | bigint(20) | YES |
| user_id | bigint(20) | YES |
| date_update | datetime | YES |
| date_create | datetime | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_coderun_oneclickwoo_orders` ( `id` bigint(10) NOT NULL AUTO_INCREMENT, `plugin_version` varchar(50) NOT NULL DEFAULT '0', `active` tinyint(1) DEFAULT '1', `status` tinyint(1) DEFAULT '2', `product_id` int(11) DEFAULT '0', `product_name` varchar(300) DEFAULT NULL, `product_meta` mediumtext, `product_price` double(10,2) DEFAULT '0.00', `product_quantity` int(11) DEFAULT NULL, `form` longtext, `sms_log` varchar(400) DEFAULT '', `woo_order_id` bigint(20) DEFAULT '0', `user_id` bigint(20) DEFAULT '0', `date_update` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `date_create` datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, KEY `wp_coderun_oneclickwoo_orders_product_id_IDX` (`product_id`) USING BTREE, KEY `wp_coderun_oneclickwoo_orders_woo_order_id_IDX` (`woo_order_id`) USING BTREE ) ENGINE
Safe to delete?
If you have uninstalled Buy one click for WooCommerce, 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_coderun_oneclickwoo_orders`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.