wp_ec_location
StaticStores ec location data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑location_id | int(11) | NO |
| location_label | varchar(255) | YES |
| address_line_1 | varchar(255) | NO |
| address_line_2 | varchar(255) | NO |
| city | varchar(255) | NO |
| state | varchar(255) | NO |
| country | varchar(255) | NO |
| zip | varchar(255) | NO |
| phone | varchar(255) | NO |
| varchar(255) | NO | |
| latitude | decimal(9,6) | YES |
| longitude | decimal(9,6) | YES |
CREATE TABLE Statement
CREATE TABLE ec_location ( location_id int(11) NOT NULL AUTO_INCREMENT, location_label varchar(255) DEFAULT '', address_line_1 varchar(255) NOT NULL DEFAULT '', address_line_2 varchar(255) NOT NULL DEFAULT '', city varchar(255) NOT NULL DEFAULT '', state varchar(255) NOT NULL DEFAULT '', country varchar(255) NOT NULL DEFAULT '', zip varchar(255) NOT NULL DEFAULT '', phone varchar(255) NOT NULL DEFAULT '', email varchar(255) NOT NULL DEFAULT '', latitude decimal(9,6) DEFAULT NULL, longitude decimal(9,6) DEFAULT NULL, PRIMARY KEY (location_id), UNIQUE KEY location_id (location_id) ) $collate;" );
Safe to delete?
If you have uninstalled Shopping Cart & eCommerce Store, 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_ec_location`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Shopping Cart & eCommerce Store