{"slug":"easy-booked","name":"Easy Booked – Appointment Booking and Scheduling Management System for WordPress","description":"A comprehensive appointment booking calendar and scheduling management system for WordPress.","author":"MD Abu Jubayer Hossain","active_installs":100,"version":"2.4.11","wp_org_url":"https://wordpress.org/plugins/easy-booked/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"abs_calendar","full_table_name":"wp_abs_calendar","description":"Stores abs calendar data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT(10) UNSIGNED","nullable":true,"primary_key":true},{"name":"name","type":"VARCHAR(150)","nullable":false,"primary_key":false},{"name":"booking_type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"appointment_type","type":"VARCHAR(25)","nullable":false,"primary_key":false},{"name":"appointment_default","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"status","type":"INT(2)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_abs_calendar ( id INT(10) UNSIGNED AUTO_INCREMENT, name VARCHAR(150) NOT NULL, booking_type VARCHAR(50) NOT NULL, appointment_type VARCHAR(25) NOT NULL, appointment_default VARCHAR(50) NOT NULL, status INT(2) DEFAULT 0, PRIMARY KEY (id) ) $charset_collate\"; $this->table_migrate( $abs_calendar );"},{"table_name":"abs_custom_time_slots","full_table_name":"wp_abs_custom_time_slots","description":"Stores abs custom time slots data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT(10) UNSIGNED","nullable":true,"primary_key":true},{"name":"calendar_id","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"start_date","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"end_date","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"slots_type","type":"INT(2)","nullable":true,"primary_key":false},{"name":"title","type":"VARCHAR(250)","nullable":true,"primary_key":false},{"name":"booking_time","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"space_available","type":"INT(10)","nullable":true,"primary_key":false},{"name":"booked_space","type":"INT(10)","nullable":true,"primary_key":false},{"name":"product","type":"INT(50)","nullable":true,"primary_key":false},{"name":"booked_space_cancel","type":"INT(10)","nullable":true,"primary_key":false},{"name":"status","type":"INT(2)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_abs_custom_time_slots ( id INT(10) UNSIGNED AUTO_INCREMENT, calendar_id VARCHAR(10) NOT NULL, start_date VARCHAR(20) NOT NULL, end_date VARCHAR(20) NOT NULL, slots_type INT(2) DEFAULT NULL, title VARCHAR(250) DEFAULT NULL, booking_time VARCHAR(20) DEFAULT NULL, space_available INT(10) DEFAULT NULL, booked_space INT(10) DEFAULT 1, product INT(50) DEFAULT NULL, booked_space_cancel INT(10) DEFAULT 0, status INT(2) DEFAULT 0, PRIMARY KEY (id) ) $charset_collate\"; $this->table_migrate( $custom_time_slots_schema );"},{"table_name":"abs_time_slots","full_table_name":"wp_abs_time_slots","description":"Stores abs time slots data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT(10) UNSIGNED","nullable":true,"primary_key":true},{"name":"calendar_id","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"day_name","type":"VARCHAR(15)","nullable":false,"primary_key":false},{"name":"title","type":"VARCHAR(250)","nullable":true,"primary_key":false},{"name":"booking_time","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"space_available","type":"INT(10)","nullable":false,"primary_key":false},{"name":"booked_space","type":"INT(10 )","nullable":true,"primary_key":false},{"name":"product","type":"INT(50)","nullable":true,"primary_key":false},{"name":"booked_space_cancel","type":"INT(10 )","nullable":true,"primary_key":false},{"name":"status","type":"INT(2)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_abs_time_slots ( id INT(10) UNSIGNED AUTO_INCREMENT, calendar_id VARCHAR(10) NOT NULL, day_name VARCHAR(15) NOT NULL, title VARCHAR(250) DEFAULT NULL, booking_time VARCHAR(20) NOT NULL, space_available INT(10) NOT NULL, booked_space INT(10 ) DEFAULT 0, product INT(50) DEFAULT NULL, booked_space_cancel INT(10 ) DEFAULT 0, status INT(2) DEFAULT 0, PRIMARY KEY (id) ) $charset_collate\"; $this->table_migrate( $time_slots_schema );"}],"table_count":3}