wp_hustlai_as_appointment_types

Column Definitions

CREATE TABLE Statement

CREATE TABLE wp_hustlai_as_appointment_types ( id mediumint(9) NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, slug varchar(255) NOT NULL, description text, duration int NOT NULL DEFAULT 60, buffer_before int NOT NULL DEFAULT 0, buffer_after int NOT NULL DEFAULT 0, min_notice int NOT NULL DEFAULT 60, max_window_days int NOT NULL DEFAULT 30, admin_email varchar(255) NOT NULL DEFAULT '', requires_confirmation tinyint(1) NOT NULL DEFAULT 0, color varchar(7) NOT NULL DEFAULT '#3788d8', status varchar(20) NOT NULL DEFAULT 'active', sync_enabled tinyint(1) NOT NULL DEFAULT 0, sync_provider varchar(20) NOT NULL DEFAULT '', sync_calendar_id varchar(191) NOT NULL DEFAULT '', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY slug (slug) ) $charset; CREATE TABLE wp_hustlai_as_availability ( id mediumint(9) NOT NULL AUTO_INCREMENT, type_id mediumint(9) NOT NULL, day_of_week tinyint(2) NOT NULL, start_time time NOT NULL, end_time time NOT NULL, PRIMARY KEY (id), KEY type_id (type_id) ) $charset; CREATE TABLE wp_hustlai_as_blocked_dates ( id mediumint(9) NOT NULL AUTO_INCREMENT, type_id mediumint(9) DEFAULT NULL, blocked_date date NOT NULL, reason varchar(255) DEFAULT '', PRIMARY KEY (id), KEY blocked_date (blocked_date) ) $charset; CREATE TABLE wp_hustlai_as_form_fields ( id mediumint(9) NOT NULL AUTO_INCREMENT, type_id mediumint(9) NOT NULL, field_key varchar(100) NOT NULL, field_label varchar(255) NOT NULL, field_type varchar(50) NOT NULL DEFAULT 'text', field_options text DEFAULT NULL, is_required tinyint(1) NOT NULL DEFAULT 0, sort_order int NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY type_id (type_id) ) $charset; CREATE TABLE wp_hustlai_as_bookings ( id mediumint(9) NOT NULL AUTO_INCREMENT, type_id mediumint(9) NOT NULL, booking_date date NOT NULL, start_time time NOT NULL, end_time time NOT NULL, status varchar(20) NOT NULL DEFAULT 'confirmed', booking_version int NOT NULL DEFAULT 1, cancel_token varchar(64) NOT NULL DEFAULT '', customer_name varchar(255) NOT NULL DEFAULT '', customer_email varchar(255) NOT NULL DEFAULT '', form_data longtext DEFAULT NULL, join_url text DEFAULT NULL, join_url_expires_at datetime DEFAULT NULL, customer_timezone varchar(100) NOT NULL DEFAULT '', admin_notified tinyint(1) NOT NULL DEFAULT 0, reminder_24h_sent tinyint(1) NOT NULL DEFAULT 0, reminder_1h_sent tinyint(1) NOT NULL DEFAULT 0, external_provider varchar(20) NOT NULL DEFAULT '', external_event_id varchar(191) NOT NULL DEFAULT '', external_calendar_id varchar(191) NOT NULL DEFAULT '', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY type_id (type_id), KEY booking_date (booking_date), KEY cancel_token (cancel_token), KEY status (status) ) $charset; CREATE TABLE wp_hustlai_as_settings ( id mediumint(9) NOT NULL AUTO_INCREMENT, setting_key varchar(100) NOT NULL, setting_value longtext DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY setting_key (setting_key) ) $charset; CREATE TABLE wp_hustlai_as_sync_queue ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, booking_id mediumint(9) NOT NULL, action varchar(20) NOT NULL, provider varchar(20) NOT NULL DEFAULT '', calendar_id varchar(191) NOT NULL DEFAULT '', attempts int NOT NULL DEFAULT 0, status varchar(20) NOT NULL DEFAULT 'pending', last_error text DEFAULT NULL, run_after datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY booking_id (booking_id), KEY status (status), KEY run_after (run_after) ) $charset; CREATE TABLE wp_hustlai_as_notification_log ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, booking_id mediumint(9) NOT NULL, type varchar(50) NOT NULL DEFAULT 'join_info', channel varchar(20) NOT NULL DEFAULT 'email', status varchar(20) NOT NULL DEFAULT 'queued', sent_for_version int NOT NULL DEFAULT 1, idempotency_key varchar(191) NOT NULL DEFAULT '', provider_message_id varchar(191) NOT NULL DEFAULT '', payload_hash char(64) NOT NULL DEFAULT '', error_message text DEFAULT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, sent_at datetime DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY idempotency_key (idempotency_key), KEY booking_id (booking_id), KEY status (status), KEY type (type) ) $charset; CREATE TABLE wp_hustlai_as_antispam_attempts ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, ip_hash char(64) NOT NULL DEFAULT '', email_hash char(64) NOT NULL DEFAULT '', event_type varchar(32) NOT NULL DEFAULT 'booking_attempt', result varchar(20) NOT NULL DEFAULT 'passed', reason varchar(50) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY created_at (created_at), KEY ip_hash (ip_hash), KEY email_hash (email_hash) ) $charset;"; dbDelta( $sql );

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_hustlai_as_appointment_types`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from HustlAI Appointment Scheduler