{"slug":"intometrics-booking-crm-light","name":"IntoMetrics Booking & CRM Light","description":"Complete booking forms, CRM, calendar, analytics, and automation workflows for WordPress service businesses.","author":"IntoMetrics","active_installs":0,"version":"1.0.52","wp_org_url":"https://wordpress.org/plugins/intometrics-booking-crm-light/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"im_bookings","full_table_name":"wp_im_bookings","description":"Stores im bookings data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"lead_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"patient_name","type":"VARCHAR(120)","nullable":false,"primary_key":false},{"name":"patient_phone","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"service","type":"VARCHAR(80)","nullable":false,"primary_key":false},{"name":"staff","type":"VARCHAR(80)","nullable":true,"primary_key":false},{"name":"booking_date","type":"DATE","nullable":false,"primary_key":false},{"name":"booking_time","type":"TIME","nullable":false,"primary_key":false},{"name":"duration_min","type":"SMALLINT UNSIGNED","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"notes","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_im_bookings ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, lead_id BIGINT UNSIGNED DEFAULT NULL, patient_name VARCHAR(120) NOT NULL DEFAULT '', patient_phone VARCHAR(30) NOT NULL DEFAULT '', service VARCHAR(80) NOT NULL DEFAULT '', staff VARCHAR(80) DEFAULT '', booking_date DATE NOT NULL, booking_time TIME NOT NULL, duration_min SMALLINT UNSIGNED NOT NULL DEFAULT 30, status VARCHAR(20) NOT NULL DEFAULT 'Pending', notes TEXT DEFAULT '', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY booking_date (booking_date), KEY status (status) ) $charset;\" );"},{"table_name":"im_leads","full_table_name":"wp_im_leads","description":"Stores im leads data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"name","type":"VARCHAR(120)","nullable":false,"primary_key":false},{"name":"phone","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(120)","nullable":true,"primary_key":false},{"name":"service","type":"VARCHAR(80)","nullable":false,"primary_key":false},{"name":"staff","type":"VARCHAR(80)","nullable":true,"primary_key":false},{"name":"urgency","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"source","type":"VARCHAR(40)","nullable":false,"primary_key":false},{"name":"score","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"tier","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"appointment_date","type":"DATE","nullable":true,"primary_key":false},{"name":"appointment_time","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"addons","type":"TEXT","nullable":true,"primary_key":false},{"name":"total_amount","type":"DECIMAL(10,2)","nullable":true,"primary_key":false},{"name":"payment_status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"payment_gateway","type":"VARCHAR(30)","nullable":true,"primary_key":false},{"name":"payment_ref","type":"VARCHAR(120)","nullable":true,"primary_key":false},{"name":"form_id","type":"VARCHAR(60)","nullable":true,"primary_key":false},{"name":"form_name","type":"VARCHAR(120)","nullable":true,"primary_key":false},{"name":"form_seq","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"notes","type":"TEXT","nullable":true,"primary_key":false},{"name":"assigned_to","type":"BIGINT UNSIGNED","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}],"create_sql":"CREATE TABLE wp_im_leads ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(120) NOT NULL DEFAULT '', phone VARCHAR(30) NOT NULL DEFAULT '', email VARCHAR(120) DEFAULT '', service VARCHAR(80) NOT NULL DEFAULT '', staff VARCHAR(80) DEFAULT '', urgency VARCHAR(20) NOT NULL DEFAULT 'Flexible', status VARCHAR(20) NOT NULL DEFAULT 'New', source VARCHAR(40) NOT NULL DEFAULT 'Website', score TINYINT UNSIGNED NOT NULL DEFAULT 0, tier VARCHAR(10) NOT NULL DEFAULT 'cold', appointment_date DATE DEFAULT NULL, appointment_time VARCHAR(10) DEFAULT NULL, addons TEXT DEFAULT '', total_amount DECIMAL(10,2) DEFAULT 0.00, payment_status VARCHAR(20) NOT NULL DEFAULT 'unpaid', payment_gateway VARCHAR(30) DEFAULT '', payment_ref VARCHAR(120) DEFAULT '', form_id VARCHAR(60) DEFAULT '', form_name VARCHAR(120) DEFAULT '', form_seq INT UNSIGNED NOT NULL DEFAULT 0, notes TEXT DEFAULT '', assigned_to BIGINT UNSIGNED DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY status (status), KEY tier (tier), KEY appointment_date (appointment_date), KEY created_at (created_at) ) $charset;\" );"},{"table_name":"im_staff","full_table_name":"wp_im_staff","description":"Stores im staff data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"wp_user_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"name","type":"VARCHAR(120)","nullable":false,"primary_key":false},{"name":"role","type":"VARCHAR(40)","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(120)","nullable":false,"primary_key":false},{"name":"phone","type":"VARCHAR(30)","nullable":true,"primary_key":false},{"name":"active","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_im_staff ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, wp_user_id BIGINT UNSIGNED DEFAULT 0, name VARCHAR(120) NOT NULL, role VARCHAR(40) NOT NULL DEFAULT 'staff', email VARCHAR(120) NOT NULL DEFAULT '', phone VARCHAR(30) DEFAULT '', active TINYINT(1) NOT NULL DEFAULT 1, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset;\" );"}],"table_count":3}