wp_dmcb_bookings
StaticStores dmcb bookings data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| ref | VARCHAR(20) | NO |
| status | VARCHAR(24) | NO |
| start_utc | DATETIME | NO |
| end_utc | DATETIME | NO |
| minutes | SMALLINT UNSIGNED | NO |
| amount | DECIMAL(12,2) | NO |
| currency | VARCHAR(3) | NO |
| service | VARCHAR(120) | NO |
| prefix | VARCHAR(12) | NO |
| first_name | VARCHAR(80) | NO |
| middle_name | VARCHAR(80) | NO |
| last_name | VARCHAR(80) | NO |
| VARCHAR(190) | NO | |
| phone | VARCHAR(40) | NO |
| business | VARCHAR(160) | NO |
| notes | TEXT | YES |
| client_tz | VARCHAR(64) | NO |
| hold_expires_utc | DATETIME | YES |
| paid_at | DATETIME | YES |
| meeting_provider | VARCHAR(12) | NO |
| meeting_id | VARCHAR(190) | NO |
| meeting_url | VARCHAR(500) | NO |
| meeting_password | VARCHAR(40) | NO |
| meeting_error | TEXT | YES |
| policy | TEXT | YES |
| policy_accepted_at | DATETIME | YES |
| reschedule_count | TINYINT UNSIGNED | NO |
| original_start_utc | DATETIME | YES |
| rescheduled_at | DATETIME | YES |
| cancelled_at | DATETIME | YES |
| cancelled_by | VARCHAR(10) | NO |
| refund_amount | DECIMAL(12,2) | NO |
| refund_status | VARCHAR(20) | NO |
| reminder_day_sent | TINYINT(1) | NO |
| reminder_hour_sent | TINYINT(1) | NO |
| view_token | VARCHAR(40) | NO |
| ip | VARCHAR(45) | NO |
| created_at | DATETIME | NO |
| updated_at | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE wp_dmcb_bookings ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, ref VARCHAR(20) NOT NULL, status VARCHAR(24) NOT NULL DEFAULT 'confirmed', start_utc DATETIME NOT NULL, end_utc DATETIME NOT NULL, minutes SMALLINT UNSIGNED NOT NULL, amount DECIMAL(12,2) NOT NULL DEFAULT 0, currency VARCHAR(3) NOT NULL DEFAULT '', service VARCHAR(120) NOT NULL DEFAULT '', prefix VARCHAR(12) NOT NULL DEFAULT '', first_name VARCHAR(80) NOT NULL, middle_name VARCHAR(80) NOT NULL DEFAULT '', last_name VARCHAR(80) NOT NULL, email VARCHAR(190) NOT NULL, phone VARCHAR(40) NOT NULL, business VARCHAR(160) NOT NULL DEFAULT '', notes TEXT NULL, client_tz VARCHAR(64) NOT NULL DEFAULT '', hold_expires_utc DATETIME NULL, paid_at DATETIME NULL, meeting_provider VARCHAR(12) NOT NULL DEFAULT '', meeting_id VARCHAR(190) NOT NULL DEFAULT '', meeting_url VARCHAR(500) NOT NULL DEFAULT '', meeting_password VARCHAR(40) NOT NULL DEFAULT '', meeting_error TEXT NULL, policy TEXT NULL, policy_accepted_at DATETIME NULL, reschedule_count TINYINT UNSIGNED NOT NULL DEFAULT 0, original_start_utc DATETIME NULL, rescheduled_at DATETIME NULL, cancelled_at DATETIME NULL, cancelled_by VARCHAR(10) NOT NULL DEFAULT '', refund_amount DECIMAL(12,2) NOT NULL DEFAULT 0, refund_status VARCHAR(20) NOT NULL DEFAULT '', reminder_day_sent TINYINT(1) NOT NULL DEFAULT 0, reminder_hour_sent TINYINT(1) NOT NULL DEFAULT 0, view_token VARCHAR(40) NOT NULL, ip VARCHAR(45) NOT NULL DEFAULT '', created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY (id), UNIQUE KEY ref (ref), KEY status_start (status,start_utc), KEY email (email) ) {$c};" );Safe to delete?
If you have uninstalled Discounts Mania Consultations, 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_dmcb_bookings`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Discounts Mania Consultations