{"table_name":"hustlai_as_appointment_types","full_table_name":"wp_hustlai_as_appointment_types","description":"Stores hustlai as appointment types data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"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 );","columns":[{"name":"id","type":"mediumint(9)","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"slug","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"duration","type":"int","nullable":false,"primary_key":false},{"name":"buffer_before","type":"int","nullable":false,"primary_key":false},{"name":"buffer_after","type":"int","nullable":false,"primary_key":false},{"name":"min_notice","type":"int","nullable":false,"primary_key":false},{"name":"max_window_days","type":"int","nullable":false,"primary_key":false},{"name":"admin_email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"requires_confirmation","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"color","type":"varchar(7)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"sync_enabled","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"sync_provider","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"sync_calendar_id","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"type_id","type":"mediumint(9)","nullable":false,"primary_key":false},{"name":"day_of_week","type":"tinyint(2)","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":"type_id","type":"mediumint(9)","nullable":true,"primary_key":false},{"name":"blocked_date","type":"date","nullable":false,"primary_key":false},{"name":"reason","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"type_id","type":"mediumint(9)","nullable":false,"primary_key":false},{"name":"field_key","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"field_label","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"field_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"field_options","type":"text","nullable":true,"primary_key":false},{"name":"is_required","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"sort_order","type":"int","nullable":false,"primary_key":false},{"name":"type_id","type":"mediumint(9)","nullable":false,"primary_key":false},{"name":"booking_date","type":"date","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":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"booking_version","type":"int","nullable":false,"primary_key":false},{"name":"cancel_token","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"customer_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"customer_email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"form_data","type":"longtext","nullable":true,"primary_key":false},{"name":"join_url","type":"text","nullable":true,"primary_key":false},{"name":"join_url_expires_at","type":"datetime","nullable":true,"primary_key":false},{"name":"customer_timezone","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"admin_notified","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"reminder_24h_sent","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"reminder_1h_sent","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"external_provider","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"external_event_id","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"external_calendar_id","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"setting_key","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"setting_value","type":"longtext","nullable":true,"primary_key":false},{"name":"booking_id","type":"mediumint(9)","nullable":false,"primary_key":false},{"name":"action","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"provider","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"calendar_id","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"attempts","type":"int","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"last_error","type":"text","nullable":true,"primary_key":false},{"name":"run_after","type":"datetime","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"booking_id","type":"mediumint(9)","nullable":false,"primary_key":false},{"name":"type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"channel","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"sent_for_version","type":"int","nullable":false,"primary_key":false},{"name":"idempotency_key","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"provider_message_id","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"payload_hash","type":"char(64)","nullable":false,"primary_key":false},{"name":"error_message","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"sent_at","type":"datetime","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"ip_hash","type":"char(64)","nullable":false,"primary_key":false},{"name":"email_hash","type":"char(64)","nullable":false,"primary_key":false},{"name":"event_type","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"result","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"reason","type":"varchar(50)","nullable":false,"primary_key":false}],"plugin":{"slug":"hustlai-appointment-scheduler","name":"HustlAI Appointment Scheduler","active_installs":0,"version":"1.3.10","wp_org_url":"https://wordpress.org/plugins/hustlai-appointment-scheduler/"}}