wp_locations
StaticStores locations data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| doc_id | INTEGER | YES |
| longitude | REAL | YES |
| latitude | REAL | YES |
| cos_lat | REAL | YES |
| sin_lat | REAL | YES |
| cos_lng | REAL | YES |
| sin_lng | REAL | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS locations ( doc_id INTEGER, longitude REAL, latitude REAL, cos_lat REAL, sin_lat REAL, cos_lng REAL, sin_lng REAL )");
Safe to delete?
If you have uninstalled Admin Instant Search, 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_locations`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Admin Instant Search