{"slug":"best-local-seo-tools","name":"Best Local SEO Tools, WordPress SEO Plugin","description":"Want to rank well for every city you serve and double your local search traffic? BestLocalSEOTools.com has examples & the stronger free version.","author":"Best Local SEO Tools","active_installs":30,"version":"1.0","wp_org_url":"https://wordpress.org/plugins/best-local-seo-tools/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"lsp_images","full_table_name":"wp_lsp_images","description":"Stores lsp images data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"img_url","type":"varchar(3000)","nullable":false,"primary_key":false},{"name":"img_tags","type":"varchar(3000)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_lsp_images ( img_url varchar(3000) NOT NULL, img_tags varchar(3000) DEFAULT '' NOT NULL ) $charset_collate;\"; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );"},{"table_name":"lsp_linkpoints","full_table_name":"wp_lsp_linkpoints","description":"Stores lsp linkpoints data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"url","type":"varchar(3000)","nullable":false,"primary_key":false},{"name":"linkwordpoints","type":"TEXT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_lsp_linkpoints ( url varchar(3000) NOT NULL, linkwordpoints TEXT DEFAULT '' NOT NULL ) $charset_collate;\"; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );"},{"table_name":"lsp_localprojects","full_table_name":"wp_lsp_localprojects","description":"Stores lsp localprojects data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"lsp_lp_postid","type":"INT","nullable":false,"primary_key":false},{"name":"lsp_lp_tags","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"lsp_lp_latitude","type":"FLOAT","nullable":true,"primary_key":false},{"name":"lsp_lp_longitude","type":"FLOAT","nullable":true,"primary_key":false},{"name":"lsp_lp_status","type":"VARCHAR(90)","nullable":true,"primary_key":false}],"create_sql":"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' );"},{"table_name":"lsp_redirects","full_table_name":"wp_lsp_redirects","description":"Stores lsp redirects data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"old_url","type":"varchar(3000)","nullable":false,"primary_key":false},{"name":"new_url","type":"varchar(3000)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_lsp_redirects ( old_url varchar(3000) NOT NULL, new_url varchar(3000) DEFAULT '' NOT NULL ) $charset_collate;\"; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );"}],"table_count":4}