{"slug":"discounts-mania-consultations","name":"Discounts Mania Consultations","description":"Let clients book consultations from a live calendar of your free times, with an intake form, email confirmations, reminders and self-service changes.","author":"discountsmania","active_installs":0,"version":"1.4.0","wp_org_url":"https://wordpress.org/plugins/discounts-mania-consultations/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"dmcb_bookings","full_table_name":"wp_dmcb_bookings","description":"Stores dmcb bookings data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"ref","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(24)","nullable":false,"primary_key":false},{"name":"start_utc","type":"DATETIME","nullable":false,"primary_key":false},{"name":"end_utc","type":"DATETIME","nullable":false,"primary_key":false},{"name":"minutes","type":"SMALLINT UNSIGNED","nullable":false,"primary_key":false},{"name":"amount","type":"DECIMAL(12,2)","nullable":false,"primary_key":false},{"name":"currency","type":"VARCHAR(3)","nullable":false,"primary_key":false},{"name":"service","type":"VARCHAR(120)","nullable":false,"primary_key":false},{"name":"prefix","type":"VARCHAR(12)","nullable":false,"primary_key":false},{"name":"first_name","type":"VARCHAR(80)","nullable":false,"primary_key":false},{"name":"middle_name","type":"VARCHAR(80)","nullable":false,"primary_key":false},{"name":"last_name","type":"VARCHAR(80)","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(190)","nullable":false,"primary_key":false},{"name":"phone","type":"VARCHAR(40)","nullable":false,"primary_key":false},{"name":"business","type":"VARCHAR(160)","nullable":false,"primary_key":false},{"name":"notes","type":"TEXT","nullable":true,"primary_key":false},{"name":"client_tz","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"hold_expires_utc","type":"DATETIME","nullable":true,"primary_key":false},{"name":"paid_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"meeting_provider","type":"VARCHAR(12)","nullable":false,"primary_key":false},{"name":"meeting_id","type":"VARCHAR(190)","nullable":false,"primary_key":false},{"name":"meeting_url","type":"VARCHAR(500)","nullable":false,"primary_key":false},{"name":"meeting_password","type":"VARCHAR(40)","nullable":false,"primary_key":false},{"name":"meeting_error","type":"TEXT","nullable":true,"primary_key":false},{"name":"policy","type":"TEXT","nullable":true,"primary_key":false},{"name":"policy_accepted_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"reschedule_count","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"original_start_utc","type":"DATETIME","nullable":true,"primary_key":false},{"name":"rescheduled_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"cancelled_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"cancelled_by","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"refund_amount","type":"DECIMAL(12,2)","nullable":false,"primary_key":false},{"name":"refund_status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"reminder_day_sent","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"reminder_hour_sent","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"view_token","type":"VARCHAR(40)","nullable":false,"primary_key":false},{"name":"ip","type":"VARCHAR(45)","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}],"create_sql":"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};\" );"},{"table_name":"dmcb_logs","full_table_name":"wp_dmcb_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"event","type":"VARCHAR(60)","nullable":false,"primary_key":false},{"name":"booking_ref","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"details","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_dmcb_logs ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, event VARCHAR(60) NOT NULL, booking_ref VARCHAR(20) NULL, details LONGTEXT NULL, created_at DATETIME NOT NULL, PRIMARY KEY (id), KEY booking_ref (booking_ref), KEY created_at (created_at) ) {$c};\" );"}],"table_count":2}