wp_ffl_dealers
StaticStores ffl dealers data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(11) | NO |
| license_number | varchar(30) | NO |
| short_lic | varchar(12) | NO |
| license_name | varchar(100) | NO |
| business_name | varchar(100) | NO |
| premise_street | varchar(50) | NO |
| premise_city | varchar(30) | NO |
| premise_state | varchar(20) | NO |
| premise_zip_code | varchar(10) | NO |
| lat | varchar(20) | NO |
| lng | varchar(20) | NO |
| voice_phone | varchar(15) | NO |
| check_status | TINYINT(1) | NO |
| default_dealer | TINYINT(1) | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_ffl_dealers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `license_number` varchar(30) NOT NULL, `short_lic` varchar(12) NOT NULL, `license_name` varchar(100) NOT NULL, `business_name` varchar(100) NOT NULL, `premise_street` varchar(50) NOT NULL, `premise_city` varchar(30) NOT NULL, `premise_state` varchar(20) NOT NULL, `premise_zip_code` varchar(10) NOT NULL, `lat` varchar(20) NOT NULL, `lng` varchar(20) NOT NULL, `voice_phone` varchar(15) NOT NULL, `check_status` TINYINT(1) NOT NULL DEFAULT '0', `default_dealer` TINYINT(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) )$charset_collate;"; if (!function_exists('dbDelta')) { require_once ABSPATH . 'wp-admin/includes/upgrade.php'; } dbDelta($firegun_delear);Safe to delete?
If you have uninstalled FFL Dealers, 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_ffl_dealers`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.