wp_aieo_variations_stock_condition
StaticStores aieo variations stock condition data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint unsigned | NO |
| product_id | bigint | NO |
| name | varchar(255) | YES |
| brand | varchar(255) | YES |
| menu_category | varchar(255) | YES |
| sub_category | varchar(255) | YES |
| image_url | varchar(500) | YES |
| total_variations | int | NO |
| instock_variations | int | NO |
| out_of_stock_variations | int | NO |
| pct_out_of_stock | decimal(7,2) | NO |
| latest_sale_gmt | datetime | YES |
| created | datetime | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_aieo_variations_stock_condition` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `product_id` bigint NOT NULL, `name` varchar(255) DEFAULT NULL, `brand` varchar(255) DEFAULT NULL, `menu_category` varchar(255) DEFAULT NULL, `sub_category` varchar(255) DEFAULT NULL, `image_url` varchar(500) DEFAULT NULL, `total_variations` int NOT NULL DEFAULT 0, `instock_variations` int NOT NULL DEFAULT 0, `out_of_stock_variations` int NOT NULL DEFAULT 0, `pct_out_of_stock` decimal(7,2) NOT NULL DEFAULT 0.00, `latest_sale_gmt` datetime DEFAULT NULL, `created` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uq_product_id` (`product_id`), KEY `idx_pct_out_of_stock` (`pct_out_of_stock`) ) ENGINE
Safe to delete?
If you have uninstalled Rooster One, 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_aieo_variations_stock_condition`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Rooster One