{"slug":"ameliabooking","name":"Booking for Appointments and Events Calendar – Amelia","description":"Amelia is a powerful booking plugin for appointments and events. Manage scheduling, calendars, and availability with an all-in-one booking system.","author":"ameliabooking","active_installs":90000,"version":"2.2.1","wp_org_url":"https://wordpress.org/plugins/ameliabooking/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":true},"tables":[{"table_name":"amelia_","full_table_name":"wp_amelia_","description":"Stores amelia  data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"amelia_appointments","full_table_name":"wp_amelia_appointments","description":"Stores amelia appointments data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_appointments` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `status` enum('approved','pending','canceled','rejected','no-show') DEFAULT NULL,\\n  `bookingStart` datetime NOT NULL,\\n  `bookingEnd` datetime NOT NULL,\\n  `notifyParticipants` tinyint(1) NOT NULL,\\n  `createPaymentLinks` tinyint(1) DEFAULT '1',\\n  `serviceId` int NOT NULL,\\n  `packageId` int DEFAULT NULL,\\n  `providerId` int NOT NULL,\\n  `locationId` int DEFAULT NULL,\\n  `internalNotes` mediumtext,\\n  `googleCalendarEventId` varchar(255) DEFAULT NULL,\\n  `googleMeetUrl` varchar(255) DEFAULT NULL,\\n  `outlookCalendarEventId` varchar(255) DEFAULT NULL,\\n  `microsoftTeamsUrl` varchar(255) DEFAULT NULL,\\n  `appleCalendarEventId` varchar(255) DEFAULT NULL,\\n  `zoomMeeting` mediumtext,\\n  `lessonSpace` mediumtext,\\n  `parentId` int DEFAULT NULL,\\n  `error` mediumtext,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_cache","full_table_name":"wp_amelia_cache","description":"A cache table that stores temporary computed or fetched data.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_cache` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `name` varchar(255) NOT NULL,\\n  `paymentId` int DEFAULT NULL,\\n  `data` text,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_categories","full_table_name":"wp_amelia_categories","description":"Stores amelia categories data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_categories` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `status` enum('hidden','visible','disabled') NOT NULL DEFAULT 'visible',\\n  `name` varchar(255) NOT NULL DEFAULT '',\\n  `position` int NOT NULL,\\n  `translations` text,\\n  `color` varchar(255) NOT NULL DEFAULT '#1788FB',\\n  `pictureFullPath` varchar(767) DEFAULT NULL,\\n  `pictureThumbPath` varchar(767) DEFAULT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_coupons","full_table_name":"wp_amelia_coupons","description":"Stores amelia coupons data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_coupons` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,\\n  `discount` double NOT NULL,\\n  `deduction` double NOT NULL,\\n  `limit` double NOT NULL,\\n  `customerLimit` double NOT NULL DEFAULT '0',\\n  `status` enum('hidden','visible') NOT NULL,\\n  `notificationInterval` int NOT NULL DEFAULT '0',\\n  `notificationRecurring` tinyint(1) NOT NULL DEFAULT '0',\\n  `expirationDate` datetime DEFAULT NULL,\\n  `startDate` datetime DEFAULT NULL,\\n  `allServices` tinyint(1) NOT NULL DEFAULT '0',\\n  `allEvents` tinyint(1) NOT NULL DEFAULT '0',\\n  `allPackages` tinyint(1) NOT NULL DEFAULT '0',\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_coupons_to_events","full_table_name":"wp_amelia_coupons_to_events","description":"Stores amelia coupons to events data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_coupons_to_events` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `couponId` int NOT NULL,\\n  `eventId` int NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_coupons_to_packages","full_table_name":"wp_amelia_coupons_to_packages","description":"Stores amelia coupons to packages data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_coupons_to_packages` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `couponId` int NOT NULL,\\n  `packageId` int NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_coupons_to_services","full_table_name":"wp_amelia_coupons_to_services","description":"Stores amelia coupons to services data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_coupons_to_services` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `couponId` int NOT NULL,\\n  `serviceId` int NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_custom_fields","full_table_name":"wp_amelia_custom_fields","description":"Stores amelia custom fields data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_custom_fields` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `label` text,\\n  `type` enum('text','text-area','select','checkbox','radio','content','file','datepicker','address') NOT NULL DEFAULT 'text',\\n  `required` tinyint(1) NOT NULL DEFAULT '0',\\n  `position` int NOT NULL,\\n  `translations` text,\\n  `allServices` tinyint(1) DEFAULT NULL,\\n  `allEvents` tinyint(1) DEFAULT NULL,\\n  `useAsLocation` tinyint(1) DEFAULT NULL,\\n  `width` int NOT NULL DEFAULT '50',\\n  `saveType` enum('bookings','customer') NOT NULL DEFAULT 'bookings',\\n  `saveFirstChoice` tinyint(1) DEFAULT NULL,\\n  `includeInInvoice` tinyint(1) DEFAULT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_custom_fields_events","full_table_name":"wp_amelia_custom_fields_events","description":"Stores amelia custom fields events data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_custom_fields_events` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `customFieldId` int NOT NULL,\\n  `eventId` int NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_custom_fields_options","full_table_name":"wp_amelia_custom_fields_options","description":"Stores amelia custom fields options data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_custom_fields_options` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `customFieldId` int NOT NULL,\\n  `label` text,\\n  `position` int NOT NULL,\\n  `translations` text,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_custom_fields_services","full_table_name":"wp_amelia_custom_fields_services","description":"Stores amelia custom fields services data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_custom_fields_services` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `customFieldId` int NOT NULL,\\n  `serviceId` int NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_customer_bookings","full_table_name":"wp_amelia_customer_bookings","description":"Stores amelia customer bookings data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_customer_bookings` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `appointmentId` int DEFAULT NULL,\\n  `customerId` int NOT NULL,\\n  `status` enum('approved','pending','canceled','rejected','no-show','waiting') DEFAULT NULL,\\n  `price` double NOT NULL,\\n  `tax` varchar(255) DEFAULT NULL,\\n  `persons` int NOT NULL,\\n  `couponId` int DEFAULT NULL,\\n  `token` varchar(10) DEFAULT NULL,\\n  `customFields` text,\\n  `info` text,\\n  `utcOffset` int DEFAULT NULL,\\n  `aggregatedPrice` tinyint(1) DEFAULT '1',\\n  `packageCustomerServiceId` int DEFAULT NULL,\\n  `duration` int DEFAULT NULL,\\n  `created` datetime DEFAULT NULL,\\n  `actionsCompleted` tinyint(1) DEFAULT NULL,\\n  `qrCodes` text,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_customer_bookings_to_events_periods","full_table_name":"wp_amelia_customer_bookings_to_events_periods","description":"Stores amelia customer bookings to events periods data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_customer_bookings_to_events_periods` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `customerBookingId` bigint NOT NULL,\\n  `eventPeriodId` bigint NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `bookingEventPeriod` (`customerBookingId`,`eventPeriodId`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_customer_bookings_to_events_tickets","full_table_name":"wp_amelia_customer_bookings_to_events_tickets","description":"Stores amelia customer bookings to events tickets data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_customer_bookings_to_events_tickets` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `customerBookingId` bigint NOT NULL,\\n  `eventTicketId` bigint NOT NULL,\\n  `price` double DEFAULT '0',\\n  `persons` int NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_customer_bookings_to_extras","full_table_name":"wp_amelia_customer_bookings_to_extras","description":"Stores amelia customer bookings to extras data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_customer_bookings_to_extras` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `customerBookingId` int NOT NULL,\\n  `extraId` int NOT NULL,\\n  `quantity` int NOT NULL,\\n  `price` double NOT NULL,\\n  `tax` varchar(255) DEFAULT NULL,\\n  `aggregatedPrice` tinyint(1) DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `bookingExtra` (`customerBookingId`,`extraId`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_events","full_table_name":"wp_amelia_events","description":"Stores amelia events data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_events` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `parentId` bigint DEFAULT NULL,\\n  `name` varchar(255) NOT NULL DEFAULT '',\\n  `status` enum('approved','pending','canceled','rejected') NOT NULL,\\n  `bookingOpens` datetime DEFAULT NULL,\\n  `bookingCloses` datetime DEFAULT NULL,\\n  `bookingOpensRec` enum('same','calculate') DEFAULT 'same',\\n  `bookingClosesRec` enum('same','calculate') DEFAULT 'same',\\n  `ticketRangeRec` enum('same','calculate') DEFAULT 'calculate',\\n  `recurringCycle` enum('daily','weekly','monthly','yearly') DEFAULT NULL,\\n  `recurringOrder` int DEFAULT NULL,\\n  `recurringInterval` int DEFAULT '1',\\n  `recurringMonthly` enum('each','on') DEFAULT 'each',\\n  `monthlyDate` datetime DEFAULT NULL,\\n  `monthlyOnRepeat` enum('first','second','third','fourth','fifth','last') DEFAULT NULL,\\n  `monthlyOnDay` enum('monday','tuesday','wednesday','thursday','friday','saturday','sunday') DEFAULT NULL,\\n  `recurringUntil` datetime DEFAULT NULL,\\n  `maxCapacity` int NOT NULL,\\n  `maxCustomCapacity` int DEFAULT NULL,\\n  `maxExtraPeople` int DEFAULT NULL,\\n  `price` double NOT NULL,\\n  `locationId` bigint DEFAULT NULL,\\n  `customLocation` varchar(255) DEFAULT NULL,\\n  `description` mediumtext,\\n  `color` varchar(255) DEFAULT NULL,\\n  `show` tinyint(1) NOT NULL DEFAULT '1',\\n  `notifyParticipants` tinyint(1) NOT NULL,\\n  `created` datetime NOT NULL,\\n  `settings` mediumtext,\\n  `zoomUserId` varchar(255) DEFAULT NULL,\\n  `bringingAnyone` tinyint(1) DEFAULT '1',\\n  `bookMultipleTimes` tinyint(1) DEFAULT '1',\\n  `translations` text,\\n  `depositPayment` enum('disabled','fixed','percentage') DEFAULT 'disabled',\\n  `depositPerPerson` tinyint(1) DEFAULT '1',\\n  `fullPayment` tinyint(1) DEFAULT '0',\\n  `deposit` double DEFAULT '0',\\n  `customPricing` tinyint(1) DEFAULT '0',\\n  `organizerId` bigint DEFAULT NULL,\\n  `closeAfterMin` int DEFAULT NULL,\\n  `closeAfterMinBookings` tinyint(1) DEFAULT '0',\\n  `aggregatedPrice` tinyint(1) DEFAULT '1',\\n  `error` mediumtext,\\n  `pictureFullPath` varchar(767) DEFAULT NULL,\\n  `pictureThumbPath` varchar(767) DEFAULT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_events_periods","full_table_name":"wp_amelia_events_periods","description":"Stores amelia events periods data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_events_periods` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `eventId` bigint NOT NULL,\\n  `periodStart` datetime NOT NULL,\\n  `periodEnd` datetime NOT NULL,\\n  `zoomMeeting` mediumtext,\\n  `lessonSpace` mediumtext,\\n  `googleCalendarEventId` varchar(255) DEFAULT NULL,\\n  `googleMeetUrl` varchar(255) DEFAULT NULL,\\n  `outlookCalendarEventId` varchar(255) DEFAULT NULL,\\n  `microsoftTeamsUrl` varchar(255) DEFAULT NULL,\\n  `appleCalendarEventId` varchar(255) DEFAULT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_events_tags","full_table_name":"wp_amelia_events_tags","description":"Stores amelia events tags data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_events_tags` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `eventId` bigint NOT NULL,\\n  `name` varchar(255) NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_events_to_providers","full_table_name":"wp_amelia_events_to_providers","description":"Stores amelia events to providers data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_events_to_providers` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `eventId` bigint NOT NULL,\\n  `userId` bigint NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_events_to_tickets","full_table_name":"wp_amelia_events_to_tickets","description":"Stores amelia events to tickets data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_events_to_tickets` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `eventId` bigint NOT NULL,\\n  `enabled` tinyint(1) DEFAULT '1',\\n  `name` varchar(255) NOT NULL,\\n  `price` double DEFAULT '0',\\n  `dateRanges` text,\\n  `spots` int NOT NULL,\\n  `waitingListSpots` int NOT NULL,\\n  `translations` text,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_extras","full_table_name":"wp_amelia_extras","description":"Stores amelia extras data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_extras` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `name` varchar(255) NOT NULL DEFAULT '',\\n  `description` mediumtext,\\n  `price` double NOT NULL,\\n  `maxQuantity` int NOT NULL,\\n  `duration` int DEFAULT NULL,\\n  `serviceId` int NOT NULL,\\n  `position` int NOT NULL,\\n  `aggregatedPrice` tinyint(1) DEFAULT NULL,\\n  `translations` text,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_galleries","full_table_name":"wp_amelia_galleries","description":"Stores amelia galleries data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_galleries` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `entityId` int NOT NULL,\\n  `entityType` enum('service','event','package') NOT NULL,\\n  `pictureFullPath` varchar(767) DEFAULT NULL,\\n  `pictureThumbPath` varchar(767) DEFAULT NULL,\\n  `position` int NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_locations","full_table_name":"wp_amelia_locations","description":"Stores amelia locations data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_locations` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `status` enum('hidden','visible','disabled') NOT NULL DEFAULT 'visible',\\n  `name` varchar(255) NOT NULL DEFAULT '',\\n  `description` mediumtext,\\n  `address` varchar(255) NOT NULL,\\n  `phone` varchar(63) NOT NULL,\\n  `latitude` decimal(8,6) NOT NULL,\\n  `longitude` decimal(9,6) NOT NULL,\\n  `pictureFullPath` varchar(767) DEFAULT NULL,\\n  `pictureThumbPath` varchar(767) DEFAULT NULL,\\n  `pin` mediumtext,\\n  `translations` text,\\n  `countryPhoneIso` varchar(2) DEFAULT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_locations_views","full_table_name":"wp_amelia_locations_views","description":"Stores amelia locations views data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_locations_views` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `locationId` int NOT NULL,\\n  `date` date NOT NULL,\\n  `views` int NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `id` (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_notifications","full_table_name":"wp_amelia_notifications","description":"Stores amelia notifications data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_notifications` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `name` varchar(255) NOT NULL DEFAULT '',\\n  `customName` varchar(255) DEFAULT NULL,\\n  `status` enum('enabled','disabled') NOT NULL DEFAULT 'enabled',\\n  `type` enum('email','sms','whatsapp') NOT NULL,\\n  `entity` enum('appointment','event') NOT NULL DEFAULT 'appointment',\\n  `time` time DEFAULT NULL,\\n  `timeBefore` int DEFAULT NULL,\\n  `timeAfter` int DEFAULT NULL,\\n  `sendTo` enum('customer','provider') NOT NULL,\\n  `subject` varchar(255) NOT NULL DEFAULT '',\\n  `content` text,\\n  `translations` text,\\n  `sendOnlyMe` tinyint(1) DEFAULT '0',\\n  `whatsAppTemplate` varchar(255) DEFAULT NULL,\\n  `minimumTimeBeforeBooking` text,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_notifications_log","full_table_name":"wp_amelia_notifications_log","description":"A logging table that records activity, events, or audit history.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_notifications_log` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `notificationId` int NOT NULL,\\n  `userId` int DEFAULT NULL,\\n  `appointmentId` int DEFAULT NULL,\\n  `eventId` int DEFAULT NULL,\\n  `packageCustomerId` int DEFAULT NULL,\\n  `sentDateTime` datetime NOT NULL,\\n  `sent` tinyint(1) DEFAULT NULL,\\n  `data` text,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_notifications_sms_history","full_table_name":"wp_amelia_notifications_sms_history","description":"Stores amelia notifications sms history data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_notifications_sms_history` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `notificationId` int NOT NULL,\\n  `userId` int DEFAULT NULL,\\n  `appointmentId` int DEFAULT NULL,\\n  `eventId` int DEFAULT NULL,\\n  `packageCustomerId` int DEFAULT NULL,\\n  `logId` int DEFAULT NULL,\\n  `dateTime` datetime DEFAULT NULL,\\n  `text` varchar(1600) NOT NULL,\\n  `phone` varchar(63) NOT NULL,\\n  `alphaSenderId` varchar(11) NOT NULL,\\n  `status` enum('prepared','accepted','queued','sent','failed','delivered','undelivered') NOT NULL DEFAULT 'prepared',\\n  `price` double DEFAULT NULL,\\n  `segments` tinyint DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `id` (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_notifications_to_entities","full_table_name":"wp_amelia_notifications_to_entities","description":"Stores amelia notifications to entities data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_notifications_to_entities` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `notificationId` int NOT NULL,\\n  `entityId` int NOT NULL,\\n  `entity` enum('appointment','event') NOT NULL DEFAULT 'appointment',\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_packages","full_table_name":"wp_amelia_packages","description":"Stores amelia packages data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_packages` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `name` varchar(255) NOT NULL DEFAULT '',\\n  `description` mediumtext,\\n  `color` varchar(255) NOT NULL DEFAULT '',\\n  `price` double NOT NULL,\\n  `status` enum('hidden','visible','disabled') NOT NULL DEFAULT 'visible',\\n  `pictureFullPath` varchar(767) DEFAULT NULL,\\n  `pictureThumbPath` varchar(767) DEFAULT NULL,\\n  `position` int DEFAULT '0',\\n  `calculatedPrice` tinyint(1) DEFAULT '1',\\n  `discount` double NOT NULL,\\n  `endDate` datetime DEFAULT NULL,\\n  `durationType` enum('day','week','month') DEFAULT NULL,\\n  `durationCount` int DEFAULT NULL,\\n  `settings` mediumtext,\\n  `translations` text,\\n  `depositPayment` enum('disabled','fixed','percentage') DEFAULT 'disabled',\\n  `deposit` double DEFAULT '0',\\n  `fullPayment` tinyint(1) DEFAULT '0',\\n  `sharedCapacity` tinyint(1) DEFAULT '0',\\n  `quantity` int DEFAULT '1',\\n  `limitPerCustomer` text,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_packages_customers_to_services","full_table_name":"wp_amelia_packages_customers_to_services","description":"Stores amelia packages customers to services data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_packages_customers_to_services` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `packageCustomerId` int NOT NULL,\\n  `serviceId` int NOT NULL,\\n  `providerId` int DEFAULT NULL,\\n  `locationId` int DEFAULT NULL,\\n  `bookingsCount` int DEFAULT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_packages_services_to_locations","full_table_name":"wp_amelia_packages_services_to_locations","description":"Stores amelia packages services to locations data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_packages_services_to_locations` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `packageServiceId` int NOT NULL,\\n  `locationId` int NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `id` (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_packages_services_to_providers","full_table_name":"wp_amelia_packages_services_to_providers","description":"Stores amelia packages services to providers data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_packages_services_to_providers` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `packageServiceId` int NOT NULL,\\n  `userId` int NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `id` (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_packages_to_customers","full_table_name":"wp_amelia_packages_to_customers","description":"Stores amelia packages to customers data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_packages_to_customers` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `packageId` int NOT NULL,\\n  `customerId` int NOT NULL,\\n  `price` double NOT NULL,\\n  `tax` varchar(255) DEFAULT NULL,\\n  `start` datetime DEFAULT NULL,\\n  `end` datetime DEFAULT NULL,\\n  `purchased` datetime NOT NULL,\\n  `status` enum('approved','pending','canceled','rejected') DEFAULT NULL,\\n  `bookingsCount` int DEFAULT NULL,\\n  `couponId` int DEFAULT NULL,\\n  `token` varchar(10) DEFAULT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_packages_to_services","full_table_name":"wp_amelia_packages_to_services","description":"Stores amelia packages to services data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_packages_to_services` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `serviceId` int NOT NULL,\\n  `packageId` int NOT NULL,\\n  `quantity` int NOT NULL,\\n  `minimumScheduled` int DEFAULT '1',\\n  `maximumScheduled` int DEFAULT '1',\\n  `allowProviderSelection` tinyint(1) DEFAULT '1',\\n  `position` int DEFAULT '0',\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_payments","full_table_name":"wp_amelia_payments","description":"Stores amelia payments data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_payments` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `customerBookingId` int DEFAULT NULL,\\n  `amount` double NOT NULL DEFAULT '0',\\n  `dateTime` datetime DEFAULT NULL,\\n  `status` enum('paid','pending','partiallyPaid','refunded') NOT NULL,\\n  `gateway` enum('onSite','payPal','stripe','wc','mollie','razorpay','square','barion') NOT NULL,\\n  `gatewayTitle` varchar(255) DEFAULT NULL,\\n  `data` text,\\n  `packageCustomerId` int DEFAULT NULL,\\n  `parentId` int DEFAULT NULL,\\n  `entity` enum('appointment','event','package') DEFAULT NULL,\\n  `created` datetime DEFAULT NULL,\\n  `actionsCompleted` tinyint(1) DEFAULT NULL,\\n  `triggeredActions` tinyint(1) DEFAULT NULL,\\n  `wcOrderId` bigint DEFAULT NULL,\\n  `wcOrderItemId` bigint DEFAULT NULL,\\n  `transactionId` varchar(255) DEFAULT NULL,\\n  `transfers` text,\\n  `invoiceNumber` int DEFAULT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_providers_to_daysoff","full_table_name":"wp_amelia_providers_to_daysoff","description":"Stores amelia providers to daysoff data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_providers_to_daysoff` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `userId` int NOT NULL,\\n  `name` varchar(255) NOT NULL,\\n  `startDate` date NOT NULL,\\n  `endDate` date NOT NULL,\\n  `repeat` tinyint(1) NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `id` (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_providers_to_google_calendar","full_table_name":"wp_amelia_providers_to_google_calendar","description":"Stores amelia providers to google calendar data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_providers_to_google_calendar` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `userId` int NOT NULL,\\n  `token` text NOT NULL,\\n  `calendarId` text,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `id` (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_providers_to_locations","full_table_name":"wp_amelia_providers_to_locations","description":"Stores amelia providers to locations data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_providers_to_locations` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `userId` int NOT NULL,\\n  `locationId` int NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `id` (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_providers_to_outlook_calendar","full_table_name":"wp_amelia_providers_to_outlook_calendar","description":"Stores amelia providers to outlook calendar data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_providers_to_outlook_calendar` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `userId` int NOT NULL,\\n  `token` text NOT NULL,\\n  `calendarId` text,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `id` (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_providers_to_periods","full_table_name":"wp_amelia_providers_to_periods","description":"Stores amelia providers to periods data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_providers_to_periods` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `weekDayId` int NOT NULL,\\n  `locationId` int DEFAULT NULL,\\n  `startTime` time NOT NULL,\\n  `endTime` time NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `id` (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_providers_to_periods_location","full_table_name":"wp_amelia_providers_to_periods_location","description":"Stores amelia providers to periods location data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_providers_to_periods_location` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `periodId` int NOT NULL,\\n  `locationId` int NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `id` (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_providers_to_periods_services","full_table_name":"wp_amelia_providers_to_periods_services","description":"Stores amelia providers to periods services data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_providers_to_periods_services` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `periodId` int NOT NULL,\\n  `serviceId` int NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `id` (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_providers_to_services","full_table_name":"wp_amelia_providers_to_services","description":"Stores amelia providers to services data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_providers_to_services` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `userId` int NOT NULL,\\n  `serviceId` int NOT NULL,\\n  `price` double NOT NULL,\\n  `minCapacity` int NOT NULL,\\n  `maxCapacity` int NOT NULL,\\n  `customPricing` text,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `id` (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_providers_to_specialdays","full_table_name":"wp_amelia_providers_to_specialdays","description":"Stores amelia providers to specialdays data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_providers_to_specialdays` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `userId` int NOT NULL,\\n  `startDate` date NOT NULL,\\n  `endDate` date NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `id` (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_providers_to_specialdays_periods","full_table_name":"wp_amelia_providers_to_specialdays_periods","description":"Stores amelia providers to specialdays periods data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_providers_to_specialdays_periods` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `specialDayId` int NOT NULL,\\n  `locationId` int DEFAULT NULL,\\n  `startTime` time NOT NULL,\\n  `endTime` time NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `id` (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_providers_to_specialdays_periods_location","full_table_name":"wp_amelia_providers_to_specialdays_periods_location","description":"Stores amelia providers to specialdays periods location data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_providers_to_specialdays_periods_location` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `periodId` int NOT NULL,\\n  `locationId` int NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `id` (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_providers_to_specialdays_periods_services","full_table_name":"wp_amelia_providers_to_specialdays_periods_services","description":"Stores amelia providers to specialdays periods services data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_providers_to_specialdays_periods_services` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `periodId` int NOT NULL,\\n  `serviceId` int NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `id` (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_providers_to_timeouts","full_table_name":"wp_amelia_providers_to_timeouts","description":"Stores amelia providers to timeouts data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_providers_to_timeouts` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `weekDayId` int NOT NULL,\\n  `startTime` time NOT NULL,\\n  `endTime` time NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `id` (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_providers_to_weekdays","full_table_name":"wp_amelia_providers_to_weekdays","description":"Stores amelia providers to weekdays data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_providers_to_weekdays` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `userId` int NOT NULL,\\n  `dayIndex` tinyint NOT NULL,\\n  `startTime` time NOT NULL,\\n  `endTime` time NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `id` (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_providers_views","full_table_name":"wp_amelia_providers_views","description":"Stores amelia providers views data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_providers_views` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `userId` int NOT NULL,\\n  `date` date NOT NULL,\\n  `views` int NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `id` (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_resources","full_table_name":"wp_amelia_resources","description":"Stores amelia resources data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_resources` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `name` varchar(255) NOT NULL DEFAULT '',\\n  `quantity` int DEFAULT '1',\\n  `shared` enum('service','location') DEFAULT NULL,\\n  `status` enum('hidden','visible','disabled') NOT NULL DEFAULT 'visible',\\n  `countAdditionalPeople` tinyint(1) DEFAULT '0',\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_resources_to_entities","full_table_name":"wp_amelia_resources_to_entities","description":"Stores amelia resources to entities data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_resources_to_entities` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `resourceId` int NOT NULL,\\n  `entityId` int NOT NULL,\\n  `entityType` enum('service','location','employee') NOT NULL DEFAULT 'service',\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_services","full_table_name":"wp_amelia_services","description":"Stores amelia services data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_services` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `name` varchar(255) NOT NULL DEFAULT '',\\n  `description` mediumtext,\\n  `color` varchar(255) NOT NULL DEFAULT '',\\n  `price` double NOT NULL,\\n  `status` enum('hidden','visible','disabled') NOT NULL DEFAULT 'visible',\\n  `categoryId` int NOT NULL,\\n  `minCapacity` int NOT NULL,\\n  `maxCapacity` int NOT NULL,\\n  `duration` int NOT NULL,\\n  `timeBefore` int DEFAULT '0',\\n  `timeAfter` int DEFAULT '0',\\n  `bringingAnyone` tinyint(1) DEFAULT '1',\\n  `priority` enum('least_expensive','most_expensive','least_occupied','most_occupied') NOT NULL,\\n  `pictureFullPath` varchar(767) DEFAULT NULL,\\n  `pictureThumbPath` varchar(767) DEFAULT NULL,\\n  `position` int DEFAULT '0',\\n  `show` tinyint(1) DEFAULT '1',\\n  `aggregatedPrice` tinyint(1) DEFAULT '1',\\n  `settings` mediumtext,\\n  `recurringCycle` enum('disabled','all','daily','weekly','monthly') DEFAULT 'disabled',\\n  `recurringSub` enum('disabled','past','future','both') DEFAULT 'future',\\n  `recurringPayment` int DEFAULT '0',\\n  `translations` text,\\n  `depositPayment` enum('disabled','fixed','percentage') DEFAULT 'disabled',\\n  `depositPerPerson` tinyint(1) DEFAULT '1',\\n  `deposit` double DEFAULT '0',\\n  `fullPayment` tinyint(1) DEFAULT '0',\\n  `mandatoryExtra` tinyint(1) DEFAULT '0',\\n  `minSelectedExtras` int DEFAULT '0',\\n  `customPricing` text,\\n  `maxExtraPeople` int DEFAULT NULL,\\n  `limitPerCustomer` text,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_services_views","full_table_name":"wp_amelia_services_views","description":"Stores amelia services views data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_services_views` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `serviceId` int NOT NULL,\\n  `date` date NOT NULL,\\n  `views` int NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `id` (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_taxes","full_table_name":"wp_amelia_taxes","description":"Stores amelia taxes data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_taxes` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,\\n  `amount` double NOT NULL,\\n  `type` enum('percentage','fixed') NOT NULL,\\n  `status` enum('hidden','visible') NOT NULL,\\n  `allServices` tinyint(1) NOT NULL DEFAULT '0',\\n  `allEvents` tinyint(1) NOT NULL DEFAULT '0',\\n  `allPackages` tinyint(1) NOT NULL DEFAULT '0',\\n  `allExtras` tinyint(1) NOT NULL DEFAULT '0',\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_taxes_to_entities","full_table_name":"wp_amelia_taxes_to_entities","description":"Stores amelia taxes to entities data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_taxes_to_entities` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `taxId` int NOT NULL,\\n  `entityId` int NOT NULL,\\n  `entityType` enum('service','extra','event','package') NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"},{"table_name":"amelia_users","full_table_name":"wp_amelia_users","description":"Stores amelia users data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_amelia_users` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `status` enum('hidden','visible','disabled','blocked') NOT NULL DEFAULT 'visible',\\n  `type` enum('customer','provider','manager','admin') NOT NULL,\\n  `externalId` bigint DEFAULT NULL,\\n  `firstName` varchar(255) NOT NULL DEFAULT '',\\n  `lastName` varchar(255) NOT NULL DEFAULT '',\\n  `email` varchar(255) DEFAULT NULL,\\n  `birthday` date DEFAULT NULL,\\n  `phone` varchar(63) DEFAULT NULL,\\n  `gender` enum('male','female') DEFAULT NULL,\\n  `note` text,\\n  `description` text,\\n  `pictureFullPath` varchar(767) DEFAULT NULL,\\n  `pictureThumbPath` varchar(767) DEFAULT NULL,\\n  `password` varchar(128) DEFAULT NULL,\\n  `usedTokens` text,\\n  `zoomUserId` varchar(255) DEFAULT NULL,\\n  `stripeConnect` varchar(255) DEFAULT NULL,\\n  `countryPhoneIso` varchar(2) DEFAULT NULL,\\n  `translations` text,\\n  `customFields` text,\\n  `timeZone` varchar(255) DEFAULT NULL,\\n  `appleCalendarId` varchar(255) DEFAULT NULL,\\n  `employeeAppleCalendar` text,\\n  `googleCalendarId` varchar(255) DEFAULT NULL,\\n  `outlookCalendarId` varchar(255) DEFAULT NULL,\\n  `badgeId` int DEFAULT NULL,\\n  `error` mediumtext,\\n  `show` tinyint(1) DEFAULT '1',\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `id` (`id`),\\n  UNIQUE KEY `email` (`email`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3"}],"table_count":58}