wp_im_bookings
StaticStores im bookings data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| lead_id | BIGINT UNSIGNED | YES |
| patient_name | VARCHAR(120) | NO |
| patient_phone | VARCHAR(30) | NO |
| service | VARCHAR(80) | NO |
| staff | VARCHAR(80) | YES |
| booking_date | DATE | NO |
| booking_time | TIME | NO |
| duration_min | SMALLINT UNSIGNED | NO |
| status | VARCHAR(20) | NO |
| notes | TEXT | YES |
| created_at | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE wp_im_bookings ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, lead_id BIGINT UNSIGNED DEFAULT NULL, patient_name VARCHAR(120) NOT NULL DEFAULT '', patient_phone VARCHAR(30) NOT NULL DEFAULT '', service VARCHAR(80) NOT NULL DEFAULT '', staff VARCHAR(80) DEFAULT '', booking_date DATE NOT NULL, booking_time TIME NOT NULL, duration_min SMALLINT UNSIGNED NOT NULL DEFAULT 30, status VARCHAR(20) NOT NULL DEFAULT 'Pending', notes TEXT DEFAULT '', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY booking_date (booking_date), KEY status (status) ) $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_bookings`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from IntoMetrics Booking & CRM Light