wp_im_leads
StaticStores im leads data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| name | VARCHAR(120) | NO |
| phone | VARCHAR(30) | NO |
| VARCHAR(120) | YES | |
| service | VARCHAR(80) | NO |
| staff | VARCHAR(80) | YES |
| urgency | VARCHAR(20) | NO |
| status | VARCHAR(20) | NO |
| source | VARCHAR(40) | NO |
| score | TINYINT UNSIGNED | NO |
| tier | VARCHAR(10) | NO |
| appointment_date | DATE | YES |
| appointment_time | VARCHAR(10) | YES |
| addons | TEXT | YES |
| total_amount | DECIMAL(10,2) | YES |
| payment_status | VARCHAR(20) | NO |
| payment_gateway | VARCHAR(30) | YES |
| payment_ref | VARCHAR(120) | YES |
| form_id | VARCHAR(60) | YES |
| form_name | VARCHAR(120) | YES |
| form_seq | INT UNSIGNED | NO |
| notes | TEXT | YES |
| assigned_to | BIGINT UNSIGNED | YES |
| created_at | DATETIME | NO |
| updated_at | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE wp_im_leads ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(120) NOT NULL DEFAULT '', phone VARCHAR(30) NOT NULL DEFAULT '', email VARCHAR(120) DEFAULT '', service VARCHAR(80) NOT NULL DEFAULT '', staff VARCHAR(80) DEFAULT '', urgency VARCHAR(20) NOT NULL DEFAULT 'Flexible', status VARCHAR(20) NOT NULL DEFAULT 'New', source VARCHAR(40) NOT NULL DEFAULT 'Website', score TINYINT UNSIGNED NOT NULL DEFAULT 0, tier VARCHAR(10) NOT NULL DEFAULT 'cold', appointment_date DATE DEFAULT NULL, appointment_time VARCHAR(10) DEFAULT NULL, addons TEXT DEFAULT '', total_amount DECIMAL(10,2) DEFAULT 0.00, payment_status VARCHAR(20) NOT NULL DEFAULT 'unpaid', payment_gateway VARCHAR(30) DEFAULT '', payment_ref VARCHAR(120) DEFAULT '', form_id VARCHAR(60) DEFAULT '', form_name VARCHAR(120) DEFAULT '', form_seq INT UNSIGNED NOT NULL DEFAULT 0, notes TEXT DEFAULT '', assigned_to BIGINT UNSIGNED DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY status (status), KEY tier (tier), KEY appointment_date (appointment_date), KEY created_at (created_at) ) $charset;" );
Safe to delete?
If you have uninstalled IntoMetrics Booking & CRM Light, 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_im_leads`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from IntoMetrics Booking & CRM Light