{"slug":"wm-form4events","name":"WM Form4Events","description":"Create simple event registration forms, manage appointments and attendees, and automate confirmations directly in WordPress.","author":"Witte Marketing","active_installs":0,"version":"1.0.1","wp_org_url":"https://wordpress.org/plugins/wm-form4events/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"wmf4e_appointments","full_table_name":"wp_wmf4e_appointments","description":"Stores wmf4e appointments data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wmf4e_forms","full_table_name":"wp_wmf4e_forms","description":"Stores form definitions and related configuration.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wmf4e_registrations","full_table_name":"wp_wmf4e_registrations","description":"Stores wmf4e registrations data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"first_name","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"last_name","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"form_id","type":"int","nullable":false,"primary_key":false},{"name":"appointment_id","type":"int","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"token","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"created_at","type":"timestamp","nullable":true,"primary_key":false},{"name":"confirmed_at","type":"timestamp","nullable":true,"primary_key":false},{"name":"cancelled_at","type":"timestamp","nullable":true,"primary_key":false},{"name":"reminder_sent","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"company","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"message","type":"text","nullable":true,"primary_key":false},{"name":"utm_src","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"fields","type":"text","nullable":true,"primary_key":false},{"name":"active","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"closed_text","type":"text","nullable":true,"primary_key":false},{"name":"reminder_hours","type":"int","nullable":true,"primary_key":false},{"name":"redirect_registration","type":"text","nullable":true,"primary_key":false},{"name":"redirect_registration_mode","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"redirect_registration_page_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"redirect_registration_new_window","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"privacy_page_data","type":"text","nullable":true,"primary_key":false},{"name":"redirect_cancellation","type":"text","nullable":true,"primary_key":false},{"name":"redirect_cancellation_mode","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"redirect_cancellation_page_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"redirect_cancellation_new_window","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"redirect_confirmation","type":"text","nullable":true,"primary_key":false},{"name":"redirect_confirmation_mode","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"redirect_confirmation_page_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"redirect_confirmation_new_window","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"waitlist_modal_heading","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"waitlist_modal_message","type":"text","nullable":true,"primary_key":false},{"name":"waitlist_modal_privacy","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"form_id","type":"int","nullable":false,"primary_key":false},{"name":"appointment_date","type":"date","nullable":false,"primary_key":false},{"name":"max_seats","type":"int","nullable":false,"primary_key":false},{"name":"start_time","type":"time","nullable":false,"primary_key":false},{"name":"end_time","type":"time","nullable":false,"primary_key":false},{"name":"active","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"sort_order","type":"int","nullable":true,"primary_key":false}],"create_sql":"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);"}],"table_count":3}