wp_wmf4e_registrations
StaticStores wmf4e registrations data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int | NO |
| first_name | varchar(50) | NO |
| last_name | varchar(50) | NO |
| varchar(100) | NO | |
| form_id | int | NO |
| appointment_id | int | NO |
| status | varchar(20) | NO |
| token | varchar(100) | NO |
| created_at | timestamp | YES |
| confirmed_at | timestamp | YES |
| cancelled_at | timestamp | YES |
| reminder_sent | tinyint(1) | NO |
| company | varchar(255) | YES |
| phone | varchar(50) | YES |
| message | text | YES |
| utm_src | varchar(100) | YES |
| name | varchar(255) | NO |
| fields | text | YES |
| active | tinyint(1) | NO |
| closed_text | text | YES |
| reminder_hours | int | YES |
| redirect_registration | text | YES |
| redirect_registration_mode | varchar(20) | NO |
| redirect_registration_page_id | bigint(20) unsigned | NO |
| redirect_registration_new_window | tinyint(1) | NO |
| privacy_page_data | text | YES |
| redirect_cancellation | text | YES |
| redirect_cancellation_mode | varchar(20) | NO |
| redirect_cancellation_page_id | bigint(20) unsigned | NO |
| redirect_cancellation_new_window | tinyint(1) | NO |
| redirect_confirmation | text | YES |
| redirect_confirmation_mode | varchar(20) | NO |
| redirect_confirmation_page_id | bigint(20) unsigned | NO |
| redirect_confirmation_new_window | tinyint(1) | NO |
| waitlist_modal_heading | varchar(255) | YES |
| waitlist_modal_message | text | YES |
| waitlist_modal_privacy | text | YES |
| created_at | datetime | NO |
| form_id | int | NO |
| appointment_date | date | NO |
| max_seats | int | NO |
| start_time | time | NO |
| end_time | time | NO |
| active | tinyint(1) | NO |
| sort_order | int | YES |
CREATE TABLE Statement
CREATE TABLE wp_wmf4e_registrations ( id int NOT NULL AUTO_INCREMENT, first_name varchar(50) NOT NULL, last_name varchar(50) NOT NULL, email varchar(100) NOT NULL, form_id int NOT NULL, appointment_id int NOT NULL, status varchar(20) NOT NULL, token varchar(100) NOT NULL, created_at timestamp NULL DEFAULT CURRENT_TIMESTAMP, confirmed_at timestamp NULL DEFAULT NULL, cancelled_at timestamp NULL DEFAULT NULL, reminder_sent tinyint(1) NOT NULL DEFAULT 0, company varchar(255) DEFAULT NULL, phone varchar(50) DEFAULT NULL, message text DEFAULT NULL, utm_src varchar(100) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;"; // Table 2: forms $table_forms = wp_'wmf4e_forms'; $sql2 = "CREATE TABLE wp_wmf4e_forms ( id int NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, fields text DEFAULT NULL, active tinyint(1) NOT NULL DEFAULT 1, closed_text text DEFAULT NULL, reminder_hours int DEFAULT 24, redirect_registration text DEFAULT NULL, redirect_registration_mode varchar(20) NOT NULL DEFAULT 'default', redirect_registration_page_id bigint(20) unsigned NOT NULL DEFAULT 0, redirect_registration_new_window tinyint(1) NOT NULL DEFAULT 0, privacy_page_data text DEFAULT NULL, redirect_cancellation text DEFAULT NULL, redirect_cancellation_mode varchar(20) NOT NULL DEFAULT 'default', redirect_cancellation_page_id bigint(20) unsigned NOT NULL DEFAULT 0, redirect_cancellation_new_window tinyint(1) NOT NULL DEFAULT 0, redirect_confirmation text DEFAULT NULL, redirect_confirmation_mode varchar(20) NOT NULL DEFAULT 'default', redirect_confirmation_page_id bigint(20) unsigned NOT NULL DEFAULT 0, redirect_confirmation_new_window tinyint(1) NOT NULL DEFAULT 0, waitlist_modal_heading varchar(255) DEFAULT NULL, waitlist_modal_message text DEFAULT NULL, waitlist_modal_privacy text DEFAULT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset_collate;"; // Table 3: appointments $table_appointments = wp_'wmf4e_appointments'; $sql3 = "CREATE TABLE wp_wmf4e_appointments ( id int NOT NULL AUTO_INCREMENT, form_id int NOT NULL, appointment_date date NOT NULL, max_seats int NOT NULL DEFAULT 10, start_time time NOT NULL DEFAULT '00:00:00', end_time time NOT NULL DEFAULT '00:00:00', active tinyint(1) NOT NULL DEFAULT 1, sort_order int DEFAULT 0, PRIMARY KEY (id) ) $charset_collate;"; dbDelta($sql1);
Safe to delete?
If you have uninstalled WM Form4Events, 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_wmf4e_registrations`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WM Form4Events