{"slug":"emsb-service-booking","name":"Doctor Appointment Booking Plugin – EMSB","description":"Allow your customers to book your service like appointment, event, reservation, etc. Manage your bookings through wp admin dashboard.","author":"Booking Plugin","active_installs":70,"version":"1.2.2","wp_org_url":"https://wordpress.org/plugins/emsb-service-booking/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"emsb_bookings","full_table_name":"wp_emsb_bookings","description":"Stores emsb bookings data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11) UNSIGNED","nullable":true,"primary_key":true},{"name":"approve_booking","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"service_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"service_name","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"service_price","type":"text","nullable":true,"primary_key":false},{"name":"booked_date_id","type":"text","nullable":true,"primary_key":false},{"name":"booked_slot_id","type":"text","nullable":true,"primary_key":false},{"name":"booked_date","type":"text","nullable":true,"primary_key":false},{"name":"booked_time_slot","type":"text","nullable":true,"primary_key":false},{"name":"customer_name","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"customer_email","type":"text","nullable":true,"primary_key":false},{"name":"customer_phone","type":"text","nullable":true,"primary_key":false},{"name":"booking_time","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"customer_IP","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"starting_time_ms","type":"BIGINT","nullable":false,"primary_key":false},{"name":"available_orders","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_emsb_bookings ( `id` int(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY, `approve_booking` varchar(20), `service_id` int(11) NOT NULL, `service_name` varchar(200), `service_price` text, `booked_date_id` text, `booked_slot_id` text, `booked_date` text, `booked_time_slot` text, `customer_name` varchar(200), `customer_email` text, `customer_phone` text, `booking_time` TIMESTAMP NOT NULL, `customer_IP` VARCHAR(100) NOT NULL, `starting_time_ms` BIGINT NOT NULL, `available_orders` int(11) NOT NULL ) ENGINE"},{"table_name":"emsb_settings","full_table_name":"wp_emsb_settings","description":"Stores emsb settings data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11) UNSIGNED","nullable":true,"primary_key":true},{"name":"date","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"admin_mail_subject","type":"text","nullable":true,"primary_key":false},{"name":"admin_mail_body","type":"text","nullable":true,"primary_key":false},{"name":"customer_mail_pending_subject","type":"text","nullable":true,"primary_key":false},{"name":"customer_mail_pending_body","type":"text","nullable":true,"primary_key":false},{"name":"customer_mail_confirmed_subject","type":"text","nullable":true,"primary_key":false},{"name":"customer_mail_confirmed_body","type":"text","nullable":true,"primary_key":false},{"name":"customer_mail_cancel_subject","type":"text","nullable":true,"primary_key":false},{"name":"customer_mail_cancel_body","type":"text","nullable":true,"primary_key":false},{"name":"customer_cookie_duration","type":"int(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_emsb_settings ( `id` int(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY, `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `admin_mail_subject` text, `admin_mail_body` text, `customer_mail_pending_subject` text, `customer_mail_pending_body` text, `customer_mail_confirmed_subject` text, `customer_mail_confirmed_body` text, `customer_mail_cancel_subject` text, `customer_mail_cancel_body` text, `customer_cookie_duration` int(11) ) ENGINE"}],"table_count":2}