wp_lsp_localprojects
StaticStores lsp localprojects data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| lsp_lp_postid | INT | NO |
| lsp_lp_tags | VARCHAR(255) | YES |
| lsp_lp_latitude | FLOAT | YES |
| lsp_lp_longitude | FLOAT | YES |
| lsp_lp_status | VARCHAR(90) | YES |
CREATE TABLE Statement
CREATE TABLE wp_lsp_localprojects ( lsp_lp_postid INT NOT NULL COMMENT '', lsp_lp_tags VARCHAR(255) COMMENT '', lsp_lp_latitude FLOAT COMMENT '', lsp_lp_longitude FLOAT COMMENT '', lsp_lp_status VARCHAR(90) COMMENT '', PRIMARY KEY (lsp_lp_postid), KEY index3 (lsp_lp_latitude), KEY index4 (lsp_lp_longitude), KEY index5 (lsp_lp_status) ) $charset_collate;"; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
Safe to delete?
If you have uninstalled Best Local SEO Tools, WordPress SEO Plugin, 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_lsp_localprojects`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Best Local SEO Tools, WordPress SEO Plugin