wp_warehouse
StaticStores warehouse data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | mediumint(9) | NO |
| city | varchar(200) | NO |
| state | varchar(200) | NO |
| address | varchar(255) | NO |
| phone_instore | varchar(255) | NO |
| zip | varchar(200) | NO |
| country | varchar(200) | NO |
| location | varchar(200) | NO |
| nickname | varchar(200) | NO |
| enable_store_pickup | VARCHAR(255) | NO |
| miles_store_pickup | VARCHAR(255) | NO |
| match_postal_store_pickup | VARCHAR(255) | NO |
| enable_local_delivery | VARCHAR(255) | NO |
| miles_local_delivery | VARCHAR(255) | NO |
| match_postal_local_delivery | VARCHAR(255) | NO |
| fee_local_delivery | VARCHAR(255) | NO |
| suppress_local_delivery | VARCHAR(255) | NO |
| origin_markup | VARCHAR(255) | YES |
| enable_residential_pickup_parcel | tinyint(1) | NO |
| enable_residential_pickup | tinyint(1) | NO |
| enable_liftgate_pickup | tinyint(1) | NO |
CREATE TABLE Statement
CREATE TABLE wp_warehouse ( id mediumint(9) NOT NULL AUTO_INCREMENT, city varchar(200) NOT NULL, state varchar(200) NOT NULL, address varchar(255) NOT NULL, phone_instore varchar(255) NOT NULL, zip varchar(200) NOT NULL, country varchar(200) NOT NULL, location varchar(200) NOT NULL, nickname varchar(200) NOT NULL, enable_store_pickup VARCHAR(255) NOT NULL, miles_store_pickup VARCHAR(255) NOT NULL, match_postal_store_pickup VARCHAR(255) NOT NULL, checkout_desc_store_pickup VARCHAR(255) NOT NULL, enable_local_delivery VARCHAR(255) NOT NULL, miles_local_delivery VARCHAR(255) NOT NULL, match_postal_local_delivery VARCHAR(255) NOT NULL, checkout_desc_local_delivery VARCHAR(255) NOT NULL, fee_local_delivery VARCHAR(255) NOT NULL, suppress_local_delivery VARCHAR(255) NOT NULL, origin_markup VARCHAR(255), enable_residential_pickup_parcel tinyint(1) NOT NULL DEFAULT 0, enable_residential_pickup tinyint(1) NOT NULL DEFAULT 0, enable_liftgate_pickup tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (id) )");
Safe to delete?
If you have uninstalled LTL Freight Quotes – Unishippers Edition, 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_warehouse`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from LTL Freight Quotes – Unishippers Edition